Mysql 数据库批量更新 批量新增

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>