// 查找選擇的狀態對應的id
sql1 = " select stateId from state where stateMessage = '"
+ stateBean.getStateMessage() + "' ";
ResultSet rs1 = con.executeQuery(sql1);
try {
while (rs1.next()) {
stateId = String.valueOf(rs1.getInt(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
// 查找選擇的管理員對應的id
sql2 = " select adminId from admin where adminRealName = '"
+ adminBean.getAdminRealName() + "' ";
ResultSet rs2 = con.executeQuery(sql2);
try {
while (rs2.next()) {
adminId = String.valueOf(rs1.getInt(1));
}
} catch (SQLException e) {
e.printStackTrace();
}