gpt4 book ai didi

Java - 如何实现区分大小写的用户名和密码

转载 作者:行者123 更新时间:2023-11-29 06:21:55 25 4
gpt4 key购买 nike

<分区>

所以我制作了这个登录表单,其中凭据(用户名和密码)存储在 MYSQL 中。我希望用户名和密码区分大小写。

AuthDAO.java

public static int checkUserPass(String username, String password){
int userId = -1;
try{
Class.forName("com.mysql.jdbc.Driver");
cn = DriverManager.getConnection("jdbc:mysql://localhost/b440", "root", "b440");

String q="SELECT userId FROM user WHERE username='"+username+"' AND password='"+password+"'";

Statement st = cn.createStatement();
ResultSet rs = st.executeQuery(q);
while(rs.next()){
userId=Integer.parseInt(rs.getString("userId"));
}
rs.close();
st.close();
}catch(Exception e){
System.err.println(e.getMessage());
e.printStackTrace();
}
DB_close();
if(userId!=-1)
return userId;
return -1;
}

登录Servlet.java

else{
int ID = checkUserPass(username, password, role);
if(ID!=-1 ){ //User Is Legit!!
loggedIn = "true";
HttpSession se = request.getSession();
se.setAttribute("user", getUserById(ID));
se.setAttribute("loggedIn", loggedIn);
url = "/index.jsp";
msg = "Login Successful!";

request.setAttribute("loggedIn", loggedIn);
request.setAttribute("msg", msg);
}
else{
msg = "Invalid Login, please check username or password";
url = "/login.jsp";
loggedIn = "false";
request.setAttribute("loggedIn", loggedIn);
request.setAttribute("msg", msg);
}

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com