9.Spring Boot集成MyBatis (pagehelper分页查询)

2019独角兽企业重金招聘Python工程师标准>>>

1.加依赖包

<!--分页拦截器-->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.5</version>
</dependency>

2.配置application.yml

pagehelper:
    helperDialect: mysql
    reasonable: true
    supportMethodsArguments: true
    params: count=countSql
    rowBoundsWithCount: true
    offset-as-page-num: true

3.编写AdminController类

    @RequestMapping(value = "/getAdminListMap/{account}")
    public List<Map<String, Object>> getAdminListMap(@PathVariable("account") String account) {
        /**
         * 第一个参数：第几页
         * 第二个参数：每页获取的条数
         */
        PageHelper.startPage(1,2);
        List<Map<String, Object>> adminListMap = adminService.getAdminListMap(account);
        PageInfo<Map<String, Object>> pageInfo = new PageInfo<>(adminListMap);
        System.out.println("总记录数：" + pageInfo.getTotal());
        System.out.println("总记页数：" + pageInfo.getPages());
        System.out.println("返回的记录数：" + adminListMap.size());

        return adminListMap;
    }

4.测试

转载于:https://my.oschina.net/u/1046143/blog/1840635