ibatis中使用merge into

最新推荐文章于 2022-11-11 07:00:00 发布

luckystar2008

最新推荐文章于 2022-11-11 07:00:00 发布

阅读量4.6k

点赞数

文章标签： ibatis

本文链接：https://blog.csdn.net/qincidong/article/details/40431625

版权

Struts/Spring/Hibernate/Iibatis/Mybaits 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

<statement id="updateCustomerRelativeWithSpouseByCustomerId4TXT" parameterClass="java.util.Map">
    merge into customer_relative a
    using (select #customerId# as customerId from dual) b
    on (a.customerid = b.customerid and a.relation = '1')
    when matched then
        update
        set updated_date = sysdate
        <dynamic>
            <isNotEmpty prepend="," property="spouse">FULLNAME=#spouse#</isNotEmpty>
            <isNotEmpty prepend="," property="spouse_mobile">MOBILE_PHONE = #spouse_mobile#</isNotEmpty>
            <isNotEmpty property="spouse_telephone_area">
                <isNotEmpty prepend="," property="spouse_telephone_code">
                    TELPHONE = #spouse_telephone_area# || '-' || #spouse_telephone_code#
                </isNotEmpty>
            </isNotEmpty>
            <isNotEmpty prepend="," property="spouse_telephone_extension">CORPEXTENSION = #spouse_telephone_extension#</isNotEmpty>
            <isNotEmpty prepend="," property="spouse_salary">MONTHLY_INCOME = to_number(#spouse_salary#)</isNotEmpty>
        </dynamic>
    when not matched then
        insert(RELATIVEID,CUSTOMERID,RELATION,FULLNAME,TELPHONE,MOBILE_PHONE,CREATED_BY,CREATED_DATE,UPDATED_BY,UPDATED_DATE,MONTHLY_INCOME,CORPEXTENSION)
        values(sys_guid(),#customerId#,'1',#spouse#,case when #spouse_telephone_area# is not null and #spouse_telephone_code# is not null then #spouse_telephone_area# || '-' || #spouse_telephone_code# end,#spouse_mobile#,'TXT',sysdate,'TXT',sysdate,to_number(#spouse_salary#),#spouse_telephone_extension#)    
</statement>