java创建数据库连接

来源：互联网发布：东方网络2017分红编辑：程序博客网时间：2024/05/22 16:43

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