Java

package app.gui; // the GUI in general
package app.gui.page; // the pages of the GUI
package app.gui.page.view; // parts of the pages

package app.database; // the database
package app.database.type.person; // the person aka the object 'Person' is in here
package app.database.type.person.extremity; // obejcts 'Leg' and 'Arm' are declared here - a person can have more than one of each.

package app.services;
package app.services.actions; // things the person can do like "Running", "Working", "Sleeping"
package app.services.status; // providing status messages about the person "EnergieStatus", "HealthStatus"

pancakeleh wrote:

i am able to but when i would want to add back the id 3 i am unable to. why is this so?

pancakeleh wrote:

And how can i compare the values of the textboxes with the table to check if the values keyed in textboxes does not appears in the table twice?

pancakeleh wrote:

Needing urgent help

ResultSet resultSet = statement.executeQuery("SELECT COUNT(INCIDENTID) FROM INCIDENTDATA");

try{

        Connection con = DriverManager.getConnection( );------------------------> Not sure what to include here.

        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA");
        ArrayList allResults = new ArrayList();

        while (rs.next()) {
       
           int incidentID = rs.getInt("INCIDENTID");

            allResults.add(incidentID);

            }
	}

    catch (Exception ex) {
                  log("ErrorDescription", ex);
              error(ex.getMessage());

 }

String myKey = myTextBox.getText(); // something like this to get the value from the textbox

Statement stmt = con.createStatement();
// change the PERSONNAME with an appropriate column from your table INCIDENTDATA.
ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA WHERE PERSONNAME = '" + myKey + "'");

// And the rest is the same...

Arman S. wrote:

ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA WHERE PERSONNAME = '" + myKey + "'");

Arman S. wrote:

the OP should first realize the existence of such a construct and then understand it's disadvantages.