package com;
import javax.sql.DataSource;//连接池
import java.sql.*;
import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
//tomcat中连接池的实现类
public class Test {
public static void main(String[] args) {
/*
try {
long T1=System.currentTimeMillis();
Class.forName("oracle.jdbc.driver.OracleDriver");
for(int i = 0;i<1000;i++){
Connection cn = DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:orcl","scott","tiger");
cn.close();
}
long T2=System.currentTimeMillis();
System.out.println(T2-T1);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
*/
BasicDataSource source = new BasicDataSource();
source.setDriverClassName("oracle.jdbc.driver.OracleDriver");
source.setUrl("jdbc:oracle:thin:@localhost:1521:orcl");
source.setUsername("scott");
source.setPassword("tiger");
source.setMaxActive(300);//最大连接数量
try {
long T1=System.currentTimeMillis();
for(int i = 0;i<1000;i++){
Connection cn = source.getConnection();
cn.close();
}
long T2=System.currentTimeMillis();
System.out.println(T2-T1);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}