<update id="update" parameterType="com.jing.user">
UPDATE
users
<trim prefix="SET" suffixOverrides=",">
<if test="name!=null and '' != name">
name= #{name},
</if>
<if test="sex!=null and '' != sex">
sex= #{sex},
</if>
</trim>
where id= #{id}
</update>
UPDATE
users
<trim prefix="SET" suffixOverrides=",">
<if test="name!=null and '' != name">
name= #{name},
</if>
<if test="sex!=null and '' != sex">
sex= #{sex},
</if>
</trim>
where id= #{id}
</update>