Mapping中update语句 判断非空update

<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,一般是系统时间，防止后面一个空了逗号问题。