pageHelper

PageHelper

通过pagehelper实现方便分页

依赖和配置

通过以下三个依赖和配置，就可以自动和springboot整合

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.2</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
            <version>1.2.3</version>
        </dependency>
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.3</version>
        </dependency>

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

使用

    public PageInfo<Student> getStudents() {
        PageHelper.startPage(1, 1);
        List<Student> users = mapper.getAll();
        PageInfo<Student> pageInfo = new PageInfo<Student>(users);
        return pageInfo;
    }

将getAll语句夹在 PageHelper.startPage(1, 1);PageInfo pageInfo = new PageInfo(users);两句话之间即可。