数据源DBAccess04

/*
* 获取数据库connect的方法
*
* @return Connection
*/
public static Connection getConnection()
{
Connection conn = null;
String DbType = FileManager.getESBProperty("DbType");
if ("DataSource".equals(DbType))
{
String strDataSource = FileManager.getESBProperty("DataSource");
if ((strDataSource == null) || "".equals(strDataSource))
{
logger.warn("The datasoruce hasn't configure, use default datasource["
+ defaultDataSource + "].");
strDataSource = defaultDataSource;
}
Hashtable<Object, Object> ht = new Hashtable<Object, Object>();
DataSource ds;
try
{
// weblogic??websphere??????
InitialContext ic = new InitialContext(ht);
ds = (DataSource) ic.lookup(strDataSource);
conn = ds.getConnection();
}
catch (NamingException ne)
{
try
{
// tomcat??????
InitialContext ic = new InitialContext(ht);
ds = (DataSource) ic.lookup("java:comp/env/jdbc/"
+ strDataSource);
conn = ds.getConnection();
}
catch (NamingException e)
{
e.printStackTrace();
logger.error("Cannot connect to DataSource["
+ strDataSource + "], Message:" + e.getMessage());
throw new BaseException(e);
}
catch (SQLException se)
{
logger.error("Cannot connect to DataSource["
+ strDataSource + "], Message:" + se.getMessage());
throw new BaseException(se);
}
}
catch (SQLException se)
{
logger.error("Cannot connect to DataSource[" + strDataSource
+ "], Message:" + se.getMessage());
throw new BaseException(se);
}
catch (Throwable e)
{
logger.warn("Using JDBC Connection begin...");
conn = getJDBCConnection();
logger.warn("Using JDBC Connection successful.");
}
}
else
{
conn = getJDBCConnection();
}
return conn;
}

public static Connection getJDBCConnection()
{
String dbURL = FileManager.getESBProperty("defaultdb.url");
String dbUser = FileManager.getESBProperty("defaultdb.username");
String dbPwd = FileManager.getESBProperty("defaultdb.password");
Connection con = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(dbURL, dbUser, dbPwd);
}
catch (Exception e)
{
logger.error("Cannot connect to Database, dbURL[" + dbURL
+ "], dbUser[" + dbUser + "], dbPwd[" + dbPwd
+ "], Message:" + e.getMessage());
throw new BaseException(e);
}
return con;
}
}