lambdaQuery分页搜索
List<BaseTestPaper> baseTestPapers = this.lambdaQuery() .like(pageTestPaperDto.getCourseType() != null, BaseTestPaper::getCourseType, pageTestPaperDto.getCourseType()) // courseType .like(pageTestPaperDto.getCategoryId() != null, BaseTestPaper::getCategoryId, pageTestPaperDto.getCategoryId()) // categoryId .like(pageTestPaperDto.getTestPaperType() != null, BaseTestPaper::getTestPaperType, pageTestPaperDto.getTestPaperType()) // testPaperType .like(pageTestPaperDto.getFeeFlag() != null, BaseTestPaper::getFeeFlag, pageTestPaperDto.getFeeFlag()) // feeFlag .like(StringUtils.isNotBlank(pageTestPaperDto.getKeyword()), BaseTestPaper::getTestPaperName, pageTestPaperDto.getKeyword()) // keyword .list();
List<SysLogon> list = this.lambdaQuery() .and(StringUtils.isNotBlank(pageDto.getKeyword()) , i -> i .like(SysLogon::getPhone, pageDto.getKeyword()).or() .like(SysLogon::getCompanyName, pageDto.getKeyword()).or() .like(SysLogon::getRealName, pageDto.getKeyword()).or() .like(SysLogon::getUsername, pageDto.getKeyword()) ).orderBy(true, false,SysLogon::getCreateTime).list();