mybatis批量插入数据到oracle

1. JAVA

   testMapper.addTest(testList);

    

2. 配置文件

3. <insert id="addTests" parameterType="java.util.ArrayList">
       insert into TEST(t_id,t_des,t_status) 
   	SELECT T.* 
   	FROM(
   	<foreach collection="list" item="test" index="index" separator="UNION ALL">
    	SELECT 
        	 #{test.tId} tId,
        	 #{test.TDes} TDes,
        	 #{test.TStatus} TStatus 
        FROM dual
      </foreach>
      ) T
   </insert>