Java

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.

Arman S. wrote:

Agreed - generally speaking. But not quite, for this concrete situation.
If it were so, why wouldn't you go ahead and explain the whole theory behind secure Web development to the OP?
Common sense tells me, that you (and I) didn't do it as:
* We are not sure if it will solve a bit of OP's problem
* We are not sure if OP is even doing e.g. Web
* We are not sure if the proposed solution above (by myself) even targets the right problem (because of poor explanation of the problem)

My belief is that for beginners (assuming OP is) what matters most is the tangible result, something they can see and the feeling that something is working.

Arman S. wrote:

My belief is that for beginners (assuming OP is) what matters most is the tangible result, something they can see and the feeling that something is working.

String dbURL = "jdbc:derby:....";

String myString = (String) getIncidentidtxt().getValue();
Integer incidentIDName = Integer.parseInt(myString);
  String incidentNameName = (String)getIncidentnametxt().getValue();

  try{

      Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

      Connection con = DriverManager.getConnection(dbURL);

      Statement stmt = con.createStatement();

      ResultSet rs = stmt.executeQuery("SELECT INCIDENTID FROM INCIDENTDATA");

      //Create New Array
      ArrayList allResults = new ArrayList();

      while (rs.next()) {
          int instanceID = rs.getInt("INCIDENTID");
          allResults.add(instanceID);
          // size of the array
          int arrayCount = allResults.size();
          label3.setValue(arrayCount);

          for(Integer i =0; i<allResults.size(); i++)
          {
          if(myString.equals(allResults.get(i))){

          }
       }

              }
        }

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

   String incidentString = (String) getIncidentidtxt().getValue();
 
        String incidentNameName = (String)getIncidentenametxt().getValue();

try{
        
         Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

        Connection con = DriverManager.getConnection(dbURL);

        stmt = con.createStatement();

        if(incidenteidtxt != null){
        rs = stmt.executeQuery("Select INCIDENTID from INCIDENTDATA");
        
        while(rs.next()){
  
          id = rs.getString("INCIDENTID");           
          String idtxt = id.toString();

            if(incidentString != idtxt){

                getSessionBean1().updateIncident(incidentString, incidentNameName);
      
            }

            else{

          incidentidtxt.setRequiredMessage("Id valid, enter new Id.");
               
        }
            }

        }
        }

           catch (Exception ex) {

        log("ErrorDescription", ex);
              error(ex.getMessage());
    }

pancakeleh wrote:

however i am rushing out this.

if(incidenteidtxt != null){

     try{

     Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();

    Connection con = DriverManager.getConnection(dbURL);

    stmt = con.createStatement();

    if(incidentidtxt != null){
  // rs = stmt.executeQuery("Select INCIDENTID from INCIDENTDATA where INCIDENTID = "+incidentStringNo+";");

         id = rs.getInt(1);

        if( id == 0){


            getSessionBean1().updateIncident(incidentId, instanceName);

        }

        else{

    Integer newIncidentID =  incidentId + 1;

     getSessionBean1().updateIncident(newIncidentID, instanceName);
    }

    }
    //}
    }

  catch (Exception ex) {

    log("ErrorDescription", ex);
          error(ex.getMessage());
}
    return null;
}

pancakeleh wrote:

 if(incidentidtxt != null){
// rs = stmt.executeQuery("Select INCIDENTID from INCIDENTDATA where INCIDENTID = "+incidentStringNo+";");