mybatis批量插入记录到Oracle

最新推荐文章于 2023-05-21 12:03:36 发布

weixin_33736649

最新推荐文章于 2023-05-21 12:03:36 发布

阅读量76

点赞数

CC 4.0 BY-SA版权

文章标签：数据库 java python

原文链接：https://my.oschina.net/u/2356392/blog/785690

本文介绍了使用MyBatis进行批量数据插入的方法，包括使用序列作为主键和UUID作为主键两种情况，并展示了具体的XML配置文件代码。

2019独角兽企业重金招聘Python工程师标准>>>

序列为主键：

<insert id="insertAll" parameterType="java.util.List">

       <selectKey resultType="int" keyProperty="id" order="BEFORE">
SELECT SEQ_LCSS_DRIVER_ROUTE.NEXTVAL FROM DUAL
</selectKey>

       insert into
           LCSS_DRIVER_ROUTE (id,route_id,shift_id,place,train_id,call_time,attendance_time,delivery_time,playing_time,returning_time,kilometers)
   select SEQ_LCSS_DRIVER_ROUTE.NEXTVAL, A.* from
   (
<foreach collection="list" item="item" separator="union all">
select
   #{item.routeId, jdbcType=VARCHAR} as route_id,
   #{item.shiftId, jdbcType=VARCHAR} as shift_id,
   #{item.place, jdbcType=VARCHAR} as place,
#{item.trainId, jdbcType=VARCHAR} as train_id,
#{item.callTime, jdbcType=VARCHAR} as call_time,
#{item.attendanceTime, jdbcType=VARCHAR} as attendance_time,
#{item.deliveryTime, jdbcType=VARCHAR} as delivery_time,
#{item.playingTime, jdbcType=VARCHAR} as playing_time,
#{item.returningTime, jdbcType=VARCHAR} as returning_time,
#{item.kilometers, jdbcType=INTEGER} as kilometers
from dual
</foreach>
) A

   </insert>

uuid为主键：

<insert id="insertWorkGroupList" parameterType="java.util.List">
       insert into
           LCSS_WORK_GROUP (ID, GROUP_ID, SHIFT_ID, USER_ID, CONDUCTOR_ID)
       <foreach collection="list" item="item" index="index" separator=" UNION ALL ">
       SELECT
           SYS_GUID(),#{item.groupId,jdbcType=VARCHAR},#{item.shiftId,jdbcType=VARCHAR},
           #{item.userId,jdbcType=VARCHAR},#{item.conductorId,jdbcType=VARCHAR}
       FROM DUAL
       </foreach>
   </insert>

转载于:https://my.oschina.net/u/2356392/blog/785690