我的代码:
conn.setAutoCommit(false);
for(int i = 0;i < list.size(); i++){
number = (String)list.get(i);
sb.append("insert ....('"+number+"')");
ps.addBatch();
count++;
if(count % 1000 == 0){
ps.executeBatch();
conn.commit();
conn.setAutoCommit(true);
}
}
大概的写勒下,我每次只能插入1条。 list里有5000多数据
conn.setAutoCommit(false);
for(int i = 0;i < list.size(); i++){
number = (String)list.get(i);
sb.append("insert ....('"+number+"')");
ps.addBatch();
count++;
if(count % 1000 == 0){
ps.executeBatch();
conn.commit();
conn.setAutoCommit(true);
}
}
大概的写勒下,我每次只能插入1条。 list里有5000多数据