springboot集成pagehelper

添加依赖

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

配置文件中配置pagehelper信息

#pagehelper分页插件配置
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

在controller中执行

    @GetMapping(value = "/getall")
    @ResponseBody
    public Object getUsers(){
        PageHelper.startPage(2,2);
        List<Student> students = studentMapperService.getall();
        return students;
    }

执行过程：

==>  Preparing: SELECT count(0) FROM student 
==> Parameters: 
<==    Columns: count(0)
<==        Row: 15
<==      Total: 1
==>  Preparing: select * from student order by id LIMIT ?, ? 
==> Parameters: 6(Integer), 3(Integer)

---------------------------------
其他springboot相关知识看专栏其他内容