1.将jdbc操作改成批处理 addBatch(); //添加批处理
2.使用PreparedStatement
代码:
eg:
- Connection conn = DBUtils.getInstance().getConnetion();
-
- conn.setAutoCommit(false );
-
- PreparedStatement pstmt = null;
-
- try
-
- pstmt = conn.preparedStatement("insert into test1(a,b) vlaues (?,?)");
-
- pstmt.clearBatch();
-
- for(int i = 0; i<100000;i++){
-
- pstmt.setInt(1,i);
-
- pstmt.setString(2,"value"+i);
-
- pstmt.addBatch();
-
- if(i % 10000){
-
- pstmt.executbeBatch();
-
- }
-
-
-
- }
-
-
-
-
-
- pstmt.executeBatch();
-
-
-
- conn.commit();
-
- } catch(Exception e) {
-
- conn.rollback();
-
- } finally {
-
- conn.setAutocommit(true);
-
- }