servlejsp分页

allUser


新建一个FindByPageServlet
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 {
String current=request.getParameter(“currentPage”);
String size1=request.getParameter(“size”);
int currentPage = Integer.parseInt(current);
int size=Integer.parseInt(size1);
IUserService userService=new UserServiceImpl();
PageInfo pageInfo=userService.findByPage(currentPage,size);
HttpSession session=request.getSession();
session.setAttribute(“pageInfo”,pageInfo);
request.getRequestDispatcher(“allUser.jsp”).forward(request,response);
}

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

}

web.xml


package com.zhongruan.pojo;
import com.zhongruan.model.User;
import java.util.List;

public class PageInfo {
private int currentPage;
private int size;
private List list;
private int totalPage;
private int totalCount;

public int getTotalPage() {
    return totalPage;
}

public void setTotalPage(int totalPage) {
    this.totalPage = totalPage;
}

public int getCurrentPage() {
    return currentPage;
}

public void setCurrentPage(int currentPage) {
    this.currentPage = currentPage;
}

public int getSize() {
    return size;
}

public void setSize(int size) {
    this.size = size;
}

public List<User> getList() {
    return list;
}

public void setList(List<User> list) {
    this.list = list;
}

public int getTotalCount() {
    return totalCount;
}

public void setTotalCount(int totalCount) {
    this.totalCount = totalCount;
}

@Override
public String toString() {
    return "PageInfo{" +
            "currentPage=" + currentPage +
            ", size=" + size +
            ", list=" + list +
            ", totalPage=" + totalPage +
            ", totalCount=" + totalCount +
            '}';
}

}
IUserDao 加入以下方法

UserDaoImpl加入以下方法

@Override
public List search(String username) {
List books=new ArrayList<>();
PreparedStatement statement=null;
ResultSet resultSet=null;
Connection connection=null;
try {
connection = DBUtil.getConnection();
String sql=“select * from tb_user where username like ?”;
statement=connection.prepareStatement(sql);
statement.setString(1,"%"+username+"%");
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));
books.add(user);
}
}
catch (Exception e) {
e.printStackTrace();
}finally {
DBUtil.closeAll(resultSet,statement,connection);
}
return books;
}

@Override
public List<User> findByPage(int start, int size) {
    List<User> books=new ArrayList<>();
    PreparedStatement statement=null;
    ResultSet resultSet=null;
    Connection connection=null;
    try {
        connection = DBUtil.getConnection();
        String sql="select * from tb_user  limit ?,?";
        statement=connection.prepareStatement(sql);
        statement.setInt(1,start);
        statement.setInt(2,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));
            books.add(user);
        }
    }
    catch (Exception e) {
        e.printStackTrace();
    }finally {
        DBUtil.closeAll(resultSet,statement,connection);
    }
    return books;
}

@Override
public int selectCount() {
    List<User> users=new ArrayList<>();
    PreparedStatement statement=null;
    ResultSet resultSet=null;
    Connection connection=null;
    int count=0;
    try {
        connection = DBUtil.getConnection();
        String sql="select count(*) from tb_user";
        statement=connection.prepareStatement(sql);
        resultSet=statement.executeQuery();
        while (resultSet.next()) {
            count=resultSet.getInt(1);
        }
    }
    catch (Exception e) {
        e.printStackTrace();
    }finally {
        DBUtil.closeAll(resultSet,statement,connection);
    }
    return count;
}

IUserService

List search(String username);
PageInfo findByPage(int currentPage, int size);

UserServiceImpl

@Override
public List<User> search(String username) {
    return userDao.search(username);
}

@Override
public PageInfo findByPage(int currentPage, int size) {
    PageInfo pageInfo=new PageInfo();
    pageInfo.setCurrentPage(currentPage);
    pageInfo.setSize(size);
    int start=(currentPage-1)*size;
    List<User> books=userDao.findByPage(start,size);
    pageInfo.setList(books);
    int count=userDao.selectCount();
    pageInfo.setTotalCount(count);
    Double c=Double.valueOf(count);
    Double ceil = Math.ceil(c/size);
    pageInfo.setTotalPage(ceil.intValue());
    return pageInfo;
}

LoginServlet 改成