mysql:
<!-- 插入物品信息 -->
<insert id="addRItem" parameterType="java.util.List">
insert into lzf_rental_item_detailsl
(
id,
rentalInfoId,
itemName,
number,
remark
)
values
<foreach collection="list" item="item" index= "index" separator =",">
(
#{item.id},
#{item.rentalInfoId},
#{item.itemName},
#{item.number},
#{item.remark}
)
</foreach>
</insert>
---------------------
作者:锋至
来源:CSDN
原文:https://blog.csdn.net/windy2014s/article/details/78738004
版权声明:本文为博主原创文章,转载请附上博文链接!
oracle:
<!-- 市级信息全表导入 -->
<insert id="insertAll" parameterType="java.util.List">
insert into P_MUNICIPAL_TARGET
(
ID,
TARGET_ID,
MUNICIPAL_DETAIL,
REMARK
)
<foreach collection="list" item="item" index= "index" separator ="union all">
(
SELECT
#{item.id,jdbcType=VARCHAR},
#{item.targetId,jdbcType=VARCHAR},
#{item.municipalDetail,jdbcType=VARCHAR},
#{item.remark,jdbcType=VARCHAR}
from dual
)
</foreach>
</insert>