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);
    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值