用Tomcat实现类实现链接池

来源：互联网发布：norsecorp源码编辑：程序博客网时间：2024/06/05 11:38

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();
  }

}
}