springboot+mp+springclone的分页

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版权协议,转载请附上原文出处链接和本声明。