Thread: JComboBox fill with text after selected another JComboBox conected with database SQLlite

Can someone please advise me. is it possible to change JComboBox (in my case comboBoxGenderIDCard ) item based on selected item from another JComboBox (in ma case comboBoxIDNumberIDCard), which is connected to the SQLite database (my case employee).

This is the code:
comboBoxIDNumberIDCard = new JComboBox();
comboBoxIDNumberIDCard.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try {
String sql ="select * from employee where EmployeeID=?";
PreparedStatement pst = conn.prepareStatement(sql);
pst.setString(1, (String)comboBoxIDNumberIDCard.getSelectedItem());

ResultSet rs=pst.executeQuery();

while(rs.next()){
txtnameIDCard.setText(rs.getString("Firstname")); // for JText working perfectly
txtIDSurname.setText(rs.getString("Surname"));

comboBoxGenderIDCard.addItem(rs.getString("Gender" )); // I tried this code, but is not working!
}
}catch (Exception e1) {
e1.printStackTrace();
}
}
});

My first JComboBox (comboBoxGenderIDCard) item is defined already (two option Male or Female).


JComboBox<String> comboBoxGenderIDCard = new JComboBox<String>();
comboBoxGenderIDCard.setEditable(true);
comboBoxGenderIDCard.addItem("Select");
comboBoxGenderIDCard.addItem("Male");
comboBoxGenderIDCard.addItem("Female");
comboBoxGenderIDCard.setBounds(138, 167, 182, 19);
IDEmployeeCard.add(comboBoxGenderIDCard);