81,087
社区成员
发帖
与我相关
我的任务
分享
public boolean matchNamePwd(User u){
if(u == null) {
return false;
}
String name = u.getName();
String pwd = u.getPwd();
String nameSql = "select id from user where name=?";
String pwdSql = "select id from login where pwd=?";
try {
conn = JdbcUtils.getConn();
pstmt = conn.prepareStatement(nameSql);
pstmt.setString(1, name);
rs = pstmt.executeQuery();
rs.next();
int idByName = rs.getInt(1);
System.out.println("idByName = " + idByName);
pstmt = conn.prepareStatement(pwdSql);
pstmt.setString(1, pwd);
rs = pstmt.executeQuery();
rs.next();
int idByPwd = rs.getInt(1);
System.out.println("idByPwd = " + idByPwd);
if(idByName == idByPwd) {
return true;
}else {
System.out.println("用户名 / 密码不匹配");
return false;
}
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}