ibatis中的iterate标签的用法（二）

本文主要是介绍ibatis中的iterate标签的用法（二），希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

<!-- 删除相应的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)




当然你也可以这么写:
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 >
输出sql如下:
delete from 表名 where sex='man' and age in (11 ,12)

这篇关于ibatis中的iterate标签的用法（二）的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---