day18

继前几天的内容
登陆界面继前几天
总体结构如下：

此为重写版本
将模糊查询和分页合为FindByPageServlet
UserDaoImpl加入findByPage

@Override
public List<User> findByPage(String username,int start, int size) {
    List<User> users=new ArrayList<>();
    Connection connection=null;
    PreparedStatement statement=null;
    ResultSet resultSet=null;
    String sql=null;
    try {
        connection = DBUtil.getConnection();

        if (username == null) {
            sql = "select * from tb_user limit ?,?";
            statement = connection.prepareStatement(sql);
            statement.setInt(1, start);
            statement.setInt(2, size);
        } else {
            sql = "select * from tb_user where username like ? limit ?,?";
            statement = connection.prepareStatement(sql);
            statement.setString(1, "%" + username + "%");
            statement.setInt(2, start);
            statement.setInt(3, size);
        }
        resultSet = statement.executeQuery();
        while (resultSet.next()){
            User user=new User();
            user.setId(resultSet.getInt(1));
            user.setUsername(resultSet.getString(2));
            user.setPassword(resultSet.getString(3));
            users.add(user);
        }
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        DBUtil.closeAll(resultSet,statement,connection);
    }

    return users;
}

在IUserDao最后一行中加入

 List<User> findByPage(String username,int start,int size);

 int selectCount();   

登陆部分不用修改
由于合并所以将前面所有的/find改为findByPage

 FindByPage
package com.zhongruan.servlet;

import com.zhongruan.pojo.PageInfo;
import com.zhongruan.service.IUserService;
import com.zhongruan.service.impl.UserServiceImpl;

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

public class FindByPageServlet extends HttpServlet {

@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    HttpSession session = request.getSession();
    String searchname = (String) session.getAttribute("searchname");
    String c = request.getParameter("currentPage");
    int currentPage = Integer.parseInt(c);
    String s = request.getParameter("size");
    int size = Integer.parseInt(s);
    IUserService userService = new UserServiceImpl();
    PageInfo pageInfo = null;
    pageInfo = userService.findByPage(searchname, currentPage, size);

    session.setAttribute("pageInfo", pageInfo);
    request.getRequestDispatcher("allUser.jsp").forward(request, response);
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    String searchname = request.getParameter("searchname");
    int currentPage = 1;
    int size = 5;
    IUserService userService = new UserServiceImpl();
    PageInfo pageInfo = null;
    pageInfo = userService.findByPage(searchname, currentPage, size);
    HttpSession session = request.getSession();
    session.setAttribute("searchname", searchname);
    session.setAttribute("pageInfo", pageInfo);
    request.getRequestDispatcher("allUser.jsp").forward(request, response);
}

}
DeleteServlet
package com.zhongruan.servlet;

import com.zhongruan.dao.IUserDao;
import com.zhongruan.dao.impl.UserDaoImpl;
import com.zhongruan.pojo.PageInfo;
import com.zhongruan.service.IUserService;
import com.zhongruan.service.impl.UserServiceImpl;

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

public class DeleteServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String id1=req.getParameter("id");
        int id2=Integer.parseInt(id1);
        IUserService userService=new UserServiceImpl();
        userService.delete(id2);
        String searchname=req.getParameter("searchname");
        PageInfo pageInfo=userService.findByPage(searchname,1,5);
        HttpSession session=req.getSession();
        session.setAttribute("pageInfo",pageInfo);
        req.getRequestDispatcher("/allUser.jsp").forward(req, resp);
    }
}

以上为改动较多部分

分页部分
在allUser中加入分页