JdbcUtil.java

package org.cneng.pool.c3p0;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.sql.Connection;

/**
 * Created with IntelliJ IDEA.
 * User: Administrator
 * Date: 12-7-11
 * Time: 上午10:20
 * JdbcUtil
 */
public class JdbcUtil {

    private static Logger log = LoggerFactory.getLogger(JdbcUtil.class);
    private static ComboPooledDataSource originDataSource;
    private static ComboPooledDataSource targetDataSource;
    private static ComboPooledDataSource dataSource;

    public static ComboPooledDataSource initDataSoucePool() {
        if (dataSource == null) {
            log.info("The first time to init origin pool");
            dataSource = new ComboPooledDataSource("dataSource");
        }
        return dataSource;
    }

    public static ComboPooledDataSource getOriginDataSoucePool() {
        if (originDataSource == null) {
            log.info("The first time to init origin pool");
            originDataSource = new ComboPooledDataSource("originPool");
        }
        return originDataSource;
    }

    public static ComboPooledDataSource getTargetDataSourcePool() {
        if (targetDataSource == null) {
            log.info("The first time to init target pool");
            targetDataSource = new ComboPooledDataSource("targetPool");
        }
        return targetDataSource;
    }

    /**
     * 获取数据库连接
     *
     * @return 数据库连接
     * @throws Exception
     */
    public static Connection getConnection() throws Exception {
        return dataSource.getConnection();
    }

    /**
     * 关闭数据库连接池
     *
     * @throws Exception
     */
    public static void closeDataSource() throws Exception {
        dataSource.close();
    }
}