Oracle+mybatis实现批量插入

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>