代码如下,不考虑多个连接释放的问题,没用到连接池,现在就是一个连接:
DataManager db = new DataManager();
try{
Connection conn = db.getConnection();
Statement stmt = null;
String sql = "";
for(int i = 0;i<10000; i++) {
stmt = conn.createStatement();
sql = "insert into test (id) values('10000000 + " + i + "')";
stmt.execute(sql);
System.out.println("写到第 " + i + "条");
}
stmt.close();
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
DataManager db = new DataManager();
try{
Connection conn = db.getConnection();
Statement stmt = null;
String sql = "";
for(int i = 0;i<10000; i++) {
stmt = conn.createStatement();
sql = "insert into test (id) values('10000000 + " + i + "')";
stmt.execute(sql);
System.out.println("写到第 " + i + "条");
}
stmt.close();
conn.close();
}catch(Exception e) {
e.printStackTrace();
}
每次都是打开一个新的游标,其实一个statement就够了。
stmt = conn.createStatement();
sql = "insert into test (id) values('10000000 + " + i + "')";
stmt.execute(sql);连续插10000次啊?