mybatis 批量insert oracle需要开启事务吗

发布网友 发布时间：2022-04-20 14:35

我来回答

共1个回答

热心网友 时间：2023-07-16 12:13

<insert id="insertbatch" parameterType="java.util.List">
<selectKey keyProperty="fetchTime" order="BEFORE"
resultType="java.lang.String">
SELECT CURRENT_TIMESTAMP()
</selectKey>
insert into kangaioyaodian ( depart1, depart2, proct_name,
generic_name, img, proct_specification, unit,
approval_certificate, manufacturer, marketPrice, vipPrice,
website, fetch_time, proctdesc ) values
<foreach collection="list" item="item" index="index"
separator=",">
( #{item.depart1}, #{item.depart2}, #{item.proctName},
#{item.genericName}, #{item.img},
#{item.proctSpecification}, #{item.unit},
#{item.approvalCertificate}, #{item.manufacturer},
#{item.marketprice}, #{item.vipprice}, #{item.website},
#{fetchTime}, #{item.proctdesc} )
</foreach>
</insert>