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)