LambdaQueryWrapper queryWrapper=new QueryWrapper().lambda();
queryWrapper.eq(CompanyCreditFileFinanceCashFlowStatement::getCompanyId,companyId);
queryWrapper.and(wrapper -> wrapper.eq(CompanyCreditFileFinanceCashFlowStatement::getYear,Judge.getYearForNum(-1)).or()
.eq(CompanyCreditFileFinanceCashFlowStatement::getYear,Judge.getYearForNum(-2)).or()
.eq(CompanyCreditFileFinanceCashFlowStatement::getYear,Judge.getYearForNum(-3)).or()
.eq(CompanyCreditFileFinanceCashFlowStatement::getYear,Judge.getYearForNum(-4)));
Listlist=companyCreditFileFinanceCashFlowStatementMapper.selectList(queryWrapper);
QueryWrapper使用or()多条件查询
于 2021-03-16 16:10:48 首次发布