老翟

package cc.apl330;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import cc.apl330.dao.UserDAOException;


//注意批處理在實(shí)際中應(yīng)用要注意同時(shí)打包太多的處理會(huì)引起內(nèi)存溢出.
public class BatchTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		long start = System.currentTimeMillis() ;
		//常規(guī)方式提交處理
		for(int i=0; i<200; i++){
			create(i) ;
		}
		long end = System.currentTimeMillis() ;
		System.out.println("crate:" + (end - start)) ;
		
		//成批提交處理
		start = System.currentTimeMillis() ;
		create1() ;
		end = System.currentTimeMillis() ;
		System.out.println("Batchcrate:" + (end - start)) ;

	}
	
	//常規(guī)方式提交處理
	static void create(int i){
		String sql = "INSERT INTO USER(name,money) VALUES(?,?);";
		Connection conn;
		PreparedStatement ps;
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql) ;
			ps.setString(1, "name"+i) ;
			ps.setFloat(2, 200f+i) ;
			ps.executeUpdate();
			JdbcUtil.free(null, ps, conn) ;
		} catch (SQLException e) {
			throw new UserDAOException(e.getMessage(),e) ;
		}
	}
	
	//成批提交處理
	static void create1(){
		String sql = "INSERT INTO USER(name,money) VALUES(?,?);";
		Connection conn;
		PreparedStatement ps;
		try {
			conn = JdbcUtil.getConnection();
			ps = conn.prepareStatement(sql) ;
			for(int i=200; i<400; i++){
				ps.setString(1, "name"+i) ;
				ps.setFloat(2, 200f+i) ;
				ps.addBatch();//將處理打包
			}
			//執(zhí)行批處理
			int[] is = ps.executeBatch() ;
			System.out.println(is.length+"") ;
			JdbcUtil.free(null, ps, conn) ;
		} catch (SQLException e) {
			throw new UserDAOException(e.getMessage(),e) ;
		}
	}
}