mybatis 批量添加更新操作
关键字:
ON DUPLICATE KEY UPDATE
<insert id="batchSaveCommissionSummaryList" parameterType="list" >
insert into commission_summary
(enterprise_id,enterprise_name,in_province_amount,in_province_rate,in_province_commission,out_province_amount,out_province_rate,
out_province_commission,total_amount,total_commission,month,create_time)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.enterpriseId},#{item.enterpriseName},#{item.inProvinceAmount},#{item.inProvinceRate},#{item.inProvinceCommission},#{item.outProvinceAmount},
#{item.outProvinceRate},#{item.outProvinceCommission},#{item.totalAmount},#{item.totalCommission},#{item.month},#{item.createTime})
</foreach>
ON DUPLICATE KEY UPDATE
enterprise_id = values(enterprise_id),
enterprise_name = values(enterprise_name),
in_province_amount = values(in_province_amount),
in_province_rate = values(in_province_rate),
in_province_commission = values(in_province_commission),
out_province_amount = values(out_province_amount),
out_province_rate =values(out_province_rate),
out_province_commission = values(out_province_commission),
total_amount = values(total_amount),
total_commission = values(total_commission),
month = values(month),
create_time = values(create_time)
</insert>