本文共 1764 字，大约阅读时间需要 5 分钟。

我们在上一篇整合SpringBoot的基础之上，再进行批量的实验。

首先，DruidDBConfig配置文件中，添加配置

//批量更新时,需要此配置List
   
     filterList=new ArrayList
    
     ();filterList.add(wallFilter());datasource.setProxyFilters(filterList);
    
   

application.properties配置文件的spring.datasource.url后面添加

allowMultiQueries=true

配置文件配置好后，我们可以开始准备代码了

UserMapper.xml文件

   
    	insert into user (name, age)	values	
    
     		(#{user.name},#{user.age})	
    
   
   	
    
     		update user		set name = #{user.name}, age = #{user.age} where id = #{user.id}	
    
   
   
    	delete from user where id in	
    
     		#{id}	
    
   

UserMapper

int batchInsert(List
   
     userList);	int batchUpdate(List
    
      userList);	int batchDelete(List
     
       idList);
     
    
   

UserService

public int batchInsert(List
   
     userList) {	return userMapper.batchInsert(userList);}public int batchDelete(List
    
      idList) {	return userMapper.batchDelete(idList);}public int batchUpdate(List
     
       userList) {	return userMapper.batchUpdate(userList);}
     
    
   

单元测试

@Testpublic void batchInsert() {	List
   
     list =new ArrayList
    
     ();	for(int i=1;i<=3;i++){		User user=new User();		user.setAge(i);		user.setName("insert"+i);		list.add(user);	}	int result = userService.batchInsert(list);	log.info("result:" + result);}	@Testpublic void batchUpdate() {	List
     
       list =new ArrayList
      
       ();	for(int i=1;i<=3;i++){		User user=new User();		user.setId(i);		user.setAge(i);		user.setName("update"+i);		list.add(user);	}	int result = userService.batchUpdate(list);	log.info("result:" + result);}	@Testpublic void batchDelete() {	List
       
         list =new ArrayList
        
         (); for(int i=1;i<=3;i++){ list.add(i); } int result = userService.batchDelete(list); log.info("result:" + result);}
        
       
      
     
    
   

转载地址：http://gpsjn.baihongyu.com/