ibatis中iterate的用法（conjunction="or" ","）

 

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

 

 

来源：http://blog.csdn.net/xymyeah/archive/2009/05/12/4172379.aspx