ibatis的动态查询

 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)