mybaits批量插入sql，没有新加，有就更新对应字段

 <insert id="insertBatchUpdate"  parameterType="java.util.List">
        INSERT INTO bgd_collect_bag_progress (create_date,card_bag_id,channel,platform,card_unlock_num,collect_progress,collect_progress_num) VALUES
        <foreach collection="list" item="record" index="index" separator=",">
            (#{record.createDate,jdbcType=DATE}, #{record.cardBagId,jdbcType=INTEGER},#{record.channel,jdbcType=INTEGER},#{record.platform,jdbcType=INTEGER}, #{record.cardUnlockNum,jdbcType=INTEGER}, #{record.collectProgress,jdbcType=VARCHAR},#{record.collectProgressNum,jdbcType=INTEGER})
        </foreach>
        ON DUPLICATE KEY UPDATE collect_progress_num = VALUES (collect_progress_num),card_unlock_num = VALUES (card_unlock_num)
    </insert>

更新前提设置对应索引，自己测试一下