分页-查询

pom
mabatisplus 不可用

<!--pagehelper分页助手 -->
        <dependency>
         <groupId>com.github.pagehelper</groupId>
          <artifactId>pagehelper-spring-boot-starter</artifactId>
          <version>1.2.10</version>
         </dependency>

contorller

@RequestMapping("/cc")
    public String index(Model model, @RequestParam(defaultValue = "1") Integer pageNum){
        System.out.println("进入cc");
        PageHelper.startPage(pageNum,5);
        System.out.println("开始查询");
        List<Info> list = infoMapper.select(null,null,null,null);
        PageInfo<Info> pageInfo = new PageInfo<>(list);
        System.out.println(pageInfo);
        model.addAttribute("pageInfo",pageInfo);
        model.addAttribute("list",list);
        return "appindex";
    }

html

<span th:text="第+${pageInfo.pageNum}+页"></span>
            <span th:text="共+${pageInfo.pages}+页"></span>
            <a th:href="@{/cc(pageNum=1)}">首页</a>
            <a th:href="@{/cc(pageNum=${pageInfo.hasPreviousPage}?${pageInfo.prePage}:${pageInfo.pages})}">上一页</a>
            <a th:href="@{/cc(pageNum=${pageInfo.hasNextPage}?${pageInfo.nextPage}:${pageInfo.pages})}">下一页</a>
            <a  th:href="@{/cc(pageNum=${pageInfo.pages})}">尾页</a>

mapper

	@Select("select r.id,d.dq,r.num,r.rq,r.tj from yqry r,yqdq d where d.id=r.id ")
    List<Yqry> select();