mybatis 批量添加数据

1 mysql 批量 insert into

 INSERT INTO 表

            (id)

        VALUES

            <foreach collection="list" item="item" separator=",">

                (IFNULL(#{item.id},0))

            </foreach>

    </insert>

2  oracle 批量insert into

  <insert id="bathInsert" parameterType="java.util.List" useGeneratedKeys="false">
        INSERT INTO 表
        ( ID, ...
        )
        <foreach item="item" index="index" collection="list" separator="union all">
            SELECT
            #{item.id}, ...
            FROM DUAL
        </foreach>
    </insert>