oracle判断insert,mybatis+oracle insert 判断

业务需求：需要在插入数据库之前判断该数据是否已经存在数据库中，如果存在则进行update操作，如果不存在则进行insert操作

使用语句：merge into ser_layout_ccic_person a

using (select '证件号' certificate_code,

'身份类型' certificate_type,

'test' name

from dual) b

on (a.certificate_code = b.certificate_code and a.certificate_type=b.certificate_type)

when matched then

update set a.name = b.name

when not matched then

insert

(a.certificate_code, a.certificate_type, a.name)

values

(b.certificate_code, b.certificate_type, b.name)

mybatis配置：

merge into a

using (select #{certificateCode} certificate_code from dual) b

on (a.certificate_code = b.certificate_code)

when matched then

update set a.name = #{name},

a.sex=#{sex},

a.birthday=#{birthday},

a.native_area_code=#{nativeAreaCode},

a.address=#{address},

a.mobile=#{mobile},

a.used_name=#{usedName}

when not matched then

insert

(a.certificate_code, a.certificate_type, a.name,a.used_name,a.sex,a.birthday,a.native_area_code,a.address,a.mobile,a.type,a.insert_flag)

values

(#{certificateCode},#{certificateType},#{name},#{usedName},#{sex},#{birthday},#{nativeAreaCode},#{address},#{mobile},#{type},#{insertFlag})