mybatis+Oracle批量插入
- 注意:Oracle不能像MySQL一样在
values
后面接多条数据 - 生成32位UUID主键用
sys_guid()
<insert id="batchInsert" parameterType="java.util.List">
INSERT INTO
STUDENTS(ID,NAME,AGE)
SELECT T.* FROM(
<foreach collection="list" item="item" index="index" separator="union all">
SELECT
sys_guid(),#{item.name},#{item.age}
FROM DUAL
</foreach>
)T
</insert>
参考文章:
https://blog.csdn.net/liyaowen505/article/details/88661924
https://blog.csdn.net/qq_30264833/article/details/81263054