<!-- 删除相应的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 >
< 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)
当 然你也可以这么写:
P erson.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 >
< 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)
来源:http://blog.csdn.net/xymyeah/archive/2009/05/12/4172379.aspx