java 使用PageHelper.startPage 进行分页

最新推荐文章于 2024-08-30 19:07:59 发布

weixin_47056195

最新推荐文章于 2024-08-30 19:07:59 发布

阅读量455

点赞数

文章标签： java mybatis spring

本文链接：https://blog.csdn.net/weixin_47056195/article/details/130627397

版权

一、添加pom 依赖

<dependency>
       <groupId>com.baomidou</groupId>
           <artifactId>mybatis-plus-generator</artifactId>
           <version>3.0.5</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.4.1</version>
</dependency>

二、配置文件中添加配置

#mybatis 分页插件
pagehelper:
support-methods-arguments: true
params: count=countSql
reasonable: true
helper-dialect: mysql
page-size-zero: true

三、代码中:

 SelectFamilyBody selectFamilyBody = new SelectFamilyBody();
 int pageNo = request.getPageNumber(); // 页码
 int pageSize = request.getLineNumber(); // 条数
 PageHelper.startPage(pageNo,pageSize);
 //查询数据
 List<Comuunity> comuunityList = jiakuanCommunityMapper.selectCommunity(request);
//组装数据
 PageInfo<Comuunity> pageInfo = new PageInfo<>(comuunityList);
 selectFamilyBody.setComuunityList(pageInfo);