mybatis批量插入oracle解决方法

1. <insert id="insertBatch" parameterType="ArrayList" >

2. <!-- <selectKey keyProperty="signal_id" order="BEFORE" resultType="int">

3.   SELECT signal_sequence.NEXTVAL FROM DUAL

4.  </selectKey>

5. -->

7.  INSERT INTO signal(id , name , address) SELECTsignal_sequence.NEXTVAL , A.* FROM (

8.  <foreach collection="list" item="item" index="index" separator="UNION">

9.   SELECT #{item.name} , #{item.address} FROM DUAL

10.  </foreach>

11.  ) A

12. </insert>