Mapping中update语句判断非空update

最新推荐文章于 2025-03-07 11:41:51 发布

菜鸟柱子

最新推荐文章于 2025-03-07 11:41:51 发布

阅读量4.3k

点赞数 1

分类专栏： sql 文章标签： update

本文链接：https://blog.youkuaiyun.com/xinpz/article/details/83002296

版权

sql 专栏收录该内容

10 篇文章

订阅专栏

<update id="updateSchoolBriefNotNull" parameterType="com.zichen.xhkq.pojo.SchoolBrief">
    UPDATE `school_brief`
    <set>
　　　　　<if test="title != null and title != ' '">
            `title`=#{title},
        </if>
        <if test="brief != null">
            `brief`=#{brief},
        </if>
        <if test="content != null">
            `content`=#{content},
        </if>
        <if test="schoolId != null">
            `schoolId`=#{schoolId},
        </if>
        <if test="schoolName != null">
           `schoolName`=#{schoolName},
        </if>
        <if test="author != null">
           `author`=#{author},
        </if>
        <if test="schoolAddress != null">
           `schoolAddress`=#{schoolAddress},
        </if>
        <if test="schoolPhone != null">
            `schoolPhone`=#{schoolPhone},
        </if>
        <if test="schoolEmail != null">
            `schoolEmail`=#{schoolEmail},
        </if>
        <if test="priseCount != null">
           `priseCount`=#{priseCount},
        </if>
        sys_time=NOW()
    </set>
    WHERE `id`=#{id}
</update>

1、判断String test="title != null and title != ' ' "

2、注意尾部需要一个固定key,一般是系统时间，防止后面一个空了逗号问题。