Packagecn. itcast. bath; importjava. SQL. connection; importjava. SQL. preparedStatement; importorg. junit. test; importcn. itcast. jdbc. JDBCUtils; publicclassBath {@ Testpublicvoiddemo1 () {Connectionconnnull; PreparedStatementstatnull; long... mysqljava jdbcsql data
Package cn. itcast. bath;
Import java. SQL. Connection;
Import java. SQL. PreparedStatement;
Import org. junit. Test;
Import cn. itcast. jdbc. JDBCUtils;
Public class Bath {
@ Testpublic void demo1 () {Connection conn = null; PreparedStatement stat = null; long start = System. currentTimeMillis (); try {conn = JDBCUtils. getConnection (); String SQL = "insert into person values (?,?,?) "; Stat = conn. prepareStatement (SQL); for (int I = 1; I <= 50000; I ++) {stat. setInt (1, I); stat. setString (2, "name" + I); stat. setString (3, "email" + I); stat. addBatch (); if (I % 1000 = 0) {stat.exe cuteBatch (); stat. clearBatch () ;}} catch (Exception e) {e. printStackTrace ();} finally {long end = System. currentTimeMillis (); System. out. println ("Execution time:" + (end-start); JDBCUtils. release (stat, conn );}}
}