mybatis 批量插入

来源:互联网 发布:数据库论文 编辑:程序博客网 时间:2024/06/08 02:22

    public void batchinsertUser(List<User> list);



<insert id = "batchinsertUser"  parameterType = "java.util.List">
insert into users (username,password,phone)
VALUES  
<foreach collection="list" item="item" index="index" separator="," >
  (#{item.username}, #{item.password}, #{item.phone})
</foreach>



@Test
public void addUser()
{

        List<User> list= new ArrayList<User>();
for( int i=1 ;i<= 100 ;i++)
{
User u1=new User();
u1.setUsername("xyh"+i);
u1.setPassword("p"+i);
u1.setPhone("phone"+i);
list.add(u1);
}


userService.batchinsertUser(list);

}





0 0
原创粉丝点击