<update id="updateOrder" parameterType="com.model.order">
update orders
<trim prefix="set" suffixOverrides=",">
<if test="type!=null and type!=''">
type = #{type,jdbcType=BIGINT},
</if>
<if test="contact!=null and contact!=''">
contact = #{contact,jdbcType=VARCHAR},
</if>
<if test="contact_phone!=null and contact_phone!=''">
contact_phone = #{contact_phone,jdbcType=VARCHAR},
</if>
<if test="title!=null and title!=''">
title =
#{title,jdbcType=VARCHAR},
</if>
<if test="content!=null and content!=''">
content = #{content,jdbcType=VARCHAR},
</if>
<if test="place!=null and place!=''">
place
= #{place,jdbcType=VARCHAR},
</if>
<if test="money!=null and money!=''">
money = #{money,jdbcType=BIGINT},
</if>
<if test="total_money!=null and total_money!=''">
total_money = #{total_money,jdbcType=BIGINT},
</if>
<if test="substation_money!=null and substation_money!=''">
substation_money = #{substation_money,jdbcType=BIGINT},
</if>
</trim>
where id =
#{id,jdbcType=BIGINT}
</update>
web学习笔记--Mybatis动态Update
最新推荐文章于 2024-07-27 14:25:09 发布