Thread: JcomboBox showing only one item

Whats wrong with my code? the second JcomboBox is showing only one item even if there is more in the database.

@Override
	public void actionPerformed(ActionEvent e) {
		Object o = e.getSource();
		if(o == comboBox1) {			
			Object matricule =  comboBox1.getSelectedItem();
			String sqll = "Select  * FROM clients WHERE matricule = " +matricule;				
 
				try {
					rs = stat.executeQuery(sqll);
					while(rs.next()) {
						nom.setText(rs.getString("nom"));
						prenom.setText(rs.getString("prenom"));
						cin.setText(rs.getString("cin"));
						adresse.setText(rs.getString("adresse"));					
					}
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}	
 
			comboBox2.removeAllItems();
 
			Object index = comboBox1.getSelectedItem();
			String sql = "Select  distinct p.code FROM parcelle p, clients c WHERE c.matricule = p.exploitant AND c.matricule = " +index;
 
				try {
					rs = stat.executeQuery(sql);
					while(rs.next()) {
						System.out.println(rs.getInt("code"));
						comboBox2.addItem(rs.getInt("code"));
					}
				} catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}			
			return;
		}		
 
             Object code =  comboBox2.getSelectedItem();  
             String sqll = "Select  * FROM parcelle WHERE code = " +code;  
 
             try {  
                 rs = stat.executeQuery(sqll);                     
 
                 while(rs.next()) {  
                     sau.setText(rs.getString("sau"));  
                     sol.setText(rs.getString("type_sol"));  
                     irrigation.setText(rs.getString("mode_irrigation"));  
                     exploitation.setText(rs.getString("type_exploitation"));                      
                 }  
 
             } catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
			}		
	}

Yes the query return more than one:


The println print out just one.

I expect for exemple 10 and 11 but it only prints 10.
I just realised that if i delete this part:

Object code =  comboBox2.getSelectedItem();  
             String sqll = "Select  * FROM parcelle WHERE code = " +code;  
 
             try {  
                 rs = stat.executeQuery(sqll);                     
 
                 while(rs.next()) {  
                     sau.setText(rs.getString("sau"));  
                     sol.setText(rs.getString("type_sol"));  
                     irrigation.setText(rs.getString("mode_irrigation"));  
                     exploitation.setText(rs.getString("type_exploitation"));                      
                 }  
 
             } catch (SQLException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
			}

It works perfectly but i need some Jlabels to be filled with data from the second comboBox item choice.

Just as a thought, could you try the getItemCount() method in a println to check to see how many items are indeed in the ComboBox?

That way you could tell if only one item is being added or if there's more than one but somehow only one is showing up.