ibatis 的 iterate 的用法

http://sunfish.blog.51cto.com/417500/108315
PersonDaoImp如下:
/**
* 删除性别为man,年龄为 11,12 的Person记录
*/
public int deletePerson(Map<String, Object> map) {

List<Person> personList=new ArrayList<Person>();

Person p1=new Person(11);
person p2=new Person(12);
personList.add(p1);
personList.add(p2);

map.put("personList", personList);

map.put("sex",'man');
return getSqlMapClientTemplate().delete(
"person.deletePerson", map);
}
person.xml如下:

<!-- 删除相应的person记录 -->
<delete id="deletePerson" parameterClass="map">

delete from 表名 where      sex=#sex#        
<iterate prepend="and" property="personList" open="("
close=")" conjunction="or">
age=$personList[].age$
</iterate>

</delete>
输出sql如下:
delete from 表名 where sex='man' and (age =11 or age=12)

当然你也可以这么写:
person.xml如下:

<!-- 删除相应的person记录 -->
<delete id="deletePerson" parameterClass="map">

delete from 表名 where      sex=#sex#     and age in  
<iterate property="personList" open="("
close=")" conjunction=",">
$personList[].age$
</iterate>

</delete>
输出sql如下:
delete from 表名 where sex='man' and age in (11 ,12)

最后Person代码大致如下:

public class Person{
public Person(int age){
this.age=age;
}
/**
* 年龄
*/
private int age;
/**
* 性别
*/
private String sex;

//get/set方法略
...
}//end of Person

本文出自 “sunfish 翻车鱼” 博客，请务必保留此出处http://sunfish.blog.51cto.com/417500/108315