实训记录（三）：登录注册（二）

注册方法

	public boolean registerUser(UserBean user){
    try{
        conn = getConnection();
        ps = conn.prepareStatement("INSERT INTO user VALUES(?,?,?,?,?)");
        ps.setString(1,user.getSid());
        ps.setString(2,user.getSname());
        ps.setString(3,user.getSnum());
        ps.setString(4,user.getSclass());
        ps.setString(5,user.getPwd());

        ps.executeUpdate();
        ps.close();

        return true;
    }catch(SQLException se){
        se.printStackTrace();
        return false;
    }finally{
        try{
            conn.close();
        }catch(SQLException se){
            se.printStackTrace();
        }
    }

}

登录方法

	public class UserLoginServlet extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    request.setCharacterEncoding("utf-8");
    response.setHeader("content-type", "text/html;charset=utf-8");
    String sid = request.getParameter("sid");
    String password = request.getParameter("pwd");
    System.out.println(sid+"  " +password);

    UserBean user = new UserBean();
    user.setSid(sid);
    user.setPwd(password);
    UserDAO userdao = new UserDAO();
    if(userdao.SearchUser(user)!=null){
        request.setAttribute("user", user);
        request.setAttribute("password", password);
        RequestDispatcher dispatcher = request.getRequestDispatcher("/Main.jsp");
        dispatcher.forward(request, response);
    }else{
        RequestDispatcher view = request.getRequestDispatcher("/ErrorLoginPage.jsp");
        view.forward(request, response);
    }
}

}

下一步工作

下一步要实现算法与后端之间的对接，这一步也是学生端后端最复杂的部分。