<insert id="insertByBatch" parameterType="java.util.List">
insert into table(
sid_lv1,
name_lv1,
sid_lv2,
name_lv2,
sid_lv3,
name_lv3
)
<foreach collection="list" item="item" index="index"
separator="UNION ALL">
(
select
#{item.sidLv1},
#{item.nameLv1},
#{item.sidLv2},
#{item.nameLv2},
#{item.sidLv3},
#{item.nameLv3}
from dual
)
</foreach>
</insert>
注意测试时每组数据的参数要全部传进来,如果参数的value为空,也要把参数传进来,不然会报错缺少参数。