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) ;

 

 

3、select WHERE ORDER_CODE IN <iterate open="(" close=")" conjunction="," > #list_test[]# </iterate>中的#list_test[]#意思 ??

答： 传进去一个数组 list_test使用iterator迭代获取<iterate open="(" close=")" conjunction="," > #list_test[]#</iterate>
解析完了就这样select WHEREORDER_CODE IN(list_test[0],list_test[1],list_test[2]....);

 

 

 

 

 

 

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