lab14.java

jdbc 源代码

package com.jdbclab;
import java.sql.*;

public class Lab14
{
	public static void main(String[] args){
	  Connection con = null;
	  PreparedStatement ps = null;
	  String sql = 
		  "insert into t_sd0709_test "+
		  "values(?,'Jack')";
	  try{
	    con = JdbcUtil.getConnection();
		con.setAutoCommit(false);
		ps = con.prepareStatement(sql);
		System.out.println("开始");
		long m = (new java.util.Date()).getTime();
		for(int i=10001;i<20001;i++){
		  ps.setInt(1,i);
		  ps.addBatch();
		  if(i%10==0){
		    ps.executeBatch();
		  }
		}
		System.out.println("共用时:"
		     +((new java.util.Date()).getTime()-m)+
			 "毫秒");
		con.commit();
	  }catch(Exception e){
	    e.printStackTrace();
		if(con!=null){
		  try{con.rollback();}catch(Exception ex){ex.printStackTrace();}
		}
	  }finally{
	    JdbcUtil.release(null,ps,con);
	  }
	}
}