<insert id="insertBatchList" parameterType="java.util.List" useGeneratedKeys="false">
insert into tableName
(
PROGRAMME_ID,
SERIAL_NUM,
UPLOAD_PROGRESS,
UPLOAD_STATUS
)
<foreach collection="list" item="item" index="index" separator="union all">
(SELECT
#{item.programmeId, jdbcType=VARCHAR},
#{item.serialNum, jdbcType=VARCHAR},
#{item.uploadProgress, jdbcType=VARCHAR},
#{item.uploadStatus, jdbcType=VARCHAR}
FROM dual)
</foreach>
</insert>
separator必须是union all, 没有主建的时候,使用 useGeneratedKeys="false"
结果为如下: