<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"

结果为如下：