本文介绍了在ibatis中如何正确配置使用IN语句的方法。通过示例展示了如何利用iterate标签进行参数迭代，实现动态SQL的功能。适用于需要批量操作数据库记录的场景。
[b]ibatis中如何配置in语句，需要迭代，不能直接用string的写法[/b]
[size=medium]
<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>[/size]
[size=medium]
<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>[/size]
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
