Mybatis批量添加資料到Oracle記錄

1.批量添加

<insert id="batchInsert" parameterType="java.util.List" useGeneratedKeys="false">
	 INSERT ALL
	<foreach item="item" index="index" collection="list">
		INTO test
		<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="item.id != null and item.id != ''">id,</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides=",">
	    	<if test="item.id  != null and item.id  != ''">#{item.id},</if>
	    </trim>
	 </foreach>
	SELECT 1 FROM DUAL
</insert>