Java

本类阅读TOP10

·使用MyEclipse开发Struts框架的Hello World!(录像1)
·hibernate配置笔记
·AOP编程入门--Java篇
·linux下Tomcat 5.0.20 与 Apache 2 安装/集成/配置
·在win2003下整合了整合Tomcat5.5+ apache_2.0.53+ mod_jk_2.0.47.dll
·构建Linux下IDE环境--Eclipse篇
·Jsp 连接 mySQL、Oracle 数据库备忘(Windows平台)
·ASP、JSP、PHP 三种技术比较
·Tomcat5.5.9的安装配置
·AWT GUI 设计笔记(二)

分类导航
VC语言Delphi
VB语言ASP
PerlJava
Script数据库
其他语言游戏开发
文件格式网站制作
软件工程.NET开发
TB源码分析:ConnectionManager

作者:未知 来源:月光软件站 加入时间:2005-2-28 月光软件站

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;
}
}




相关文章

相关软件