SpringBoot集成PageHelper

二话不说，首先导入依赖

		<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.11</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        <!--mapper-->
        <dependency>
            <groupId>tk.mybatis</groupId>
            <artifactId>mapper-spring-boot-starter</artifactId>
            <version>1.2.4</version>
        </dependency>
        <!--pagehelper-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

yml文件里面配置

mybatis:
    type-aliases-package: tk.mybatis.springboot.model
    mapper-locations: classpath:mapper/*.xml

mapper:
    mappers:
        - tk.mybatis.springboot.util.MyMapper
    not-empty: false
    identity: MYSQL

pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql

或者是properties配置

#mybatis
mybatis.type-aliases-package=tk.mybatis.springboot.model
mybatis.mapper-locations=classpath:mapper/*.xml

#mapper
#mappers 多个接口时逗号隔开
mapper.mappers=tk.mybatis.springboot.util.MyMapper
mapper.not-empty=false
mapper.identity=MYSQL

#pagehelper
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

代码部分

    @Override
    public PageInfo<InvoiceTitlePO> selectByIdList1(Integer pageNum,Integer pageSize) {
        PageHelper.startPage(pageNum,pageSize);//后面接需要分页的SQL查询才有效，仅对第一条有效
        List<InvoiceTitlePO> list = invoiceTitleMapper.selectByIdList();
        PageInfo<InvoiceTitlePO> info = new PageInfo<InvoiceTitlePO>(list);
        return info;
    }

使用postman测试，返回结果

{
    "total": 5,
    "list": [
        {
            "id": 1,
            "createTime": "2020-03-06T21:08:04.000+0000",
            "updateTime": "2020-03-06T21:08:12.000+0000",
            "creator": "1",
            "creatorId": 1,
            "updator": "1",
            "deleted": false,
            "version": 1,
            "customerId": 1,
            "titleType": 1,
            "title": "1",
            "taxNumber": "1",
            "bankName": "1",
            "bankAccount": "1",
            "companyAddress": "1",
            "companyPhone": "1"
        },
        {
            "id": 2,
            "createTime": "2020-03-23T21:13:21.000+0000",
            "updateTime": "2020-03-23T21:13:25.000+0000",
            "creator": "22",
            "creatorId": 1,
            "updator": "1",
            "deleted": false,
            "version": 1,
            "customerId": 2,
            "titleType": 2,
            "title": "2",
            "taxNumber": "2",
            "bankName": "2",
            "bankAccount": "2",
            "companyAddress": "2",
            "companyPhone": "2"
        },
        {
            "id": 3,
            "createTime": "2020-03-23T21:13:54.000+0000",
            "updateTime": "2020-03-23T21:13:56.000+0000",
            "creator": "3",
            "creatorId": 33,
            "updator": "3",
            "deleted": false,
            "version": 1,
            "customerId": 3,
            "titleType": 3,
            "title": "3",
            "taxNumber": "3",
            "bankName": "3",
            "bankAccount": "3",
            "companyAddress": "3",
            "companyPhone": "3"
        },
        {
            "id": 4,
            "createTime": "2020-03-23T21:14:08.000+0000",
            "updateTime": "2020-03-23T21:14:11.000+0000",
            "creator": "4",
            "creatorId": 4,
            "updator": "4",
            "deleted": false,
            "version": 1,
            "customerId": 4,
            "titleType": 4,
            "title": "4",
            "taxNumber": "4",
            "bankName": "4",
            "bankAccount": "4",
            "companyAddress": "4",
            "companyPhone": "4"
        },
        {
            "id": 5,
            "createTime": "2020-03-23T21:14:19.000+0000",
            "updateTime": "2020-03-23T21:14:21.000+0000",
            "creator": "5",
            "creatorId": 5,
            "updator": "5",
            "deleted": false,
            "version": 1,
            "customerId": 5,
            "titleType": 5,
            "title": "5",
            "taxNumber": "5",
            "bankName": "5",
            "bankAccount": "5",
            "companyAddress": "5",
            "companyPhone": "5"
        }
    ],
    "pageNum": 1,
    "pageSize": 5,
    "size": 5,
    "startRow": 1,
    "endRow": 5,
    "pages": 1,
    "prePage": 0,
    "nextPage": 0,
    "isFirstPage": true,
    "isLastPage": true,
    "hasPreviousPage": false,
    "hasNextPage": false,
    "navigatePages": 8,
    "navigatepageNums": [
        1
    ],
    "navigateFirstPage": 1,
    "navigateLastPage": 1
}