表对应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>
扫二维码关注博主微信公众号👇