更新or添加sql

魏万燚

于 2023-03-01 14:14:40 发布

阅读量79

点赞数

文章标签： sql java mysql

本文链接：https://blog.csdn.net/wwy11123/article/details/129280376

版权

更新or添加sql

 <insert id="saveOrUpdateOld">
        <selectKey keyProperty="count" resultType="int" order="BEFORE">
            select count(*) from hospital_config where hospital_id = #{hospitalConfig.hospitalId} and uuid is null
        </selectKey>
        <if test="count > 0">
            update hospital_config
            <set>
                <if test="hospitalConfig.commonConfig != null">
                    common_config = #{hospitalConfig.commonConfig},
                </if>
                <if test="hospitalConfig.config != null">
                    config = #{hospitalConfig.config},
                </if>
                <if test="hospitalConfig.address != null">
                    address = #{hospitalConfig.address},
                </if>
                update_time = sysdate(),
                update_user =#{hospitalConfig.updateUser},
            </set>
            where hospital_id = #{hospitalConfig.hospitalId} and uuid is null
        </if>
        <if test="count==0">
            insert into hospital_config (hospital_id,uuid,address, common_config, config, create_time,
            update_time,update_user)
            values(#{hospitalConfig.hospitalId},#{hospitalConfig.uuid},#{hospitalConfig.address},#{hospitalConfig.commonConfig},#{hospitalConfig.config},sysdate(),sysdate(),#{hospitalConfig.updateUser})
        </if>
    </insert>