mybatis+oracle实现批量更新

最新推荐文章于 2025-07-11 09:47:13 发布

原创最新推荐文章于 2025-07-11 09:47:13 发布 · 1.3w 阅读

10 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

12 篇文章

订阅专栏

本文介绍了一种使用MyBatis框架批量更新数据库中订单信息的方法，通过foreach循环和条件判断，实现对订单各字段如订单号、商品名称、物流信息等的灵活更新。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


    <update id="batchUpdateByParams">
        <foreach collection="paramList" item="item" index="index" separator=";"  open="begin" close=";end;">
          UPDATE T_CHANNEL_TRADE_ORDER SET ID = #{item.id,jdbcType=DECIMAL}
            <if test="order.partnerId != null and order.partnerId != ''">
                ,PARTNER_ID = #{order.partnerId}
            </if>
            <if test="order.declareBatchNo != null and order.declareBatchNo != ''">
                ,DECLARE_BATCH_NO = #{order.declareBatchNo}
            </if>
            <if test="order.orderNo != null and order.orderNo != ''">
                ,ORDER_NO = #{order.orderNo}
            </if>
            <if test="order.subMemberCode != null and order.subMemberCode != ''">
                ,SUB_MEMBERCODE = #{order.subMemberCode}
            </if>
            <if test="order.supplyName != null and order.supplyName != ''">
                ,SUPPLY_NAME = #{order.supplyName}
            </if>
            <if test="order.orderDate != null and order.orderDate != ''">
                ,ORDER_DATE = #{order.orderDate}
            </if>
            <if test="order.goodsName != null and order.goodsName != ''">
                ,GOODS_NAME = #{order.goodsName}
            </if>
            <if test="order.goodsCategroy != null and order.goodsCategroy != ''">
                ,GOODS_CATEGROY = #{order.goodsCategroy}
            </if>
            <if test="order.goodsQuantity != null and order.goodsQuantity != ''">
                ,GOODS_QUANTITY = #{order.goodsQuantity}
            </if>
            <if test="order.goodsPrice != null">
                ,GOODS_PRICE = #{order.goodsPrice}
            </if>
            <if test="order.amount != null">
                ,AMOUNT = #{order.amount}
            </if>
            <if test="order.currency != null and order.currency != ''">
                ,CURRENCY = #{order.currency}
            </if>
            <if test="order.logisticsCompany != null and order.logisticsCompany != ''">
                ,LOGISTICS_COMPANY = #{order.logisticsCompany}
            </if>
            <if test="order.logisticsOrderNo != null and order.logisticsOrderNo != ''">
                ,LOGISTICS_ORDERNO = #{order.logisticsOrderNo}
            </if>
            <if test="order.resultCode != null and order.resultCode != ''">
                ,RESULT_CODE = #{order.resultCode}
            </if>
            <if test="order.usedFlag != null and order.usedFlag != ''">
                ,USED_FLAG = #{order.usedFlag}
            </if>
            WHERE 1 = 1
            <if test="item.id != null">
                AND ID = #{item.id,jdbcType=DECIMAL}
            </if>
            <if test="item.declareBatchNo != null and item.declareBatchNo != ''">
                AND DECLARE_BATCH_NO = #{item.declareBatchNo,jdbcType=VARCHAR}
            </if>
            <if test="item.orderNo != null and item.orderNo != ''">
                AND ORDER_NO = #{item.orderNo,jdbcType=VARCHAR}
            </if>
            <if test="item.subMemberCode != null and item.subMemberCode != ''">
                AND SUB_MEMBERCODE = #{item.subMemberCode}
            </if>
        </foreach>
    </update>