批处理数据库(利用batch插入2w条数据)
public class Demo02Batch { /* * 批处理 */ public static void main(String[] args) { Connection conn=null; Statement stmt=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql:///little", "root", "root"); conn.setAutoCommit(false);//设置自动提交关闭 stmt=conn.createStatement(); for(int i=0;i<20000;i++) { stmt.addBatch("insert into usr(username,password,regTime) values ('little"+i+"',111,now())"); } stmt.executeBatch(); conn.commit(); } catch (SQLException e) { e.printStackTrace(); }catch (ClassNotFoundException e) { e.printStackTrace(); }finally { try { if(stmt!=null) stmt.close(); if(conn!=null) conn.close(); } catch (SQLException e2) { e2.printStackTrace(); } } } }