插入数据如果主键冲突则修改数据

 <insert id="insertRefuelingGunInfo" parameterType="RefuelingGunInfo">
        insert into refueling_gun_info
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="id != null">id,</if>
            <if test="gasStationId != null">gas_station_id,</if>
            <if test="fillingMachineId != null">filling_machine_id,</if>
            <if test="refuelingGunSerialnumber != null">refueling_gun_serialnumber,</if>
            <if test="refuelingGunNo != null">refueling_gun_no,</if>
            <if test="product != null">product,</if>
            <if test="refuelingGunStatus != null">refueling_gun_status,</if>
            <if test="explai != null">explai,</if>
            <if test="updateBy != null">update_by,</if>
            <if test="updateTime != null">update_time,</if>
            <if test="createBy != null">create_by,</if>
            <if test="createTime != null">create_time,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},</if>
            <if test="gasStationId != null">#{gasStationId},</if>
            <if test="fillingMachineId != null">#{fillingMachineId},</if>
            <if test="refuelingGunSerialnumber != null">#{refuelingGunSerialnumber},</if>
            <if test="refuelingGunNo != null">#{refuelingGunNo},</if>
            <if test="product != null">#{product},</if>
            <if test="refuelingGunStatus != null">#{refuelingGunStatus},</if>
            <if test="explai != null">#{explai},</if>
            <if test="updateBy != null">#{updateBy},</if>
            <if test="updateTime != null">#{updateTime},</if>
            <if test="createBy != null">#{createBy},</if>
            <if test="createTime != null">#{createTime},</if>
        </trim>
        ON DUPLICATE KEY UPDATE
        <trim prefix="" suffixOverrides=",">
            <if test="gasStationId != null">gas_station_id = #{gasStationId},</if>
            <if test="fillingMachineId != null">filling_machine_id = #{fillingMachineId},</if>
            <if test="refuelingGunSerialnumber != null">refueling_gun_serialnumber = #{refuelingGunSerialnumber},</if>
            <if test="refuelingGunNo != null">refueling_gun_no = #{refuelingGunNo},</if>
            <if test="product != null">product = #{product},</if>
            <if test="refuelingGunStatus != null">refueling_gun_status = #{refuelingGunStatus},</if>
            <if test="explai != null">explai = #{explai},</if>
            <if test="updateBy != null">update_by = #{updateBy},</if>
            <if test="updateTime != null">update_time = #{updateTime},</if>
            <if test="createBy != null">create_by = #{createBy},</if>
            <if test="createTime != null">create_time = #{createTime},</if>
        </trim>
    </insert>

 使用insert into+。。。。。+  ON DUPLICATE KEY UPDATE 语句

注意：update后面没有set  没有set   没有set   （重要的事情说三遍）