oracle mybatis 批量insert
<insert id="insertBatch" parameterType="java.util.List" >
insert into table(A,B,C,D,CREATED_DATE)
SELECT t.*
FROM (
<foreach collection="list" item="item" separator="UNION ALL">
SELECT
#{item.a} AS A,
#{item.b} AS B,
#{item.c} AS C,
#{item.d} AS D,
SYSDATE AS CREATED_DATE
FROM dual
</foreach>
) t
</insert>
浙公网安备 33010602011771号