Thread: ResultSet and variable to be define.

Hello everybody

I have problem with my variables.
The data's of my table enfts are :

1234 Eric 1/1/2000
1234 Patrick 23/4/2010

When 1234 is selected then Eric and Patrick appair in my Combobox cboChildName.


Eric appairs first end Patrick at the second place and that's OK.
But the birthdate of Eric is 23/4/2010 instead of 1/1/2000. It's appairs in a texfield TxtChildBirth.

id, firstname et naiss are correct

What's the problem please.

Habiler

    private void cboNatureActionPerformed(java.awt.event.ActionEvent evt) {                                          
    // TODO add your handling code here:
   if (cboNature.getSelectedItem().toString().equalsIgnoreCase("412")){
 
               jPanel2.setVisible(true);
   conn = ConnectDecisions.ConnectDB();
   int MatrSelect = Integer.parseInt(txtMatricule.getText());
 
   try {
   PreparedStatement stmt = conn.prepareStatement("select EMPLOYEENBR,CHILDNAME,BIRTHDATE from Enfts where EMPLOYEENBR = '"+ MatrSelect+"'");
   ResultSet rs = stmt.executeQuery();
 
  System.out.println("SQL Statement:\n\t" + MatrSelect);
 
                     while(rs.next()) {
           			String id = rs.getString("EMPLOYEENBR");
				String firstName = rs.getString("CHILDNAME");
				String Naiss = rs.getString("BIRTHDATE");
				System.out.println("ID: " + id + ", First Name: " + firstName + ",BIRTHDATE: " + Naiss);            
                     cboChildName.addItem(firstName);
                     txtChildBirth.setText(Naiss); 
            } 
                   } catch (SQLException ex) {
                       Logger.getLogger(AddData.class.getName()).log(Level.SEVERE, null, ex);
                   }
   }
else {
  jPanel2.setVisible(false);
}
 
    }

1234 Eric 1/1/2000
1234 Patrick 23/4/2010

That's OK.

But cboChildName.addItem(firstName); Eric
txtChildBirth.setText(Naiss); 24/4/2010

How can i put the right birthdate in txtChildBirth

Annotation 2019-03-13 203855.jpg

Sorry Norm

SQL Statement:
3478
ID: 3478.0, First Name: HABILS JULIEN,BIRTHDATE: 1993-05-24 00:00:00.000000
ID: 3478.0, First Name: HABILS THIBAULT,BIRTHDATE: 1996-06-27 00:00:00.000000

iN POST #3 THERE ARE fakes data.

Hello everybody

I have problem with my variables.
The data's of my table enfts are :

1234 Eric 1/1/2000
1234 Patrick 23/4/2010

In reality

3478 HABILS JULIEN 1993-05-24
3478 HABILS THIBAULT 1996-06-27

But cboChildName.addItem(firstName); HABILS THIBAULT
txtChildBirth.setText(Naiss); 1996-06-27

Sorry

3478 HABILS JULIEN 1993-05-24
3478 HABILS THIBAULT 1996-06-27

But cboChildName.addItem(firstName); HABILS JULIEN
txtChildBirth.setText(Naiss); 1996-06-27

--- Update ---

Sorry

3478 HABILS JULIEN 1993-05-24
3478 HABILS THIBAULT 1996-06-27

But cboChildName.addItem(firstName); HABILS JULIEN
txtChildBirth.setText(Naiss); 1996-06-27

Originally Posted by Norm

What is cboChildName? Is it a list? If it is, there should be two items (the two names) in the list after the while loop executes.
What is txtChildBirth? Is it a text field? It can only hold one value. After the loop, it will have the last value passed to it in the loop. Preceding values will be replaced.

How can i store the righy value in this case the birthdate of Julien (24/5/1993) in txtChildBirth.