mabatis批量添加

java

/**
 * 批量插入基础类
 *
 * @param list 数据模型对象
 * @return 插入后返回主键
 */
int insertList(@Param("list") List<TableDO> list);

xml

<insert id="insertBatch" parameterType="com.ydfind.dal.model.TableDO">
        INSERT INTO
        T_TABLE(
        MEMO,
        CREATED_AT,
        CREATED_BY,
        UPDATED_AT,
        UPDATED_BY)
        VALUES
        <foreach collection="list" item="item" index="index" separator=",">
            #{item.memo,jdbcType=VARCHAR},
            NOW(),
            #{item.createdBy,jdbcType=VARCHAR},
            NOW(),
            #{item.updatedBy,jdbcType=VARCHAR})
        </foreach>
    </insert>