我想在我的用户配置文件表中检查员工类型,并选择用户验证何时完成将为该用户加载的内容。
private void jButtonActionPerformed(java.awt.event.ActionEvent evt){
Connection conn = null;
PreparedStatement ps,ps2;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/hotelmgt","root","");
ps = conn.prepareStatement("SELECT * FROM userprofile WHERE userName = ? AND passWord = ?");
ps2 = conn.prepareStatement("SELECT* FROM userprofile");
ps.setString(1, jTextField_userName.getText());
ps.setString(2, String.valueOf(jPasswordField_login.getPassword()));
ResultSet rs = ps.executeQuery();
ResultSet rs2 = ps2.executeQuery();
if(rs.next()){
while(rs2.next()){
String userType = rs2.getString("emp_Type");
if(userType.equals("ADMIN")){
this.setVisible(false);
Admin_Panel ap = new Admin_Panel();
ap.setVisible(true);
break;
}else if(userType.equals("RCEP")){
this.setVisible(false);
Admin_Panel ap = new Admin_Panel();
ap.setVisible(false);
Reception rcep = new Reception();
rcep.setVisible(true);
break;
}
}
}else{
conn.close();
JOptionPane.showMessageDialog(this,"UserName Or Password Invalid");
}
} catch (SQLException ex) {
Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
}
}
您为什么使用 to 查询此任务?我想你可能想要这样的东西。
private void jButtonActionPerformed(java.awt.event.ActionEvent evt){
Connection conn = null;
PreparedStatement ps = null;
try {
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/hotelmgt","root","");
ps = conn.prepareStatement("SELECT * FROM userprofile WHERE userName = ? AND passWord = ?");
ps.setString(1, jTextField_userName.getText());
ps.setString(2, String.valueOf(jPasswordField_login.getPassword()));
ResultSet rs = ps.executeQuery();
if(rs.next()){
String userType = rs.getString("emp_Type");
if (userType.equals("ADMIN")){
this.setVisible(false);
Admin_Panel ap = new Admin_Panel();
ap.setVisible(true);
break;
} else (userType.equals("RCEP")){
this.setVisible(false);
Admin_Panel ap = new Admin_Panel();
ap.setVisible(false);
Reception rcep = new Reception();
rcep.setVisible(true);
break;
}
} else{
conn.close();
JOptionPane.showMessageDialog(this,"UserName Or Password Invalid");
}
} catch (SQLException ex) {
Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
}
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句