Mybatisplus分页插件的使用
一、加依赖:
1 <dependency> 2 <groupId>com.baomidou</groupId> 3 <artifactId>mybatis-plus</artifactId> 4 <version>${mybatis-plus.version}</version> 5 </dependency>
二、加配置:
1 <plugins> 2 <!-- 分页查询插件 --> 3 <plugin interceptor="com.baomidou.mybatisplus.plugins.PaginationInterceptor"> 4 <property name="dialectType" value="mysql" /> 5 </plugin> 6 </plugins>
三、controller使用:
1 @PostMapping("orderlist.api") 2 @ApiOperation(value = "分页查询", produces = MediaType.APPLICATION_JSON_VALUE) 3 public Object memberOrderlist(@RequestBody DriverDto dto, HttpServletRequest request, HttpServletResponse response) { 4 Page<BizOrderlist> page = new Page<BizOrderlist>(dto.getPage() == null ? 1 : dto.getPage() , dto.getPageSize() == null ? 15 : dto.getPageSize()); //初始化分页条数,如果传入的值为空在默认第一页,15条。 5 Parameter orderparameter = new Parameter(getService(), "getOrderlist").setParam(page,params); //在servie中获取list,传递分页Page和查询参数 6 Page<BizOrderlist> orderList = (Page<BizOrderlist>) provider.execute(orderparameter).getResult();
四、service中使用:
1 public Page<BizOrderlist> getOrderlist(Page<BizOrderlist> page,Map<String, Object> params) { 2 3 List<BizOrderlist> orderlist = (List<BizOrderlist>) ((OrderListMapper) mapper).getOrderList(page,param1,params2,params3); 4 page = page.setRecords(orderlist); //查出的list调用setRecords 5 return page;
五、Mapper:
1 public interface OrderListMapper extends BaseMapper<BizOrderlist> { 2 3 List<BizOrderlist> getOrderList(Pagination page,@Param("param1") Double param1...........);