第一：修改數(shù)據(jù)庫(kù)的連接方式 &&allowMultiQueries=true

比如：jdbc/:MySQL/://rdshme0env6yf2n829ympublic.mysql.rds.aliyuncs.com/wlsq_dev_test?useUnicode/=true&characterEncoding/=utf8&allowMultiQueries=true

mybatis 配置文件：

   <!--批量修改密碼  -->   <update id="updateBatch" parameterType="java.util.List">              <foreach collection="list" item="item" index="index" open="" close="" separator=";">				update account set `passWord` = #{item.password} where acct_id = #{item.acctId}					       </foreach>   </update>  
dao 層
  public void updateBatch(List<Account> list);
service 層
  public void updateBatch(List<Account> list);service 實(shí)現(xiàn)層
	public void updateBatch(List<Account> list) {		// TODO Auto-generated method stub		this.accountMapper.updateBatch(list);	}
controller 層
 @RequestMapping({"/batchupdate"})  @ResponseBody  public String batchUpdate(){	  String result = "";	  try{	  List<Account> list = accountService.batchUpdate();	  List<Account> batch = new ArrayList<Account>();	  	 	  //密碼修改	  if(list !=null && list.size()>0){		  for(int i=0;i<list.size();i++){			  Account account =list.get(i);			  String oldpassword = account.getPassword();			  account.setPassword(EncryptUtils.encodeBase64String(oldpassword));			  batch.add(account);		  }	  }	  //一次處理數(shù)據(jù)量	  int  init = 1000;// 每隔1000條循環(huán)一次  =1000;	  //總數(shù)	  int nums = batch.size();	  //批次數(shù)	  int batchnum = nums / init;  	  if (nums % init != 0) {  		  batchnum += 1;            if (nums < init) {                init = list.size();            }        } 	  	   for (int i = 0; i < batchnum; i++) {             System.out.PRintln("------" + i + "保存"+init+"條數(shù)據(jù)到數(shù)據(jù)庫(kù)....");             List<Account> a = new ArrayList<Account>();           if (i == batchnum - 1) {                 int size = (i + 1) * init;                 for (int j = size - init; j < nums; j++) {              	   if (batch.get(j) == null) {                         break;                     }             	   a.add(batch.get(j));                 }                           } else {                 int size = (i + 1) * init;                 for (int j = size - init; j < size; j++) {             	   if (batch.get(j) == null) {                         break;                     }              	   a.add(batch.get(j));                 }                          }             accountService.updateBatch(a);                 }  	  	 		  	  }catch(Exception e){		  System.out.println(e.getMessage());		  return "false";	  }	  result = "true";	  return result;	    }結(jié)果展示：