ibatis
NO 1、<insert id="batchId" parameterClass="java.util.ArrayList">
insert all
<iterate conjunction="">INTO 表名 (
字段名
) values (
#List[].item#,
)
</iterate>
select * from dual
</insert>
对应于数据库sql如下:
insert all
into test_3(a1, a2, a3, a4) values ('444','444','444','444')
into test_3(a1, a2, a3, a4) values ('555','555','555','555')
select *from dual;
mybatis
NO 2、
<insert id="insertInventoryBatch" >
INSERT INTO 表名
(
字段
)
<foreach collection="list" item="item" index="index" separator=" UNION ALL ">
SELECT
#{item.值,jdbcType=VARCHAR}
FROM
DUAL
</foreach>
</insert>
对应于数据库sql如下:
insert into test_3(a1, a2, a3, a4) select '444','444','444','444' from dual union all select '555','555','555','555' from dual;