mysql批量添加list数据_mybatis 批量将list数据插入到数据库的实现

随着业务需要，有时我们需要将数据批量添加到数据库，mybatis提供了将list集合循环添加到数据库的方法。具体实现代码如下:

1、mapper层中创建 insertForeach(List < Fund > list) 方法,返回值是批量添加的数据条数

package com.center.manager.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.center.manager.entity.Fund;

@Mapper

public interface FundMapper {

int insertForeach(List list);

}

Fund类代码如下:

package com.center.manager.entity;

import java.util.Date;

public class Fund {

private String id;

private String fundName;

private String fundCode;

private String dateX;

private String dataY;

private String remarks;

private String createBy;

private Date createDate;

private String updateBy;

private Date updateDate;

private String delFlag;

public Str