mp分页查询
插入插件:
注:在本子模块下,建立一个配置类(存放所有的配置):
先创建个包config(存储所有的配置类),再创建mp的配置类:MpConfig
添加一个@Configuration,再把配置放进去。再把启动类中的中的@MapperScan(“com.zpc.myplus02.mapper”)添加过来
@Configuration //这是必备,说明这是一个配置类
@MapperScan("com.zpc.eduservice.mapper") //用来扫描,调用mapper,也可放在启动类
public class EduConfig {
/**
* 分页插件
*/
@Bean
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
}
简单:
//分页查询
@ApiOperation(value = "分页讲师列表")
@GetMapping("pageTeacher/{current}/{limit}") //传两个参数,current和limit
public R pageListTeacher(
@PathVariable long current, //@PathVariable是得到current和limit
@PathVariable long limit){
//创建page对象
Page<EduTeacher> pageTeacher = new Page<>(current, limit);
//调用方法实现分页
//调用方法时,底层封装,把分页所有数据封装到pageTeacher中
teacherService.page(pageTeacher,null); //条件依然为null
//需要条件时,用QueryWrapper即可
long total=pageTeacher.getTotal(); //总记录数
List<EduTeacher> records= pageTeacher.getRecords(); //数据集合
return R.ok().data("total",total).data("rows",records);
}
稍复杂:
@Autowired
private EduTeacherService teacherService;
//前台,分页查询讲师
@GetMapping("getTeacherFrontList/{page}/{limit}")
public R getTeacherFrontList(
@PathVariable long page,
@PathVariable long limit
){
//定义个page对象
Page<EduTeacher> eduTeacherPage=new Page<>(page,limit);
//查询,以及将查询到的全部放入map集合
Map<String,Object> map=teacherService.getTeacherFrontList(eduTeacherPage);
return R.ok().data("map",map);
}
@Autowired
private EduTeacherService teacherService;
//前台,分页查询讲师
@Override
public Map<String, Object> getTeacherFrontList(Page<EduTeacher> eduTeacherPage) {
QueryWrapper<EduTeacher> eduTeacherQueryWrapper=new QueryWrapper<>();
eduTeacherQueryWrapper.orderByDesc("id"); //做个降序排列
//调用方法实现分页
//调用方法时,底层封装,把分页所有数据封装到eduTeacherPage对象
baseMapper.selectPage(eduTeacherPage,eduTeacherQueryWrapper);
//前端显示会使用到这些数据(一般都会用到这些)
List<EduTeacher> records = eduTeacherPage.getRecords();
long current = eduTeacherPage.getCurrent();
long pages = eduTeacherPage.getPages();
long size = eduTeacherPage.getSize();
long total = eduTeacherPage.getTotal();
boolean hasNext = eduTeacherPage.hasNext();//下一页
boolean hasPrevious = eduTeacherPage.hasPrevious();//上一页
//把分页数据获取出来,放到map集合
Map<String, Object> map = new HashMap<>();
map.put("items", records);
map.put("current", current);
map.put("pages", pages);
map.put("size", size);
map.put("total", total);
map.put("hasNext", hasNext);
map.put("hasPrevious", hasPrevious);
//当然,上两步可以写到一起,如
//map.put("pages", eduTeacherPage.getPages());
return map;
}