- 批量更新:
<update id="update" parameterType="java.util.List"> <foreach collection="list" item="item" index="index" open="begin" close=";end;" separator=";" > update 表名 <set> 属性名= #{item.属性名1},name=#{item.属性名n} </set> where id = #{item.主键} </foreach> </update>
批量删除:<delete id="delete" parameterType="List"> DELETE FROM 表名 WHERE id IN <foreach collection="list" index="index" item="item" open="(" separator="," close=")"> #{item} </foreach> </delete>
批量插入:
(oracle)
<insert id="insert" parameterType="List"> insert into 表名(属性名1,属性名2) <foreach collection="list" item="item" index="index" separator="union all" > select #{item.属性名1},#{item.属性名2} from dual </foreach> </insert>