• oralce 批量更新


    <update id="batchUpdateCompensatoryData" parameterType="java.util.List">
    <foreach collection="detailInfos" item="detailInfo" index="index" open="begin" close=";end;" separator=";">
    update TD_B_COMPENSATORY_DETAIL_INFO
    <set>
    update_date= sysdate,
    overdue_days= #{detailInfo.overdueDays,jdbcType=DOUBLE},
    overdue_manage_fee=#{detailInfo.overdueManageFee,jdbcType=DOUBLE},
    overdue_penalty=#{detailInfo.overduePenalty,jdbcType=DOUBLE},
    other_fee=#{detailInfo.otherFee,jdbcType=DOUBLE},
    comp_money=#{detailInfo.compMoney,jdbcType=DOUBLE},
    repay_capital=#{detailInfo.repayCapital,jdbcType=DOUBLE},
    repay_interest=#{detailInfo.repayInterest,jdbcType=DOUBLE},
    repay_sum_money=#{detailInfo.repaySumMoney,jdbcType=DOUBLE}
    </set>
    where id=#{detailInfo.id}
    </foreach>
    </update>

  • 相关阅读:
    python框架之Django(2)-简单的CRUD
    python框架之Django(1)-第一个Django项目
    实习进度13
    实习进度12
    实习进度11
    实习进度10
    学习进度08
    毕设进度07
    毕设进度06
    毕设进度05
  • 原文地址:https://www.cnblogs.com/Struts-pring/p/8058613.html
Copyright © 2020-2023  润新知