//分页插件
@Bean
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
@ApiOperation("分页查询")
@GetMapping("/pageTeacher/{current}/{limit}")
public R pageTeacher(@PathVariable("current") Integer current,
@PathVariable("limit") Integer limit)
{
Page<EduTeacher> teacherPage= new Page<>(current,limit);
//把分页的数据封装到teacherPage对象里面去
eduTeacherService.page(teacherPage,null);
//分页总数
long total = teacherPage.getTotal();
//分页所有数据
List<EduTeacher> list = teacherPage.getRecords();
return R.ok().data("total",total).data("rows",list);
}
@PostMapping("/pageTeacherQuer/{current}/{limit}")
public R pageTeacherQuer(@PathVariable("current") Integer current,
@PathVariable("limit") Integer limit,
@RequestBody (required=false) TeacherQuer teacherQuer){
Page<EduTeacher> pageInfo= new Page<>(current,limit);
QueryWrapper<EduTeacher> queryWrapper=new QueryWrapper();
String name = teacherQuer.getName();
Integer level = teacherQuer.getLevel();
Date gmtCreate = teacherQuer.getGmtCreate();
Date gmtModified = teacherQuer.getGmtModified();
if (!StringUtils.isEmpty(name))
queryWrapper.like("name", name);
if (!StringUtils.isEmpty(level))
queryWrapper.eq("level",level);
if (!StringUtils.isEmpty(gmtCreate ))
queryWrapper.ge("gmtCreate",gmtCreate);
if (!StringUtils.isEmpty(gmtModified))
queryWrapper.le("gmtModified",gmtModified);
eduTeacherService.page(pageInfo, queryWrapper);
List<EduTeacher> list = pageInfo.getRecords();
long total = pageInfo.getTotal();
return R.ok().data("total",total).data("list",list);
}