spring boot+mybatis+pagehelper实现分页数据

导入pagehelper的maven依赖，这里推荐使用1.4以上的

<!--        <dependency>-->
<!--            <groupId>com.github.pagehelper</groupId>-->
<!--            <artifactId>pagehelper-spring-boot-starter</artifactId>-->
<!--            <version>1.3.0</version>-->
<!--        </dependency>-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.4.1</version>
        </dependency>

1.3.0在运行时会报错，循环依赖，

通过mybatis一键生成各层

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.demo.dao.PageMapper">

    <resultMap id="BaseResultMap" type="com.example.demo.entity.Page">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="num" column="num" jdbcType="INTEGER"/>
    </resultMap>

  <select id="PagingQuery" resultType="com.example.demo.entity.Page">
 select  * from page
  </select>
</mapper>

控制层代码

    @Autowired
    private PageService pageService;
   @GetMapping("/ceshi")
   public PageResult ceshi(@RequestParam int  pagenum, @RequestParam int pagesize) {
       List<Page> value=pageService.countpage(pagenum,pagesize);
       return  new PageResult(200, "ok", value,pagesize,pagenum);
   }

Service层代码

@Service
public class PageServiceImpl implements PageService{
    @Resource
    private PageMapper pageMapper;
    @Override
    public List<Page> countpage(int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);//核心
        List<Page> list = pageMapper.PagingQuery();
        return list;
    }
}

测试结果