java additem 错,java - JComboBox中的executeQuery选择项错误 - SO中文参考 - www.soinside.com...

我有3个JComboBox中。第一个是对房型。当我在第一个JComboBox中选择房型它必须显示在第二JComboBox中所有可用的房间，但是当我选择房间类型之一，一个错误弹出u.p

下面是的actionPerformed第一JComboBox中的代码

第一JComboBox中的actionPerformed *

if(jComboBox13.getSelectedItem().toString().equals("SELECT")){

}else{

try{

String like = jComboBox13.getSelectedItem().toString();

String sql = "Select * From Room_Master\n" +

"inner join Room_Type on Room_Master.Room_Type_ID=Room_Type.Room_Type_ID\n" +

"where Room_Type = '"+like+"'";

pst = conn.prepareStatement(sql);

rs = pst.executeQuery();

jComboBox14.removeAllItems();

jComboBox14.addItem("SELECT");

while(rs.next()){

String add1 = rs.getString("Room_No.");

jComboBox14.addItem(add1);

}

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

}finally {

try {

rs.close();

pst.close();

}catch(Exception e){

}

}

}

第二JComboBox中的actionPerformed

if(jComboBox14.getSelectedItem().toString().equals("SELECT") | jComboBox14.getSelectedItem().toString().isEmpty()){

}else{

try{

String like = jComboBox14.getSelectedItem().toString();

String sql = "Select * from Bed_Master\n" +

"inner join Room_Master on Bed_Master.Room_ID=Room_Master.Room_ID\n" +

"where [Room_No.] = '"+like+"'";

pst = conn.prepareStatement(sql);

rs = pst.executeQuery();

jComboBox15.removeAllItems();

jComboBox15.addItem("SELECT");

while(rs.next()){

String add1 = rs.getString("Bed_No.");

jComboBox15.addItem(add1);

}

}catch(Exception e){

JOptionPane.showMessageDialog(null, e);

e.printStackTrace();

}finally {

try {

rs.close();

pst.close();

}catch(Exception e){

}

}

}

但之后，我选择其他房型，将工作我试图删除“combobox.removeAllItems();”但它会继续addding所有项目中的JComboBox几乎1周试图弄明白有人可以帮助请