1、数据库连接加上 allowMultiQueries=true、否则无法执行批量更新
<foreach collection="list" item="item" separator=";" open="" close=";">
UPDATE XXX SET XXX = #{item.XXX}
WHERE XXX = #{XXX} AND CARGOLANEID = #{XXX}
</foreach>
2、批量新增
<insert id="insertThirdApplyBrand" parameterType="java.util.Map">
INSERT INTO NP_APPLY_BRAND(APPLY_THIRD_ID,APPLY_BRAND_NAME)
VALUES
<foreach collection="applyBrandList" item="item" separator="," close=";">
(#{storeId},#{item.brandName})
</foreach>
</insert>
3、批量删除
<delete id="delApplyBrandByList" parameterType="java.util.List">
<foreach collection="list" item="item" separator=";" close=";">
DELETE FROM NP_APPLY_BRAND WHERE APPLY_BRAND_ID = #{item.id}
</foreach>
</delete>
