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>

posted @ 2017-12-18 17:15  Struts-pring  阅读(258)  评论(0编辑  收藏  举报