1、实体类:
public class Users implements Serializable{
/**
*
*/
private static final long serialVersionUID = -7958407366908741797L;
private String id;
private String name;
private String age;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAge() {
return age;
}
public void setAge(String age) {
this.age = age;
}
2、Mapper.java接口
void addUserList(List<Users > list);
3、Mapping.xml
<insert id="addUserList" parameterType="java.util.List">
insert into users (id,name,age)
values
<foreach collection="list" item="item" index="index" separator=",">
(#{item.id,jdbcType=VARCHAR}, #{item.name,jdbcType=VARCHAR},#{item.age,jdbcType=VARCHAR})
</foreach>
</insert>