条件查询带分页
- 引入mybatis-plus starter依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.2</version>
</dependency>
- 配置分页插件
@Configuration
@MapperScan(basePackages = "com.atguigu.yygh.mapper")
public class MyBatisPlusConfig {
public MybatisPlusInterceptor paginationInterceptor(){
MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
return mybatisPlusInterceptor;
}
}
- 创建vo类,封装条件值
@Data
public class HospSetVo {
@ApiModelProperty("医院名称")
private String hosname;
@ApiModelProperty("医院编号")
private String hoscode;
}
- 编写controller,获取条件数据、分页数据(当前页,每页记录数)
@GetMapping("findPageHospSet/{current}/{limit}")
public Result findPageHospSet(@PathVariable Integer current, @PathVariable Integer limit, HospSetVo hospSetVo){
Page<HospitalSet> page = new Page<>(current,limit);
QueryWrapper<HospitalSet> wrapper = new QueryWrapper<>();
wrapper.like(StringUtils.isNotBlank(hospSetVo.getHosname()),"hosname",hospSetVo.getHosname());
wrapper.like(StringUtils.isNotBlank(hospSetVo.getHoscode()),"hoscode",hospSetVo.getHoscode());
Page<HospitalSet> hospitalSetPage = hospitalSetService.page(page, wrapper);
return Result.ok(hospitalSetPage);
}
- 在vo前添加注解 @RequestBody,请求的是json格式数据,目的是为了方便前端。
对比修改前后传值的区别。
swagger测试接口时,如下:
![在这里插入图片描述](https://img-blog.csdnimg.cn/3589e605129641518d037d9d759bb088.png?x-oss-process=image/watermark,type_ZHJvaWRzYW5zZmFsbGJhY2s,shadow_50,text_Q1NETiBAbHZpd2k=,size_20,color_FFFFFF,t_70,g_se,x_16)