oracle 不支持 insert into 表名 (column1,column2,column3)values (value1,value2,value3),((value1,value2,value3))该种格式的批量插入 mysql 支持
oracle 写法 如下
<insert id="insertDataList" parameterType="java.util.List">
insert into authen_batch_verify_data(
pk,
verify_id,
id,
name,
certNum,
mobile)
<foreach collection="list" item="uploadData" separator="union all" >
select
CONCAT(#{uuid},#{uploadData.id}),
#{uuid},
#{uploadData.id},
#{uploadData.name},
#{uploadData.certNum},
#{uploadData.mobile}
from dual
</foreach>
</insert>