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 ,