<update id="batchUpdateOrder" parameterType="java.util.List">
begin <foreach collection="list" item="item" index="index" separator=";"> update mp_order <set> <if test="item.orderPostcode != null and item.orderPostcode != ''"> ORDER_POSTCODE = #{item.orderPostcode,jdbcType=VARCHAR}, </if> <if test="item.customerName != null and item.customerName != ''"> CUSTOMER_NAME = #{item.customerName,jdbcType=VARCHAR}, </if> <if test="item.credentialsType != null and item.credentialsType != ''"> CREDENTIALS_TYPE = #{item.credentialsType,jdbcType=VARCHAR}, </if> <if test="item.credentialsNo != null and item.credentialsNo != ''"> CREDENTIALS_NO = #{item.credentialsNo,jdbcType=VARCHAR}, </if> <if test="item.storeOrderType != null and item.storeOrderType != ''"> STORE_ORDER_TYPE = #{item.storeOrderType,jdbcType=VARCHAR}, </if> <if test="item.orderSource != null and item.orderSource != ''"> ORDER_SOURCE = #{item.orderSource,jdbcType=VARCHAR}, </if> <if test="item.totalTariff != null and item.totalTariff != ''"> TOTAL_TARIFF = #{item.totalTariff,jdbcType=DECIMAL}, </if> </set> WHERE ORDER_NO = #{item.orderNo,jdbcType=VARCHAR} </foreach> ;end; </update>