package cn.zno.jdbc.dbcp;

import java.sql.Connection;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.apache.commons.dbcp2.BasicDataSource;

//

// To compile this example, you'll want:

//  * commons-pool-2.3.jar

//  * commons-dbcp-2.1.jar

// in your classpath.

//

// To run this example, you'll want:

//  * commons-pool-2.3.jar

//  * commons-dbcp-2.1.jar

//  * commons-logging-1.2.jar

// in your classpath.

//

public class DbcpTool {

    @SuppressWarnings("unused")

    public static void main(String[] args) throws SQLException {

        DataSource dataSource = setupDataSource();

        Connection conn1 = dataSource.getConnection();

        printDataSourceStats(dataSource);// 活跃1 空闲0 |新建1个

        conn1.close();

        printDataSourceStats(dataSource);// 活跃0 空闲1 |

        Connection conn2 = dataSource.getConnection();

        printDataSourceStats(dataSource);// 活跃1 空闲0 |使用之前的

        Connection conn3 = dataSource.getConnection();

        printDataSourceStats(dataSource);// 活跃2 空闲0 |新建第2个

        conn2.close();

        printDataSourceStats(dataSource);// 活跃1 空闲1 |

        conn3.close();

        printDataSourceStats(dataSource);// 活跃0 空闲2 |

    }

    public static DataSource setupDataSource() {

        BasicDataSource ds = new BasicDataSource();

        ds.setDriverClassName("oracle.jdbc.OracleDriver");

        ds.setUrl("jdbc:oracle:thin:@//172.16.50.67:1521/orcl");

        ds.setUsername("e_channel");

        ds.setPassword("e_channel_test");

        ds.setInitialSize(0);

        ds.setMaxTotal(3);

        ds.setMaxIdle(3);

        ds.setMinIdle(1);

        ds.setMaxWaitMillis(10000);

        System.out.println("MaxTotal: " + ds.getMaxTotal());

        System.out.println("MaxIdle: " + ds.getMaxIdle());

        System.out.println("MinIdle: " + ds.getMinIdle());

        System.out.println("MaxWaitMillis: " + ds.getMaxWaitMillis());

        System.out.println("set up done.\n");

        return ds;

    }

    public static void printDataSourceStats(DataSource ds) {

        BasicDataSource bds = (BasicDataSource) ds;

        System.out.println("NumActive: " + bds.getNumActive());

        System.out.println("NumIdle: " + bds.getNumIdle());

        System.out.println();

    }

    public static void shutdownDataSource(DataSource ds) throws SQLException {

        BasicDataSource bds = (BasicDataSource) ds;

        bds.close();

    }

}