<insertid="saveList"parameterType="list">
insert into 表名
<foreachcollection="list"item="item"index="index"separator="union all">
select #{item.字段名,jdbcType=DECIMAL},
#{item.字段名,jdbcType=VARCHAR},
#{item.字段名,jdbcType=INTEGER}
from dual
</foreach></insert>
<insertid="save"parameterType="list">
insert all
<foreachcollection="List"index="index"item="item"open=""close=""separator="">
into 表名(字段名,字段名)
values
(
#{item.字段名},
</foreach>
select 1 from dual;
</insert>
<insertid="save"parameterType="list">
insert into 表名(字段名,字段名) values
<foreachcollection="List"index="index"item="item"open="begin"close=";end;"separator=";">
#{item.字段名},
</foreach>
select 1 from dual;
</insert>