oracle中mybatis批量插入

oracle 批量插入

    <insert id="id名称" parameterType="java.util.List" useGeneratedKeys="false">
        insert all
        <foreach collection="list" item="item" index="index" separator="">
            into 表名
            <trim prefix="(" suffix=")" suffixOverrides=",">
            	<if test="item.字段名 != null">
                	表字段名,
            	</if>
            </trim>
            <trim prefix="values (" suffix=")" suffixOverrides=",">
               <if test="item.字段名 != null">
                    #{item.字段名,jdbcType=TIMESTAMP},
                </if>
			</trim>
         </foreach>
        select 1 from dual
    </insert>