controller层
/**
* 根据条件分页查询所有品牌
* @param pageCurrent
* @param pageSize
* @param brandVo
* @return
*/
@ApiOperation("根据条件分页查询所有品牌")
@ApiImplicitParams({
@ApiImplicitParam(dataType = "int",name = "pageCurrent",value = "页码数"),
@ApiImplicitParam(dataType = "int",name = "pageSize",value = "每页显示的个数"),
@ApiImplicitParam(dataType = "BrandVo",name = "brandVo",value = "查询条件的实体类"),
})
@PostMapping("findBrandsWithCondition/{pageCurrent}/{pageSize}")
private CommonResult findBrandsWithCondition(@PathVariable Integer pageCurrent, @PathVariable Integer pageSize, @RequestBody BrandVo brandVo){
return brandService.findBrandsWithCondiction(pageCurrent,pageSize,brandVo);
}
service层
/**
* 根据条件所有实体类
* @param pageCurrent
* @param pageSize
* @param brandVo
* @return
*/
@Override
public CommonResult findBrandsWithCondiction(Integer pageCurrent, Integer pageSize, BrandVo brandVo) {
IPage<Brand> page = new Page<>(pageCurrent,pageSize);
QueryWrapper<Brand> queryWrapper = new QueryWrapper<>();
if (brandVo.getBrandid()!=null) {
queryWrapper.eq("g_brand.id", brandVo.getBrandid());
}
if (brandVo.getStatus()!=null){
queryWrapper.eq("g_brand.status",brandVo.getStatus());
}
if (brandVo.getSortid()!=null){
queryWrapper.eq("g_brand.sortid",brandVo.getSortid());
}
if (brandVo.getStatus()==null && brandVo.getBrandid()==null && brandVo.getSortid()==null){
queryWrapper = null;
}
IPage<Brand> brandIPage = brandMapper.findBrandsWithCondiction(page, queryWrapper);
return new CommonResult(2000,"查询成功",brandIPage);
}
/**
* 根据条件分页查询所有品牌
* @param pageCurrent
* @param pageSize
* @param brandVo
* @return
*/
CommonResult findBrandsWithCondiction(Integer pageCurrent, Integer pageSize, BrandVo brandVo);
mapper层
IPage<Brand> findBrandsWithCondiction(IPage<Brand> page,@Param("ew") QueryWrapper<Brand> queryWrapper);
版权声明:本文为huyulong0612原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。