MyBatis Plus分页查询部分字段

方式一：查询指定某字段以外的数据

try {
          
   
            QueryWrapper<AssociationMember> queryWrapper = new QueryWrapper<>();
            //查询指定某字段以外的数据
            queryWrapper.select(AssociationMember.class, info ->!info.getColumn().equals("photo"));
            IPage<AssociationMember> page = new Page<>();
            page.setCurrent(getWorkerMemberInfoReqVo.getCurrentPage());
            page.setSize(getWorkerMemberInfoReqVo.getPageSize());
            queryWrapper.lambda().like(StringUtils.isNotBlank(getWorkerMemberInfoReqVo.getName()),AssociationMember::getName,getWorkerMemberInfoReqVo.getName())
                    .eq(StringUtils.isNotBlank(getWorkerMemberInfoReqVo.getEducationBackground()),AssociationMember::getEducationBackground,getWorkerMemberInfoReqVo.getEducationBackground())
                    .eq(StringUtils.isNotBlank(getWorkerMemberInfoReqVo.getOrgCoding()),AssociationMember::getOrgCoding,getWorkerMemberInfoReqVo.getOrgCoding())
                    .eq(StringUtils.isNotBlank(getWorkerMemberInfoReqVo.getPoliticalStatus()),AssociationMember::getPoliticalStatus,getWorkerMemberInfoReqVo.getPoliticalStatus())
                    .orderByDesc(AssociationMember::getUpdateTime);
            IPage<AssociationMember> iPage=associationMemberMapper.selectPage(page,queryWrapper);
            return ResultVo.success(iPage);
        } catch (Exception e) {
          
   
            log.error("分页查询工作人员基本信息:",e);
            return ResultVo.error("查询失败");
        }

方法二：查询指定字段的数据

QueryWrapper<Member> queryWrapper = new QueryWrapper<>();
            //查询指定字段的数据
            queryWrapper.select("id","name").lambda().eq(StringUtils.isNotBlank(pageQueryMemberListReqVO.getOrgCoding()),Member::getOrgCoding,pageQueryMemberListReqVO.getOrgCoding());
            List<Member> list=memberMapper.selectList(queryWrapper);