[Java] ibatis结合oracle批量插入三种方法的测评

< insert id =" insert_table " parameterclass ="java.util.list" >  
  <![cdata[ 
  insert into sj_test( col1 , col2 , col3 ) values 
  ]]>  
  < iterate conjunction ="," >  
  <![cdata[ 
    (#test[]. col1 #, # test []. col2 #, # test []. col3 #) 
  ]]>  
  </ iterate >  
</ insert >

<insert id="insert_table " parameterclass="java.util.list">
 insert all
 <iterate conjunction="">
 into sj_test( col1 , col2 , col3 ) values 
 (#test[]. col1 #, # test []. col2 #, # test []. col3 #) 
 </iterate>
 <!--必须要加上 -->
 select * from dual
</insert>

<insert id="insert_table" parameterclass="java.util.list">
insert into sj_test( col1 , col2 , col3 ) values  select 
col1 , col2 , col3 
from (
<iterate conjunction=" union all ">
select 
#test[].col1# as col1 , #test []. col2# as col2, # test[].col3# as col3 from dual
</iterate>
)
</insert>