ibatis example的用法

来源:互联网 发布:山东网络教育 编辑:程序博客网 时间:2024/06/06 20:30
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)
0 1
原创粉丝点击