java创建数据库连接

最新推荐文章于 2024-06-13 18:13:02 发布

欣怡

最新推荐文章于 2024-06-13 18:13:02 发布

阅读量2.6k

点赞数 1

分类专栏： JAVA

本文链接：https://blog.csdn.net/niuch1029291561/article/details/8446829

版权

JAVA 专栏收录该内容

41 篇文章 2 订阅

订阅专栏

public static Connection getConnection() throws Exception {
  int count = 0;
  Connection con = null;
  while (count < DBUTIL_PARAM_RECONNECT_TIMES) {
   try {
    /*
    String connUrl = SysInfoReader.instance().getServiceParam("db_pool", BaseConstant.DEFAULT_DATABASE, "poolurl");
    String dbDrv = SysInfoReader.instance().getServiceParam("db_pool", BaseConstant.DEFAULT_DATABASE, "driver");
    String dbLogin = SysInfoReader.instance().getServiceParam("db_pool", BaseConstant.DEFAULT_DATABASE, "login");
    String dbPw = SysInfoReader.instance().getServiceParam("db_pool", BaseConstant.DEFAULT_DATABASE, "password");
    */
    String propertiespath="../classes/resource/jdbc-config/jdbc.properties";
    String connUrl = getPropertiesValue(propertiespath,BaseConstant.DEFAULT_DATABASE+".url");
    String dbDrv   = getPropertiesValue(propertiespath,BaseConstant.DEFAULT_DATABASE+".driver");
    String dbLogin = getPropertiesValue(propertiespath,BaseConstant.DEFAULT_DATABASE+".username");
    String dbPw    = getPropertiesValue(propertiespath,BaseConstant.DEFAULT_DATABASE+".password");

    Class.forName(dbDrv);
    DriverManager.setLoginTimeout(DBUTIL_PARAM_LOGINTIMEOUT_SECONDS);
    con = DriverManager.getConnection(connUrl, dbLogin, dbPw);
   } catch (Exception e) {
    e.printStackTrace();
   }
   if (con == null) {
    Logger.debug("[DBUtil]*******************DBUtil获取默认数据库连接"+ DBUTIL_PARAM_LOGINTIMEOUT_SECONDS + "秒超时,重连次数count="+ count);
    Thread.sleep(2000);
    count++;
   } else
    break;
  }
  return con;
}