MyBatis条件更新语句

<update id="updateByPrimaryKey" parameterType="com.item.pojo.db3306.TOrder" >
    update t_order
    set
        <if test="orderStatus != null">
          order_status = #{orderStatus,jdbcType=INTEGER},
        </if>
        <if test="orderAmount != null">
          order_amount = #{orderAmount,jdbcType=DECIMAL},
        </if>
        <if test="receiveUser != null">
          receive_user = #{receiveUser,jdbcType=VARCHAR},
        </if>
        <if test="receiveMobile != null">
          receive_mobile = #{receiveMobile,jdbcType=VARCHAR},
        </if>
        <if test="createTime != null">
          create_time = #{createTime,jdbcType=TIMESTAMP},
        </if>
        <if test="updateTime != null">
          update_time = #{updateTime,jdbcType=TIMESTAMP},
        </if>
        <if test="createUser != null">
          create_user = #{createUser,jdbcType=VARCHAR}
        </if>
   
    where id = #{id,jdbcType=INTEGER}
  </update>

 update t_order set order_status = ?, order_amount = ?, receive_user = ?, receive_mobile = ?, create_time = ?, update_time = ?, where id = ?

修改成 set +if这种语法格式，这样保证了update_time = ?,后面的问号去掉
重要：（使用set 系统会自动去掉最后一个,）

  <update id="updateByPrimaryKey" parameterType="com.item.pojo.db3306.TOrder" >
    update t_order
    <set>
        <if test="orderStatus != null">
          order_status = #{orderStatus,jdbcType=INTEGER},
        </if>
        <if test="orderAmount != null">
          order_amount = #{orderAmount,jdbcType=DECIMAL},
        </if>
        <if test="receiveUser != null">
          receive_user = #{receiveUser,jdbcType=VARCHAR},
        </if>
        <if test="receiveMobile != null">
          receive_mobile = #{receiveMobile,jdbcType=VARCHAR},
        </if>
        <if test="createTime != null">
          create_time = #{createTime,jdbcType=TIMESTAMP},
        </if>
        <if test="updateTime != null">
          update_time = #{updateTime,jdbcType=TIMESTAMP},
        </if>
        <if test="createUser != null">
          create_user = #{createUser,jdbcType=VARCHAR}
        </if>
    </set>
    where id = #{id,jdbcType=INTEGER}
  </update>

update t_order SET order_status = ?, order_amount = ?, receive_user = ?, receive_mobile = ?, create_time = ?, update_time = ? where id = ?