程序片段如下: public void test() { StopWatch sw = new StopWatch(); System.out.println("-----------------start---------------"); final List<String> list1 = new ArrayList<String>();
sw.start(); for (int i = 0; i < 2000; i++) { // list1.add("douzi"); // jdbcTemplate.execute(); } Connection con = null; // PreparedStatement ps = null; Statement st = null; try { con = jdbcTemplate.getDataSource().getConnection(); con.setAutoCommit(false); // ps = con.prepareStatement("insert into Aa(name) values('douzi')"); st = con.createStatement(); for (int i = 0; i < 100000; i++) { // ps.setString(1, "douzi" + i); // st.addBatch("insert into Aa(name) values('douzi')"); st.execute("insert into Aa(name) values('douzi')"); // ps.addBatch(); // if (i % 10000 == 0) { ps.executeBatch(); ps.clearBatch(); // st.executeBatch(); // st.clearBatch(); // con.commit(); // } } // ps.executeBatch(); st.executeBatch(); st.clearBatch(); con.commit(); con.setAutoCommit(true);