update if判断进行动态sql拼接

时间:2025-03-28 19:01:55
<update id="updateOption" parameterType=""> update system_option set <if test="url != null and url !=''"> url = #{url}, </if> <if test="description != null and description !=''"> description = #{description}, </if> <if test="name != null and name !=''"> name = #{name }, </if> <if test="parentID != null and parentID !=''"> parentID = #{parentID }, </if> <if test="sequence != null and sequence !=''"> sequence = #{sequence }, </if> uuid=#{uuid} where uuid = #{uuid} </update>