Java登陆界面连接数据库问题
登陆界面连接了数据库,但总是提示秘密错误,和数据库中的用户名密码对照过了,并没有错,求大神指点迷津
BLogin.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent e){
String Apassword=LenPassWord.getText().trim();
String AUserID=LenUserID.getText().trim();
if(AUserID.equals("admin")&&Apassword.equals("123456")){
new ChooseFountion().init();
jf.dispose();
}else{
Connection conn=null;
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select UserPassword from [user] where UserName='"+AUserID+"'";
try{
conn=DBConnection.getConnection();
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
if(rs.next()){
if(rs.getString("UserPassword").equals(Apassword)){
new UserChooseFountion().init();
}else{
JOptionPane.showMessageDialog(jf, "密码错误,请重新输入!",
"登陆失败",JOptionPane.ERROR_MESSAGE);
}
}else{
JOptionPane.showMessageDialog(jf, "用户名不存在,请重新输入",
"登陆失败",JOptionPane.ERROR_MESSAGE);
}
rs.close();
}catch(SQLException e1){
e1.printStackTrace();
}catch(Exception e1){
e1.printStackTrace();
}finally{
try {
DBConnection.close(rs,pstmt,conn);
} catch (Exception e1) {
e1.printStackTrace();
}
}
}
}
});