example Class 使用(可以使用逻辑运算的结合律简化where条件)
代码:
TestTableExample example = new TestTableExample();
example.createCriteria().andField1EqualTo(5);
产生条件:
where field1 = 5
代码:
TestTableExample example = new TestTableExample();
example.createCriteria()
.andField1EqualTo(5)
.andField2IsNull();
example.or(example.createCriteria()
.andField3NotEqualTo(9)
.andField4IsNotNull());
List<Integer> field5Values = new ArrayList<Integer>();
field5Values.add(8);
field5Values.add(11);
field5Values.add(14);
field5Values.add(22);
example.or(example.createCriteria()
.andField5In(field5Values));
example.or(example.createCriteria()
.andField6Between(3, 7));
产生条件:
where (field1 = 5 and field2 is null)
or (field3 <> 9 and field4 is not null)
or (field5 in (8, 11, 14, 22))
or (field6 between 3 and 7)
当一个人找不到出路的时候,最好的办法就是将当前能做好的事情做到极致,做到无人能及。