<delete id="deleteU5bfqd" parameterType="java.util.List">
delete from 表名 where 列名 in
<foreach collection="list" item="item" index="index" open="(" separator="," close=")">
#{item}
</foreach>
</delete>
<insert id="importU5bfqd" parameterType="java.util.List">
insert into 表名 (列名) values
<foreach collection="list" item="item" index="index" separator=",">
(#{item})
</foreach>
</insert>
java list批量删除和批量添加的数据库语句
最新推荐文章于 2024-05-15 00:11:03 发布