完成注册与登出功能

1注册功能展示

 

 

注册成功，返回主页进行重新登录

 

 

 

 ZhuceServlet代码

package com.qiku.servlet;

import com.qiku.entity.User;
import com.qiku.service.UserService;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet(name = "zhuceServlet",urlPatterns = "/zhuce")
public class ZhuceServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //获取请求中的信息
        req.setCharacterEncoding("utf-8");
        String id = req.getParameter("id");
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        String telephone = req.getParameter("telephone");
        String birthday = req.getParameter("birthday");
        String sex = req.getParameter("sex");
        //创建Servlet对象 实现数据的封装校验功能
        UserService userService = new UserService();
        int i = userService.zhuce(new User(id, username, password, telephone, birthday, sex));
        //
        if (i<=0){
            System.out.println("注册失败，信息不符合规范");
            req.setAttribute("error","注册失败，信息不符合规范");
            RequestDispatcher requestDispatcher = req.getRequestDispatcher("zhuce.jsp");
            requestDispatcher.forward(req,resp);
        }else{
            System.out.println("注册成功");
            resp.setContentType("text/html;charset=utf-8");
            resp.getWriter().println("注册成功，稍后将进入首页，重新登录！");
            resp.sendRedirect("index.jsp");
        }
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }
}

UserService代码

package com.qiku.service;

import com.qiku.dao.UserDao;
import com.qiku.entity.User;

public class UserService {
    private UserDao userDao = new UserDao();
    /*
    * 自定义方法 实现根据参数对应的User对象 调用 useDao 实现登录
    *@param user
    *@return
    * */
    public User login(User user) {
        if(user.getUsername()!=null&&user.getPassword()!=null){
            return userDao.login(user);
        }else {
            return null;
        }
    }

    public int zhuce(User user) {
        if(user.getUid()!=null&&user.getUsername()!=null&&user.getPassword()!=null&&user.getTelephone()!=null&&user.getBirthday()!=null&&user.getSex()!=null){
            return userDao.zhuce(user);
        }else {
            return 0;
        }
    }
}

UserDao代码

package com.qiku.dao;

import com.qiku.entity.User;
import com.qiku.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;

import java.sql.SQLException;

public class UserDao {
    QueryRunner qr = new QueryRunner(DruidUtils.dataSource);
    /*
    * 登录功能
    *@param user
    * @return
    * */
    public User login(User user) {
        try {
            String sql = "select * from user where username =? and password = ?;";
            User user1 = qr.query(sql, new BeanHandler<>(User.class), user.getUsername(), user.getPassword());
            return user1;
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;

    }

    public int zhuce(User user) {
        try {
            String sql = "insert user values (?,?,?,?,?,?);";
            int update = qr.update(sql, user.getUid(), user.getUsername(), user.getPassword(), user.getTelephone(), user.getBirthday(), user.getSex());
            return update;
        } catch (SQLException e) {
            e.printStackTrace();
        } return 0;

    }
}

2推出登录功能展示

 退出并返回到首页

 

 ZhuxiaoServlet代码

package com.qiku.servlet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;

@WebServlet(name = "zhuxiaoServlet",urlPatterns = "/zhuxiao")
public class ZhuxiaoServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        HttpSession session = req.getSession();
        session.removeAttribute("user");
        resp.sendRedirect("index.jsp");
    }

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doPost(req, resp);
    }
}