public String login(String userid,String password,HttpServletRequest request) throws SQLException{
if(userid!=null&&password!=null&&!userid.equals("")&&!password.equals("")){
DBConnection dao=new DBConnection();
Connection conn = dao.getConnection();
String sql="select * from user where userid='"+userid+"'";
PreparedStatement ptmt=conn.prepareStatement(sql);
ResultSet rs=ptmt.executeQuery();
String username="";
while(rs.next()){
if(rs.getString("password").equals(password)){
username=rs.getString("username");
HttpSession session = request.getSession();
session.setAttribute("userid",userid);
session.setAttribute("username",username);
return "main";
}else{
return "login";
}
}
}
return "login";
}
哪位大佬能根据这个登录代码帮写一个注册代码,都是放在Usercontroler.java类里的
if(userid!=null&&password!=null&&!userid.equals("")&&!password.equals("")){
DBConnection dao=new DBConnection();
Connection conn = dao.getConnection();
String sql="select * from user where userid='"+userid+"'";
PreparedStatement ptmt=conn.prepareStatement(sql);
ResultSet rs=ptmt.executeQuery();
String username="";
while(rs.next()){
if(rs.getString("password").equals(password)){
username=rs.getString("username");
HttpSession session = request.getSession();
session.setAttribute("userid",userid);
session.setAttribute("username",username);
return "main";
}else{
return "login";
}
}
}
return "login";
}
哪位大佬能根据这个登录代码帮写一个注册代码,都是放在Usercontroler.java类里的
user.setUserid(userid);
user.setPassword(password);
然后写一条insert语句插入到你的数据库里,jdbc别忘了最后提交一下
if(username!=null&&password!=null&&!username.equals("")&&!password.equals("")){
DBConnection dao=new DBConnection();
Connection conn = dao.getConnection();
String userid = "生成唯一UserId";
String sql="insert into user(userid,username,password) values(?,?,?)";
try {
PreparedStatement ptmt=conn.prepareStatement(sql);
ptmt.setString(1,userid);
ptmt.setString(2,username);
ptmt.setString(3,password);
ptmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
conn.close();
}
}
return "index";
}
还要判断用户名是否存在,才能插入insert