springboot整合pageheler以及pageheler遇到的坑

最新推荐文章于 2025-06-20 16:10:16 发布

原创最新推荐文章于 2025-06-20 16:10:16 发布 · 500 阅读

CC 4.0 BY-SA版权

本文介绍了如何在SpringBoot项目中整合PageHelper，包括在pom.xml添加依赖，application.yml配置以及在查询方法前调用startPage()。同时，文章详细阐述了在使用PageHelper过程中遇到的两个问题：1. 创建PageInfo对象时，若传入参数为list，总页数会错误地等于每页记录数；2. 当Controller和Mapper的实体类型不一致时，不仅需要实体转换，还需拷贝PageInfo属性以确保页数计算正确。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

springboot整合pageheler以及pageheler遇到的坑

一、springboot整合pageheler
1.pom.xml中引入依赖

		<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.7</version>
        </dependency>

2.application.yml文件中进行配置

pagehelper:
  helper-dialect: mysql
  reasonable: true
  support-methods-arguments: true
  params: count=countSql

3.直接在查询方法的前面调用startPage()方法即可

public PageInfo<OrderDto> findList(Integer pageNum, Integer pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        Page<OrderMaster> orderMasterPage = orderMasterMapper.findAll();
        PageInfo<OrderMaster> OrderMasterPageInfo = new PageInfo<>(orderMasterPage);
        return OrderMasterPageInfo2OrderDtoPageInfo.convert(OrderMasterPageInfo);
    }

二、使用pageheler时遇到的坑
1.当创建PageInfo对象时传递的参数是一个list时，就会发现返回的总页数总是等于每页的记录数。
列如：PageInfo OrderMasterPageInfo = new PageInfo<>(list);
通过查看pageheler的源代码可发现,当传递的参数是list和page对象时pageinfo属性的值是不一样的。所以在创建pageinfo对象的时候参数应该传递的是page对象。

public PageInfo(List<T> list, int navigatePages) {
        super(list);
        this.isFirstPage = false;
        this.isLastPage = false;
        this.hasPreviousPage = false;
        this.hasNextPage = false;
        if (list instanceof Page) {
            Page page = (Page)list;
            this.pageNum = page.getPageNum();
            this.pageSize = page.getPageSize();
            this.pages = page.getPages();
            this.size = page.size();
            if (this.size == 0) {
                this.startRow = 0;
                this.endRow = 0;
            } else {
                this.startRow = page.getStartRow() + 1;
                this.endRow = this.startRow - 1 + this.size;
            }
        } else if (list instanceof Collection) {
            this.pageNum = 1;
            this.pageSize = list.size();
            this.pages = this.pageSize > 0 ? 1 : 0;
            this.size = list.size();
            this.startRow = 0;
            this.endRow = list.size() > 0 ? list.size() - 1 : 0;
        }

        if (list instanceof Collection) {
            this.navigatePages = navigatePages;
            this.calcNavigatepageNums();
            this.calcPage();
            this.judgePageBoudary();
        }

    }

2.当controller需要实体类型和mapper中查询到的实体类型不一致时，不仅要将实体进行转换，还要将pageinf的属性进行拷贝，负责获取到的总页数等不准确。
列如：我的controller需要的是 PageInfo类型，而mapper中查询到的是PageInfo类型，那就需要进行转换。（代码如下）

service层方法：
    public PageInfo<OrderDto> findList(Integer pageNum, Integer pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        Page<OrderMaster> orderMasterPage = orderMasterMapper.findAll();
        PageInfo<OrderMaster> OrderMasterPageInfo = new PageInfo<>(orderMasterPage);
        return OrderMasterPageInfo2OrderDtoPageInfo.convert(OrderMasterPageInfo);
    }

controller层方法：
public ModelAndView findList(@RequestParam(value = "pageNum", defaultValue = "1") Integer pageNum,
                                 @RequestParam(value = "pageSize", defaultValue = "1") Integer pageSize,
                                 Map<String, Object> map) {
        PageInfo<OrderDto> pageInfo = orderService.findList(pageNum, pageSize);
        map.put("pageInfo", pageInfo);
        map.put("currentPage", pageNum);
        map.put("pageSize", pageSize);
        return new ModelAndView("order/list", map);
    }

转换工具类
public class OrderMasterPageInfo2OrderDtoPageInfo {

    public static PageInfo<OrderDto> convert(PageInfo<OrderMaster> orderMasterPageInfo){
        PageInfo<OrderDto> orderDtoPageInfo = new PageInfo<>();
        BeanUtils.copyProperties(orderMasterPageInfo,orderDtoPageInfo);
        List<OrderDto> orderDtoList = OrderMasterConvert2OrderDto.convert(orderMasterPageInfo.getList());
        orderDtoPageInfo.setList(orderDtoList);
        return orderDtoPageInfo;
    }
}


public class OrderMasterConvert2OrderDto {

    public static OrderDto convert(OrderMaster orderMaster){
        OrderDto orderDto = new OrderDto();
        BeanUtils.copyProperties(orderMaster,orderDto);
        return orderDto;
    }

    public static List<OrderDto> convert(List<OrderMaster> orderMasterList){
        return orderMasterList.stream().map(e -> convert(e)).collect(Collectors.toList());
    }
}