配置dbcp数据库连接池代码,Java代码库,德仔网

代码语言

代码分类

【Java】配置dbcp数据库连接池

作者:阿信sxq / 发布于2013/12/26/ 448

使用jar包：commons-dbcp-1.4.jar、commons-pool-1.6.jar、commons-logging-1.1.3.jar，另外还有数据库的jdbc驱动，适用java6及以上平台，

public class DBManager {
 private static final Log log = LogFactory.getLog(DBManager.class);
 private static final String configFile = "dbcp.properties";

 private static DataSource dataSource;

 static {
  Properties dbProperties = new Properties();
  try {
   dbProperties.load(DBManager.class.getClassLoader()
     .getResourceAsStream(configFile));
   dataSource = (DataSource) BasicDataSourceFactory
     .createDataSource(dbProperties);
   
   Connection conn = getConn();
   DatabaseMetaData mdm = conn.getMetaData();
   log.info("Connected to " + mdm.getDatabaseProductName() + " "
     + mdm.getDatabaseProductVersion());
   if (conn != null) {
    conn.close();
   }
  } catch (Exception e) {
   log.error("初始化连接池失败：" + e);
  }
 }

 private DBManager() {
 }

 public static final void closeDataSource() {
  try {
   dataSource.getClass().getMethod("close").invoke(dataSource);
  } catch (Exception e) {
   log.error("断开连接池失败：" + e);
  }
 }

 public static final Connection getConn() {
  Connection conn = null;
  try {
   conn = dataSource.getConnection();
  } catch (SQLException e) {
   log.error("获取数据库连接失败：" + e);
  }
  return conn;
 }

 public static void closeConn(Connection conn) {
  try {
   if (conn != null && !conn.isClosed()) {
    conn.setAutoCommit(true);
    conn.close();
   }
  } catch (SQLException e) {
   log.error("关闭数据库连接失败：" + e);
  }
 }

}

试试其它关键字

　连接池　

同语言下

可能有用的

阿信sxq贡献的其它代码(2)