给JDBC添加数据源

package day03;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.Random;
import org.apache.commons.dbcp.BasicDataSource;
import tarena.util.DBUtil;

public class JDBCTest3 {
	public static void main(String[] args) throws Exception {
		test3();
	}
	static void test3() throws Exception {
		// DBCP API
		BasicDataSource ds = 
			new BasicDataSource();
		ds.setUrl("jdbc:oracle:thin:@192.168.0.26:1521:tarena");
		ds.setDriverClassName("oracle.jdbc.OracleDriver");
		ds.setUsername("sd1005");
		ds.setPassword("sd1005");		
		ds.setInitialSize(3);
		ds.setMaxActive(10);
		ds.setMaxIdle(3);
		ds.setMaxWait(5000);
		ds.setMaxOpenPreparedStatements(10);	
		// 测试sql select sysdate from dual
		// 最大连接时间
		ds.setDefaultAutoCommit(false);
		Connection con = ds.getConnection();
		System.out.println(con.getClass()); 
		con.close(); // 不断开，而是归还连接池
		long l = System.currentTimeMillis();
		for(int i=0;i<1000;i++) {
			ds.getConnection().close();
		}
		System.out.println(
				System.currentTimeMillis()-l );
	}

	static void test2() throws Exception {
		long l = System.currentTimeMillis();
		//for(int i=0;i<10;i++) {
			DBUtil.close(DBUtil.open(), null,null);
		//}
		System.out.println(
				System.currentTimeMillis()-l );
	}
	static void test1(File file) throws Exception {
		Connection con = null;
		PreparedStatement pstmt = null;
		try {
			con = DBUtil.openInThread();
			pstmt = con.prepareStatement(
					" insert into "+
					" gallery(id, pic) " +
					" values(?,?)");
			pstmt.setInt(1, 
					new Random(99999999).nextInt());
			// oracle jdbc 10
			pstmt.setBinaryStream(2, new FileInputStream(file));
			pstmt.executeUpdate();
		} finally {
			DBUtil.closeInThread();
		}
	}
}