分页查询
PageBean工具类
package com.itcast.utils;
import java.util.List;
public class PageBean<T> {
private int totalCount;//总记录数
private int totalPage;//tottalPage://总页码
// private List<T> list = new ArrayList<>();//每页的数据
private List<T> list ;//每页的数据
private int currentPage;//当前的页码
private int rows;//每页显示的记录数
@Override
public String toString() {
return "PageBean{" +
"totalCount=" + totalCount +
", totalPage=" + totalPage +
", list=" + list +
", currentPage=" + currentPage +
", rows=" + rows +
'}';
}
public int getTotalCount() {
return totalCount;
}
public void setTotalCount(int totalCount) {
this.setTotalPage(totalCount % rows == 0 ? totalCount / rows : (totalCount / rows) + 1);
this.totalCount = totalCount;
}
public int getTotalPage() {
return totalPage;
}
public void setTotalPage(int totalPage) {
if (currentPage>totalPage){
this.currentPage = totalPage;
}
this.totalPage = totalPage;
}
public int getOffset(){
return (currentPage - 1) * rows;
}
public List<T> getList() {
return list;
}
public void setList(List<T> list) {
this.list = list;
}
public int getCurrentPage() {
return currentPage;
}
public void setCurrentPage(Integer currentPage) {
if (currentPage == null || currentPage < 1) {
currentPage = 1;
}
this.currentPage = currentPage;
}
public int getRows() {
return rows;
}
public void setRows(Integer rows) {
if (rows == null) {
rows = 5;
}
this.rows = rows;
}
public PageBean() {
}
public PageBean(int totalCount, int totalPage, List<T> list, int currentPage, int rows) {
this.totalCount = totalCount;
this.totalPage = totalPage;
this.list = list;
this.currentPage = currentPage;
this.rows = rows;
}
}
UserMapper
/**
* 分页
* @param User
* @return
*/
int findCount(Integer id);
/**
* 分页查询每页记录
* @param start
* @param rows
* @param User
* @return
*/
List<User> findByPage(@Param("start") Integer start , @Param("rows") Integer rows,@Param("id") Integer id);
UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"