String sql = select * from user
ResultSet rs = executeQuery(sql);
While(rs.next()){
String user = rs.getString(0);
String pw = rs.getString(1);
}
if(user.equals("+user+")&&pw.equals("+pw+") )
System.out.println("登录成功")
ResultSet rs = executeQuery(sql);
While(rs.next()){
String user = rs.getString(0);
String pw = rs.getString(1);
}
if(user.equals("+user+")&&pw.equals("+pw+") )
System.out.println("登录成功")
后来跟朋友讨论了一下,认为这种方法并不妥当
首先,这样每一行都要循环复制,数据库Loading会很重
可以采用这样的方法
if(user.equals("+user+")&&pw.equals("+pw+") )
System.out.println("登录成功")
String pw1 = requset.getParameter("Password");
String sql = select user,pw from tab_user where user = "+user+";
ResultSet rs = executeQuery(sql);
String pw = rs.getString(1);
if (rs.next().equals(null)) {
System.out.println("无该用户")
}
else if (pw.equals(pw) {
System.out.println("登录成功")
}
这样只需要进行两次SQL就能得到