Oracle+mybatis实现批量插入

发布时间 2024-01-02 21:38:12作者: VincentYew

Oracle+mybatis实现批量插入

1.采用union all

<insert id="insertByBatch"parameterType="java.util.List">
insert into table(
name,
user_id,
age
)
<foreach collection="ist" item="item" index="index"separator="UNION ALL">
select
(
#fitem.name}
#fitem.user_id}
#fitem.age
from dual
)
</foreach>
</insert>