1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91
|
final JComboBox comboBox1 = new JComboBox();
final JComboBox comboBox2 = new JComboBox();
try {
String sql = "Select matricule FROM clients";
rs = stat.executeQuery(sql);
comboBox1.addItem("Select item");
while(rs.next()) {
comboBox1.addItem(rs.getInt("matricule"));
}
} catch (SQLException e) {
e.printStackTrace();
}
comboBox1.addItemListener(new ItemListener() {
public void itemStateChanged(ItemEvent arg0) {
int matricule = (Integer) 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 e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql = "Select p.code FROM parcelle p, clients c WHERE c.matricule = p.exploitant AND c.matricule = " +matricule;
try {
rs = stat.executeQuery(sql);
while(rs.next()) {
comboBox2.addItem(rs.getInt("code"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
});
comboBox1.setBounds(154, 317, 105, 20);
contentPane.add(comboBox1);
comboBox2.addItemListener(new ItemListener() {
public void itemStateChanged(ItemEvent arg0) {
int code = (Integer) 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 e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
});
comboBox2.setBounds(154, 423, 105, 20);
contentPane.add(comboBox2); |
Partager