mybatis实现分页功能

分页结果封装

package com.maccura.upgrade.core.page;
import java.util.List;

public class PageResult {
	private int pageNumber;
	private int pageSize;
	private long totalSize;
	private int totalPages;
	private List<?> content;
	public int getPageNumber() {
		return pageNumber;
	}
	public void setPageNumber(int pageNumber) {
		this.pageNumber = pageNumber;
	}
	public int getPageSize() {
		return pageSize;
	}
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	public long getTotalSize() {
		return totalSize;
	}
	public void setTotalSize(long totalSize) {
		this.totalSize = totalSize;
	}
	public int getTotalPages() {
		return totalPages;
	}
	public void setTotalPages(int totalPages) {
		this.totalPages = totalPages;
	}
	public List<?> getContent() {
		return content;
	}
	public void setContent(List<?> content) {
		this.content = content;
	}
}

    // PageUtil.java实现以下静态方法
    public static PageResult getPageResult(PageRequest pageRequest, PageInfo<?> pageInfo) {
        PageResult pageResult = new PageResult();
        pageResult.setPageNumber(pageInfo.getPageNum());
        pageResult.setPageSize(pageInfo.getPageSize());
        pageResult.setTotalSize(pageInfo.getTotal());
        pageResult.setTotalPages(pageInfo.getPages());
        pageResult.setContent(pageInfo.getList());
        return pageResult;
    }

pageHelper实现分页并返回

    public PageResult queryByPage(UpgradeFileQueryRequest upgradeFileQueryRequest) {
        // 设置分页查询参数
        int pageNum = upgradeFileQueryRequest.getPageNumber() != null? upgradeFileQueryRequest.getPageNumber() : 1;
        int pageSize = upgradeFileQueryRequest.getPageSize() != null? upgradeFileQueryRequest.getPageSize() : 50;
        PageHelper.startPage(pageNum, pageSize);

        List<UpgradeFileQueryResponse> upgradeFileQueryResponses = upgradeFileDao.queryByCritea(upgradeFileQueryRequest);
        PageInfo<UpgradeFileQueryResponse> upgradeFilePageInfo = new PageInfo<>(upgradeFileQueryResponses);
        return PageUtil.getPageResult(new PageRequest(pageNum, pageSize), upgradeFilePageInfo);
    }