insertOrupdate

liyu121

于 2019-04-28 13:34:20 发布

阅读量977

点赞数

分类专栏： mybaitis

本文链接：https://blog.youkuaiyun.com/liyu121/article/details/89636353

版权

mybaitis 专栏收录该内容

11 篇文章

订阅专栏

本文介绍了一个使用MyBatis框架实现的动态SQL更新或插入操作案例。通过<update>元素结合<selectKey>、<if>及<trim>等标签，展示了如何根据条件动态构建SQL语句，实现对数据库中tt_token表的高效操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<update id="insertOrUpdate" parameterType="TtToken" >
    <selectKey keyProperty="count" resultType="int" order="BEFORE">
        select count(*) from tt_token where user_id = #{userId}
    </selectKey>
    <if test="count > 0">
        update tt_token
        <trim prefix="SET" suffixOverrides=",">
            <if test="expireTime != null  ">expire_time = #{expireTime},</if>
            <if test="updateTime != null  ">update_time = #{updateTime},</if>
        </trim>
        where user_id = #{userId}
    </if>
    <if test="count==0">
        insert into tt_token
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="userId != null  ">user_id,</if>
            <if test="token != null  and token != ''  ">token,</if>
            <if test="expireTime != null  ">expire_time,</if>
            <if test="updateTime != null  ">update_time,</if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="userId != null  ">#{userId},</if>
            <if test="token != null  and token != ''  ">#{token},</if>
            <if test="expireTime != null  ">#{expireTime},</if>
            <if test="updateTime != null  ">#{updateTime},</if>
        </trim>
    </if>
</update>