1.1条件分页查询的注解GetMapping单挑获取多个字段
1.2条件分页查询的注解PostMapping和RequestBody共存(使用json连续获取多个字段)
2.使用PostMapping和RequestBody注解来获取json中的多个数据(需求,实现,测试)
Swagger的api进行分页查询,测试数据
条件分页代码
===========HospitalSetController======GetMapping=============
//3.条件查询带分页
@GetMapping("findPageHospSet/{current}/{limit}")
public Result findPageHospSet(@PathVariable long current,
@PathVariable long limit,
HospitalSetQueryVo hospitalSetQueryVo) {
//创建page对象,传递当前也,每页记录数
Page page = new Page<>(current, limit);//mybatis-plus的分页
//构建条件
QueryWrapper wrapper = new QueryWrapper<>();//mybatis-plus的QueryWrapper
String hosname = hospitalSetQueryVo.getHosname();//医院名称
String hoscode = hospitalSetQueryVo.getHoscode();//医院编号
if (!StringUtils.isEmpty(hosname)) {
wrapper.like("hosname", hospitalSetQueryVo.getHosname());
}
if (!StringUtils.isEmpty(hoscode)) {
wrapper.eq("hoscode", hospitalSetQueryVo.getHoscode());
}
//调用方法实现分页查询
Page pageHopotalSet = hospitalSetService.page(page,wrapper);
//返回结果
return Result.ok(pageHopotalSet);
}
===========HospitalSetController======GetMapping=============
//3.条件查询带分页
@PostMapping("findPageHospSet/{current}/{limit}")
public Result findPageHospSet(@PathVariable long current,//RequestBody和PostMapping共存
@PathVariable long limit,
@RequestBody(required = false)HospitalSetQueryVo hospitalSetQueryVo) {
//创建page对象,传递当前也,每页记录数
Page page = new Page<>(current, limit);//mybatis-plus的分页
//构建条件
QueryWrapper wrapper = new QueryWrapper<>();//mybatis-plus的QueryWrapper
String hosname = hospitalSetQueryVo.getHosname();//医院名称
String hoscode = hospitalSetQueryVo.getHoscode();//医院编号
if (!StringUtils.isEmpty(hosname)) {
wrapper.like("hosname", hospitalSetQueryVo.getHosname());
}
if (!StringUtils.isEmpty(hoscode)) {
wrapper.eq("hoscode", hospitalSetQueryVo.getHoscode());
}
//调用方法实现分页查询
Page pageHopotalSet = hospitalSetService.page(page,wrapper);
//返回结果
return Result.ok(pageHopotalSet);
}