java数据批量添加

需要传参的实体类多余的get set方法就不复制了

public class User {


private int uid;


private String uname;
private String age;
private String sex;


private String phone;
private Date creatTime;
public User() {
super();
}

public class UserInput {


private List<User> userList;


public UserInput() {
super();
// TODO Auto-generated constructor stub
}

sql语句

<!-- 批量添加 -->
  <insert id="savaUserList" parameterType="com.xxxx.xxxxxx.model.vo.input.UserInput">
    insert into t_user(uname,age,sex,phone,creat_time)values
    <foreach collection="userList" item="item" index="index" separator=",">
                (#{item.uname},#{item.age},#{item.sex},#{item.phone},null)
         </foreac