PageHelper分页,以及手动实现自定义集合等分页
分页
1、使用PageHelper分页
1.1 Pom依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
1.2分页插件配置(aplication.yml)
#分页pageHelper
pagehelper:
helper-dialect: mysql
reasonable: true
support-methods-arguments: true
1.3将查询数据进行分页
eg:
public PageInfo<User> getNotifyByUserId(int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
return new PageInfo<>(writerBookDao.selectUserList());
}
2、自定义分页实现
2.1定义ListPageUtil分页工具类
public class ListPageUtil<T> {
/**原集合*/
private List<T> data;
/** 上一页 */
private int lastPage;
/** 当前页 */
private int nowPage;
/** 下一页 */
private int nextPage;
//
/** 每页条数 */
private int pageSize;
/** 总页数 */
private int totalPage;
/** 总数据条数 */
private int totalCount;
public ListPageUtil(List<T> data,int nowPage,int pageSize) {
if (data == null || data.isEmpty()) {
throw new IllegalArgumentException("data must be not empty!");
}
this.data = data;
this.pageSize = pageSize;
/*this.totalPage = data.size()/pageSize;
if(data.size()%pageSize!=0){
this.totalPage++;
}*/
this.nowPage = nowPage;
this.totalCount = data.size();
this.totalPage = (totalCount + pageSize - 1) / pageSize;
this.lastPage = nowPage-1>1? nowPage-1:1;
this.nextPage = nowPage>=totalPage? totalPage: nowPage + 1;
}
/**
* 得到分页后的数据
*
* @param pageNum 页码
* @return 分页后结果
*/
public List<T> getPagedList() {
int fromIndex = (nowPage - 1) * pageSize;
if (fromIndex >= data.size()) {
return Collections.emptyList();//空数组
}
if(fromIndex<0){
return Collections.emptyList();//空数组
}
int toIndex = nowPage * pageSize;
if (toIndex >= data.size()) {
toIndex = data.size();
}
return data.subList(fromIndex, toIndex);
}
public int getPageSize() {
return pageSize;
}
public List<T> getData() {
return data;
}
public int getLastPage() {
return lastPage;
}
public int getNowPage() {
return nowPage;
}
public int getNextPage() {
return nextPage;
}
public int getTotalPage() {
return totalPage;
}
public int getTotalCount() {
return totalCount;
}
}
2.2 实现分页
eg:
public ListPageUtil<UserBook> recordReadList(int pageNum, int pageSize) {
//自定义要分页的对象集合
List<UserBook> bookShelfList = new ArrayList<>();
//往集合添加数据,,此处省略
...
...
//将要分页的集合带入自定义的分页工具类ListPageUtil,得到已经分页(包含分页信息)的集合
ListPageUtil<UserBook> listPageUtil = new ListPageUtil<>(bookShelfList, pageNum, pageSize);
List<UserBook> pagedList = listPageUtil.getPagedList();
return listPageUtil;
}
注:PageHelper分页默认分页的是第一个数据库查询返回的结果