百度出来说:在Example中的每一个Criteria相当于一个括号,把里面的内容当成一个整体
@Autowired
OneAccountService oneAccountService;
@Test
public void testImage() throws Exception {
Example example = new Example(OutsourcingCompany.class);
Example.Criteria criteria = example.createCriteria();
//条件1 and 条件2
criteria
.andEqualTo("state", StateEnum.NO_DELETE.getCode())
.andEqualTo("id", 1);
//and (条件3 or 条件4)
Example.Criteria criteria1 = example.createCriteria();
criteria1
.andEqualTo("state", StateEnum.NO_DELETE.getCode())
.andEqualTo("id", 2);
example.or(criteria1);
System.out.println("---------------------------------");
List<OutsourcingCompany> outsourcingCompanies = outsourcingCompanyMapper.selectByExample(example);
System.out.println("---------------------------------");
}
mypper 3.4.3 版本 使用 Criteria 怎么实现 where 条件 1 and (条件 2 or 条件 3)