spring boot 使用分页插件pagehelper

最新推荐文章于 2022-02-13 23:23:13 发布

学乃无止境

最新推荐文章于 2022-02-13 23:23:13 发布

阅读量153

点赞数

分类专栏： springboot

本文链接：https://blog.csdn.net/qq_41258886/article/details/103376991

版权

springboot 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

spring boot 使用分页插件pagehelper

一.引入依赖

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

二.以查询到的一个list集合为例

//mapper接口
@Select("select * from `order` where uId=#{uId}")
@Results({@Result(column="uId",property = "user",
                  one=@One(select="cn.bongbb.mapper.UserMapper.getUserById")),
          @Result(column="gId",property ="good",
                  one=@One(select="cn.bongbb.mapper.GoodMapper.getGoodById"))})
    public List<Order> selectOrderByUId(Integer uId);

//service层
public List<Order> selectOrderByUId(Integer uId, Integer pageNum){
        //开启分页插件,pageNum:当前页码  设置每页记录为10条
        PageHelper.startPage(pageNum,10);
        List<Order> orders = orderMapper.selectOrderByUId(uId);
        return orders;
}

//controller层

@GetMapping("/user/order/{pageNum}")
public String userOrder(Model model, HttpSession session, 
                        @PathVariable("pageNum") Integer pageNum){
        User user = (User)session.getAttribute("user");
        List<Order> orders = orderService.selectOrderByUId(user.getuId(),pageNum);

        PageInfo<Order> orderPageInfo = new PageInfo<>(orders);
        orderPageInfo.setPageNum(pageNum);
        model.addAttribute("orders",orders);
        model.addAttribute("orderPageInfo",orderPageInfo);

        return "user/orderList";
    }

//thymeleaf
<div>
	<span>
		<a th:href="@{/user/order/1}">首页</a>
    </span>

    <span>
       <a th:href="${orderPageInfo.isIsFirstPage()==true}?
           @{/user/order/1}:@{/user/order/}+${orderPageInfo.getPageNum()-1}">上一页</a>
    </span>

     <span th:text="${orderPageInfo.getPageNum()}+'/'+
         ${orderPageInfo.getPages()}">
     </span>

     <span>
         <a th:href="${orderPageInfo.isIsLastPage()==true}?	
         	@{/user/order/}+${orderPageInfo.getPages()}:
            @{/user/order/}+${orderPageInfo.getPageNum()+1}">下一页
         </a>
     </span>

     <span>
         <a th:href="@{/user/order/}+${orderPageInfo.getPages()}">尾页</a>
     </span>
</div>