code: public int[] execute(Iterable<String> sqls, int batchSize) throws SQLException {
  		if (sqls == null) {
  			return null;
  		}
  		
  		List<int[]> tmpResultList = new ArrayList<int[]>();
  		
  		Statement stmt = null;
  		try {
  			int counter = 0;
  			stmt = conn.createStatement();
  			for (String sql : sqls) {
  				stmt.addBatch(sql);
  				counter ++;
  				if (batchSize > 0 && counter % batchSize == 0) {
  					tmpResultList.add(stmt.executeBatch());
  				}
  			}
  			tmpResultList.add(stmt.executeBatch());
  
  		} catch (SQLException e) {
  			throw e;
  		} finally {
  			try {
  				if (stmt != null && stmt.isClosed() == false) {
  					stmt.close();
  				}
  			} catch (SQLException e) {
  				logger.error(e.getMessage());
  			}
  		}
  		
  		int[] result = new int[0];
  		for (int[] tmpResult : tmpResultList) {
  			int[] tmpArray = new int[result.length + tmpResult.length];
  			
  			System.arraycopy(result, 0, tmpArray, 0, result.length);
  			System.arraycopy(tmpResult, 0, tmpArray, result.length, tmpResult.length);
  			
  			result = tmpArray;
  		}
  
  		return result;
  	}
docs: 批量执行SQL语句
  
  @param sqls SQL语句集合
  @param batchSize 每批次执行数量
  
  @return 批量执行结果
  
  @throws SQLException SQL执行异常