首页 > 文章 > java JDBC-批处理Batch-事务

java JDBC-批处理Batch-事务

public class Demo5 { public static void main(String[] args) { Statement stmt=null; Connection conn=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","dyl123"); //设为手动提交 conn.setAutoCommit(false); stmt=conn.createStatement(); for(int i=0;i<20000;i++) { stmt.addBatch("insert into t_user(username,pwd,regTime) values(‘米"+i+"‘,555,now())"); } stmt.executeBatch(); conn.commit(); //提交事务 } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally { try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
时间:2019-10-10 04:10:22阅读(43)
联系我们 - 留言反馈
© 2017 版权所有 鲁ICP备17052893号