我自己的数据对象处理类 DBConnection-优快云博客

本文介绍了一个Java项目中实现的数据库连接池管理类，通过使用c3p0库来创建和管理MySQL数据库连接。该类提供了获取连接、关闭连接等基本功能，并针对不同数据库配置了特定的数据源。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

package com.jh.core.db.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.sql.DataSource;

import com.jh.app.util.Globle;
import com.mchange.v2.c3p0.DataSources;

public class DBConnection {
private static Map<String ,DataSource> dsMap=new HashMap<String ,DataSource>();;

    synchronized static public DataSource dataSource(String dbName) {
  if (dsMap.get(dbName) == null)
   try {
    if(Globle.CMS_DB.equals(dbName)){
    Class.forName("com.mysql.jdbc.Driver");
    String url="jdbc:mysql://192.168.3.41:3306/"+dbName+"?useUnicode=true&characterEncoding=GBK";;
    System.out.println("url="+url);
    DataSource unpooled = DataSources.unpooledDataSource(url,"root", "123456");
    DataSource ds = DataSources.pooledDataSource(unpooled);
    dsMap.put(dbName, ds);
    }else if(Globle.TAG_DB.equals(dbName)){
     Class.forName("com.mysql.jdbc.Driver");
     String url="jdbc:mysql://192.168.3.53:3306/"+dbName+"?useUnicode=true&characterEncoding=GBK";;
     System.out.println("url="+url);
     DataSource unpooled = DataSources.unpooledDataSource(url,"root", "");
     DataSource ds = DataSources.pooledDataSource(unpooled);
     dsMap.put(dbName, ds);
    }else{
     Class.forName("com.mysql.jdbc.Driver");
     String url="jdbc:mysql://192.168.3.94:3306/"+dbName+"?useUnicode=true&characterEncoding=GBK";;
     System.out.println("url="+url);
     DataSource unpooled = DataSources.unpooledDataSource(url,"root", "123456");
     DataSource ds = DataSources.pooledDataSource(unpooled);
     dsMap.put(dbName, ds);
    }
   } catch (Exception e) {
    e.printStackTrace();
   }
  return dsMap.get(dbName);
}

// base close connection.
public static void closeDBConnection(Connection conn) {
  try {

   if (conn != null) {
    conn.close();
    conn = null;
   }
  } catch (Exception e) {
   // 标签
   e.printStackTrace();
  }

}

public static void closeDBPrepared(PreparedStatement ps) {
  try {
   if (ps != null) {
    ps.close();
    ps = null;
   }
  } catch (Exception e) {
   e.printStackTrace();
  }

}

public static Connection getDBConnection(String dbName) {
  Connection conn = null;
  DataSource ds = dataSource(dbName);
  try {
   conn = ds.getConnection();
  } catch (SQLException e) {
  }
  //logger.debug("返回数据库链接:" + conn);
  return conn;
}
public static void main(String args[]) throws Exception{
long time=System.currentTimeMillis();
  System.out.println(getDBConnection("TagDB"));
  System.out.println(System.currentTimeMillis()-time);

}
}