mybatisplus分页/不分页

44 阅读1分钟

mybatisplus分页/不分页

1.不带分页,用List

Controller

 // 3.获取考核规则配置信息,可以通过“考核信息配置id”或者合同编号、专业筛选。多条
        QueryWrapper<ContConfAssessRuleDto> queryWrapper4 = new QueryWrapper<>();
        queryWrapper4.eq("contract_code",params.get("contractCode"));
        queryWrapper4.eq("professional",params.get("professional"));
//不带分页查询        
List<ContConfAssessRuleDto> assessRule=contConfAssessRuleService.listRule(queryWrapper4);

         Result.ok().put("assessRule",assessRule);

Service

    List<ContConfAssessRuleDto> listRule(QueryWrapper<ContConfAssessRuleDto> queryWrapper4);

Impl

  @Override
    public List<ContConfAssessRuleDto> listRule(QueryWrapper<ContConfAssessRuleDto> queryWrapper4) {
        return this.baseMapper.listRule(queryWrapper4);
    }

dto

dao

@Mapper
//注意 @Param(Constants.WRAPPER) 修饰queryMapper
public interface ContConfAssessRuleDao extends BaseMapper<ContConfAssessRuleEntity> {

List<ContConfAssessRuleDto> listRule(@Param(Constants.WRAPPER)QueryWrapper<ContConfAssessRuleDto> queryWrapper4);
}

xml

2.带分页,用PageUtile

Controller

/**
     * 合同信息查询
     */
    @RequestMapping("/listContract")
    public Result listContract(@RequestParam Map<String, Object> params) {
        //获取考核负责人即当前id
        String userId = AuthUtils.getUserId();

        PageUtils page = contAssessInfoService.listContract(userId, params);
        return Result.ok().put("page", page);
    }

Service

 PageUtils listContract(String userId, Map<String,Object> params);

impl

 @Override
    public PageUtils listContract(String userId, Map<String,Object> params) {
        QueryWrapper<ContContractInfoDto> queryWrapper = new QueryWrapper<ContContractInfoDto>();
        //分页查询
        IPage<ContContractInfoDto> page = this.baseMapper.queryPageCont(userId,new Query<ContContractInfoDto>().getPage(params), queryWrapper);
        return new PageUtils(page);
    }

dto

dao

IPage<ContContractInfoDto> queryPageCont(@Param("userId")String userId, IPage<ContContractInfoDto> page, @Param(Constants.WRAPPER) QueryWrapper<ContContractInfoDto> queryWrapper);

xml