web学习笔记--Mybatis动态Update

<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>