ibatis标签iterate实现批量处理数据

最新推荐文章于 2021-02-16 01:11:08 发布

王祈和

最新推荐文章于 2021-02-16 01:11:08 发布

阅读量293

点赞数

文章标签： ibatis iterate 批量插入批量处理

本文链接：https://blog.csdn.net/cheerwong/article/details/84184304

版权

1.批量插入数据（基于oracle的insert all语法）


<insert id="insert" parameterClass="java.util.List">
insert all
<iterate conjunction=" ">
    into t_table ( key, local, value) values
    (#beans[].name#, #beans[].local#, #beans[].value#)
</iterate>
select * from dual
</insert>

2.批量删除数据


<delete id="delete">
    delete from t_table where
    <iterate conjunction="or" open="(" close=")">
	key = #[]#
    </iterate>
</delete>

其中传进来的参数可以是数组也可以是list
或者


<delete id="delete">
    delete from t_table where key in
    <iterate property="keys" conjunction="," open="(" close=")">
	#keys[]#
    </iterate>
</delete>

或者


<delete id="delete">
    delete from t_table
    <iterate prepend="where" property="keys" conjunction="," open=" key in (" close=")">
	#keys[]#
    </iterate>
</delete>