jdbc线程池

连接oracle数据库的jdbc线程池

首先建立一个properties类型的文件存放一些信息：jdbc.properties

driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc\:oracle\:thin\:@localhost\:1521\:orcl
username=teacher
password=ok
initialSize=1
maxActive=50
#maxIdle=8
#minIdle=1
maxWait=6000

此处建立一个工具类，专门为了建立连接，关闭连接，代码如下：

package com.dao;

import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

public class JdbcUtil {
    private static DataSource ds;
    static{
        Properties p = new Properties();
        try {
                        //此处jdbc.properties文件使用的是绝对路径
            p.load(new FileInputStream("E:\\甲骨文软件\\eclipse-jee-kepler-SR2-win32-x86_64\\WebWorkspace\\ServletTest\\src\\jdbc.properties"));
            ds=BasicDataSourceFactory.createDataSource(p);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
    }
    public static Connection getConnection(){
        Connection conn=null;
        try {
            conn=ds.getConnection();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
    public static void CloseConnection (Connection conn){
        if(conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
}