当前位置: 代码迷 >> SQL >> ibatis中sql in话语的配置
  详细解决方案

ibatis中sql in话语的配置

热度:100   发布时间:2016-05-05 13:20:26.0
ibatis中sql in语句的配置

ibatis中sql in语句的配置

ibatis中sql in语句的配置
ibatis中如何配置in语句,需要迭代,不能直接用string的写法
<select id="sql_test" parameterclass="myPramBean" resultclass="myResult">select *from tablewhere name in <iterate property="ids" conjunction="," close=")" open="(" /> #value[]# </iterate>and code=#code#</select>
?

myPramBean{private String code;private List ids;...} 
?

eg:
<delete id="member.batchDelete" parameterClass="java.util.List">      DELETE FROM member where id IN      <iterate conjunction="," open="(" close=")" >          #value[]#       </iterate></delete>
?
  相关解决方案