Oracle INSERT ALL
MyBatis 生成 Oracle 批量插入
<insert id="insertALL" parameterType="java.util.List">
INSERT ALL
<foreach collection="list" item="item" index="index" separator=" ">
INTO TableName (
<trim prefixOverrides="," prefix=" ">
<if test="item.ID!=null">,ID</if>
<if test="item.NAME!=null">,NAME</if>
<if test="item.AGE!=null">,AGE</if>
</trim>
)VALUES(
<trim prefixOverrides="," prefix=" ">
<if test="item.ID!=null">,#{item.ID}</if>
<if test="item.NAME!=null">,#{item.NAME}</if>
<if test="item.AGE!=null">,#{item.AGE}</if>
</trim>
)
</foreach>
SELECT 1 FROM DUAL
</insert>
<insert id="insertALL" parameterType="java.util.List">
INSERT INTO TableName ( ID, NAME, AGE)
<foreach collection="list" item="item" index="index" separator=" UNION ALL ">
SELECT #{item.ID}, #{item.NAME}, #{item.AGE} FROM DUAL
</foreach>
</insert>
