Java批量插入数据

1. public void insertRecordTableq(List<Object[]> obs){  
2.         if(null != obs && !obs.isEmpty()){  
3.             String insertSql = "insert into product_check_company(id_uuid,column_name,oms,product,remark) values ";  
4.             StringBuffer sql = new StringBuffer();  
5.   
6.               
7.             for(int i = 0; i < obs.size(); i++){  
8.                 sql.append("("+obs.get(i)[0]);  
9.                 sql.append(",");  
10.                 sql.append(obs.get(i)[1]);  
11.                 sql.append(",");  
12.                 sql.append(obs.get(i)[2]);  
13.                 sql.append(",");  
14.                 sql.append(obs.get(i)[3]);  
15.                 sql.append(",");  
16.                 sql.append(obs.get(i)[4]);  
17.                 sql.append("),\n");  
18.             }  
19.               
20.             JdbcTemplate.update(insertSql+sql.toString().substring(0, sql.length() - 2));  
21.         }  
22.     }  

SQL格式：insert into product_check_company(id_uuid,column_name,oms,product,remark) values (0,1,2,3,4),
(1,2,3,4,5),
(2,3,4,5,6),
(3,4,5,6,7)

效率比JdbcTemplate.batchUpdate高，一万条数据1秒内可完成。

此语句在MySQL 5， postgreSQL 9.3执行通过。