菜鸟级MVC登录注册实现

完成登录注册的MVC代码实现

建立一个实体类

 与数据库“交流”的Dao

 

 代码：

 private Connection con=null;

    private PreparedStatement pre=null;

    private ResultSet rs=null;

    private List<user> list=new ArrayList<>();

    private user user=null;

    //登录板块

    public int login(String username,String password){

        String sql="select * from t_user where username=? and password=?";

        con=DataSourceUtil.getCon();

        String r=null;

        try {

            pre=con.prepareStatement(sql);

            pre.setString(1,username);

            pre.setString(2,password);

            rs=pre.executeQuery();

            if (rs.next()){

                r=rs.getString(1);

                rs.getString("username");

                rs.getString("password");

            }

            if (r!=null){

                //登录成功

                return 1;

            }else {

                return 0;

            }

        } catch (SQLException throwables) {

            throwables.printStackTrace();

            return 0;

        }finally {

            DataSourceUtil.closeAll(rs,pre,con);

        }

    }

    //注册板块

    public void addList(String username,String password,String email,String firstName,String styleName){

        String sql="insert into t_user(username,password,email,firstName,styleName) value(?,?,?,?,?)";

        con = DataSourceUtil.getCon();

        try {

            pre=con.prepareStatement(sql);

            pre.setString(1,username);

            pre.setString(2,password);

            pre.setString(3,email);

            pre.setString(4,firstName);

            pre.setString(5,styleName);

            pre.executeUpdate();

        } catch (SQLException throwables) {

            throwables.printStackTrace();

        }finally {

            DataSourceUtil.closeAll(rs,pre,con);

        }

    }

与前端“交流”的servlet

 

@WebServlet("/userServlet")

public class userServlet extends HttpServlet {

    @Override

    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        req.setCharacterEncoding("utf-8");

        userDao ud=new userDao();

        String username=req.getParameter("username");

        String password=req.getParameter("password");

        HttpSession session=req.getSession();

//        String username= String.valueOf(session.getAttribute("username"));

        int result=ud.login(username,password);

        List<user> list=ud.getList(username);

        session.setAttribute("list",list);

        if (result>0){

            //登录成功

            //在判定来访用户身份合法后，通过请求对象向Tomcat申请为当前用户申请一个HttpSession

            req.getSession().setAttribute("username",username);

            req.getRequestDispatcher("home_page.html").forward(req,resp);

        }else {

            req.getRequestDispatcher("login.jsp").forward(req,resp);

        }

    }

}

@WebServlet("/addServlet")

public class addServlet extends HttpServlet {

    @Override

    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        req.setCharacterEncoding("utf-8");

        userDao ud=new userDao();

        String username=req.getParameter("username");

        String password=req.getParameter("password");

        String email=req.getParameter("email");

        String firstName=req.getParameter("firstName");

        String styleName=req.getParameter("styleName");

        ud.addList(username,password,email,firstName,styleName);

        //在判定来访用户身份合法后，通过请求对象向Tomcat申请为当前用户申请一个HttpSession

        req.getSession().setAttribute("username",username);

        req.getRequestDispatcher("home_page.html").forward(req,resp);

    }

}

如有错误，欢迎指正

如有疑问，可在评论区打出，看到后会解答