mysql主键或者唯一索引重复修改,不重复新增

mybaits在新增</insert>里加入 ON DUPLICATE KEY UPDATE
实例

<insert id="insert">
        INSERT INTO ws_product_fun(
            id,
            pro_sum_id,
            fun_title,
            fun_desc,
            fun_photo,
            fun_sort,
            isdel,
            create_user,
            create_time                     
        )
        VALUES (
            #{id},
            #{proSumId},
            #{funTitle},
            #{funDesc},
            #{funPhoto},
            #{funSort},
            #{isdel},
            #{createUser},
            now()                      
        )
        ON DUPLICATE KEY UPDATE
        <if test= "proSumId !=null and proSumId !=''" >
            pro_sum_id = #{proSumId},
        </if>
        <if test= "funTitle !=null and funTitle !=''" >
            fun_title = #{funTitle},
        </if>
        <if test= "funDesc !=null and funDesc !=''" >
            fun_desc = #{funDesc},
        </if>
        <if test= "funPhoto !=null and funPhoto !=''" >
            fun_photo = #{funPhoto},
        </if>
        <if test= "funSort !=null and funSort !=''" >
            fun_sort = #{funSort},
        </if>
        <if test= "isdel !=null and isdel !=''" >
            isdel = #{isdel},
        </if>
        <if test= "createUser !=null and createUser !=''" >
            create_user = #{createUser},
        </if>
        <if test= "createTime !=null and createTime !=''" >
            create_time = #{createTime},
        </if>
        <if test= "updateUser !=null and updateUser !=''" >
            update_user = #{updateUser},
        </if>
        update_time = now()
    </insert>

如果同时存在主键和唯一索引,先判断主键是否重复,在判断唯一索引,都没重复就新增,有重复就修改