工作中遇到了,随手记录下来
<insert id="insertByBatch" parameterType="java.util.List" useGeneratedKeys="false">
insert into TABLE_NAME
(
PID,
PLAN_ID,
FLIGHT_NO
)
select SEQ_TABLE_NAME.nextval, cd.* from (
<foreach collection="list" item="data" index="index" separator="union all">
(
select
#{data.planId, jdbcType=DECIMAL},
#{data.flightNo, jdbcType=VARCHAR}
from dual
)
</foreach>
) cd
</insert>