当前位置:编程学习 > JAVA >>

java创建数据库连接

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;
 }
补充:软件开发 , Java ,
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,