一、配置类
@Configuration
public class MybatisPlusConfig {
//设置分页拦截器
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
//设置数据库类型为mysql
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
二、进行测试
@Test
public void selectPageTest(){
//分页参数
Page<OrderInfo> rowPage=new Page<>(2,3);
//queryWrapper组装查询where条件
QueryWrapper<OrderInfo> queryWrapper=new QueryWrapper<>();
//加入查询条件
queryWrapper.like("status","2");
rowPage =this.orderMapper.selectPage(rowPage,queryWrapper);
System.out.println("数据总条数"+rowPage.getTotal());
System.out.println("数据总页数"+rowPage.getPages());
System.out.println("当前的页数"+rowPage.getCurrent());
//打印数据
List<OrderInfo> info=rowPage.getRecords();
for (OrderInfo message :info){
System.out.println(message);
}
}
三、测试结果