mybatis 批量更新 批量添加

<!--批量新增-->
<insert id="addBatch"  parameterType="java.util.List">
    insert into stati_alarm_amount_month (id,stati_year_month,stor_conf_id,alarm_amount,out_amount,in_amount) values
    <foreach collection="list" item="item" index="index" separator=",">
        (#{item.id},#{item.statiYearMonth},#{item.storConfId},#{item.alarmAmount},#{item.outAmount},#{item.inAmount})
    </foreach>
</insert>

<!--批量更新-->
<update id="updateBatch"  parameterType="java.util.List">
    <foreach collection="list" item="item" index="index" separator=";">
      update stati_alarm_amount_month
      set stor_conf_id=#{item.storConfId},alarm_amount=#{item.alarmAmount},out_amount=#{item.outAmount},in_amount=#{item.inAmount}
      where id=#{item.id}
    </foreach>
</update>

mybatis 批量更新 批量添加

原文：https://www.cnblogs.com/flyShare/p/14808564.html