Durid数据库连接池配置(不使用框架)

本人没有使用任何框架，就是纯JAVA的方式

1、下载Durid包(druid-0.2.23.jar)

百度网盘：https://pan.baidu.com/s/1q8LsG_Hv1PosCRwOXOiebw

密码：b3cw

2、web.xml配置

<filter>
	<filter-name>DruidWebStatFilter</filter-name>
	<filter-class>com.alibaba.druid.support.http.WebStatFilter</filter-class>
	<init-param>
		<param-name>exclusions</param-name>
		<param-value>*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*</param-value>
	</init-param>
</filter>
<filter-mapping>
	<filter-name>DruidWebStatFilter</filter-name>
	<url-pattern>/*</url-pattern>
</filter-mapping>

<servlet>
	<servlet-name>DruidStatView</servlet-name>
	<servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class>
</servlet>
<servlet-mapping>
	<servlet-name>DruidStatView</servlet-name>
	<url-pattern>/druid/*</url-pattern>
</servlet-mapping>

3、工具类DbPoolConnection(获取connection对象)

package com.richinfo.dao.base;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
import java.util.Properties;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.alibaba.druid.pool.DruidPooledConnection;

public class DbPoolConnection {
    private static DbPoolConnection databasePool = null;
    private static DruidDataSource dds = null;
    static {
        Properties properties = loadPropertyFile("durid.properties");
        try {
            dds = (DruidDataSource) DruidDataSourceFactory
                    .createDataSource(properties);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
    private DbPoolConnection() {}
    public static synchronized DbPoolConnection getInstance() {
        if (null == databasePool) {
            databasePool = new DbPoolConnection();
        }
        return databasePool;
    }
    public DruidPooledConnection getConnection() throws SQLException {
        return dds.getConnection();
    }
    public static Properties loadPropertyFile(String fullFile) {
        String webRootPath = null;
        if (null == fullFile || fullFile.equals(""))
            throw new IllegalArgumentException(
                    "Properties file path can not be null : " + fullFile);
        webRootPath = DbPoolConnection.class.getClassLoader().getResource("")
                .getPath();
        webRootPath = new File(webRootPath).getParent();
        InputStream inputStream = null;
        Properties p = null;
        try {
            inputStream = new FileInputStream(new File(webRootPath
                    + File.separator + fullFile));
            p = new Properties();
            p.load(inputStream);
        } catch (FileNotFoundException e) {
            throw new IllegalArgumentException("Properties file not found: "
                    + fullFile);
        } catch (IOException e) {
            throw new IllegalArgumentException(
                    "Properties file can not be loading: " + fullFile);
        } finally {
            try {
                if (inputStream != null)
                    inputStream.close();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
        return p;
    }
}

4、工具类(对外提供接口,关闭数据库连接)

package com.richinfo.dao.base;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.apache.logging.log4j.LogManager;
import org.apache.logging.log4j.Logger;

public class DBManager {
    private static Logger log = LogManager.getLogger(DBManager.class);

    /**
     * 默认的数据库链接，链接Oss139 统一位置 管理下的对象
     * 
     * @return Connection
     */
    public static Connection getConnection() {
        Connection conn = null;
        try {
             conn = DbPoolConnection.getInstance().getConnection();
        } catch (SQLException e) {
            e.printStackTrace();
            log.error("DBManager getConnection null.{}", e);
            return null;
        }
        return conn;
    }

    /**
     * 链接指定的 数据库对象
     * 
     * @param dataBaseName
     * 对象名
     * @return Connection
     */
    public static Connection getConnection(String dataBaseName) {

        try {
            Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            return null;
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        Connection conn = null;
        try {
            conn = DriverManager.getConnection("proxool." + dataBaseName);
        } catch (SQLException e) {
            e.printStackTrace();
            return null;
        }
        return conn;
    }

    public static void close(Connection conn, Statement st, ResultSet rs) {

        try {
            if (rs != null)
                rs.close();
        } catch (Exception e) {
            log.error("DBManager close fail rs. {}", e);
        }
        ;
        try {
            if (st != null)
                st.close();
        } catch (Exception e) {
            log.error("DBManager close fail st. {}", e);
        }
        ;
        try {
            if (conn != null)
                conn.close();
        } catch (Exception e) {
            log.error("DBManager close fail conn. {}", e);
        }
    }
}

5、配置文件durid.properties

driverClassName=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@192.168.9.73:1521:oss
username=upm
password=upm
filters=stat
initialSize=2
maxActive=300
maxWait=60000
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=select CURRENT_DATE FROM dual
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
poolPreparedStatements=false
maxPoolPreparedStatementPerConnectionSize=200