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.executeBatch(); } } pstmt.executeBatch(); conn.commit(); } catch(Exception e) { conn.rollback(); } finally { conn.setAutocommit(true); }