Mybatis批量插入表数据

表对应Java中实体类

public class Person{
	private String name;
	private Integer age;
	private String sex;

	//......此处省略get set方法
}

Java Dao层接口方法

int batchInsert(List<Person> list);

Mybatis批量新增xml映射文件写法

<insert id="batchInsert" parameterType="java.util.List">
    INSERT INTO person(name, age, sex)
    VALUES
    <foreach collection="list" item="item" separator=",">
        (#{item.name,jdbcType=VARCHAR},#{item.age,jdbcType=INTEGER},#{item.sex,jdbcType=VARCHAR})
    </foreach>
  </insert>

扫二维码关注博主微信公众号👇