作者:月夜清风XL | 来源:互联网 | 2018-04-25 19:10
packagecn.itcast.bath;importjava.sql.Connection;importjava.sql.PreparedStatement;importorg.junit.Test;importcn.itcast.jdbc.JDBCUtils;publicclassBath{@Testpublicvoiddemo1(){Connectionconnnull;PreparedStatementstatnull;long...
mysqljava jdbcsql数据
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.executeBatch(); stat.clearBatch(); } } } catch (Exception e) { e.printStackTrace(); }finally{ long end = System.currentTimeMillis(); System.out.println("执行时间:"+(end-start)); JDBCUtils.release(stat, conn); }}
}