mybaties 批量插入

oracle:

insert into talbe (........) select sequence.nextval id , T.* from
  ( 
      <foreach collection = "List" item = "item" separator = "union all">
             select #{item} from dual
      </foreach>
  )T
  
***

## sql中没有values 

***

mysql:

insert into table (..........) vaules
    <foreach collection = "List"  item = "item" separator = ",">
           (#{item})
    </foreach>