mybatis insert or update 用法

<insert id="insertOrUpdate" parameterType="SysXXDO">
   insert into sys_param (param_id, type, value, create_time, create_by) values (
       #{paramId},
       #{type},
       #{value},
       #{createTime},
       #{userName} )
    ON DUPLICATE key update
       param_id = values(param_id),
       type = values(type),
       value = values(value),
       update_time = values(create_time),
       update_by = values(create_by)
</insert>

insert or update mybatis语法 


版权声明:本文为dj7858177原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。