之前回答一个技术问题的时候,没看清楚人家写的sql回答错误了。真心不好意思。这里就简单提一下java做用户登陆时,简单的用户验证的几种办法。
先用段代码举个例子
try {
conn = DriverManager.getConnection("jdbc:sqlserver://localHost:1433;databaseName=MySchool","sa","sqlpass");
String id = "zl";
String pwd = "1234";
String sql = "select Count(*) as login from Admin where LoginId = ? and LoginPwd = ?";
ps = conn.prepareStatement(sql);
ps.setString(1, id);
ps.setString(2, pwd);
int r = ps.executeQuery().getInt(1); //这里报不能从结果集转换为int
System.out.println(r == 1 ? "登录成功!" : "登录失败!");
} catch (SQLException e) {
e.printStackTrace();
}finally{
if(ps != null){
ps.close();
}
if(conn != null){
conn.close();
}
}
}