TB源码分析：ConnectionManager

package com.terac.board;

import org.apache.commons.dbcp.ConnectionFactory;

import org.apache.commons.dbcp.DriverManagerConnectionFactory;

import org.apache.commons.dbcp.PoolableConnectionFactory;

import org.apache.commons.dbcp.PoolingDataSource;

import org.apache.commons.pool.ObjectPool;

import org.apache.commons.pool.impl.GenericObjectPool;

import javax.sql.DataSource;

import java.sql.SQLException;

public class ConnectionManager {

private final static ConnectionManager instance = new ConnectionManager();

private DataSource ds;

public static ConnectionManager getInstance() {

return instance;

}

private ConnectionManager() {

try {

//setupDriver();

this.ds = setupDataSource();

} catch (Exception e) {

//

}

}

public static DataSource setupDataSource() {

try {

Class.forName(Config.getInstance().getDatabaseDriver());

} catch (ClassNotFoundException e) {

//

}

ObjectPool connectionPool = new GenericObjectPool();

ConnectionFactory connectionFactory = new DriverManagerConnectionFactory(

Config.getInstance().getDatabaseUrl()

, Config.getInstance().getDatabaseUser()

, Config.getInstance().getDatabasePassword());

PoolableConnectionFactory poolableConnectionFactory = new PoolableConnectionFactory(connectionFactory, connectionPool, null, null, false, true);

PoolingDataSource dataSource = new PoolingDataSource(connectionPool);

return dataSource;

}

public DataSource getDataSource() throws SQLException {

return ds;

}

}