資源簡介
這是一個Web版本的數據庫連接工具,使用Java+Angular開發,

代碼片段和文件信息
package?com.tntxia.dbconn;
import?java.util.HashMap;
import?java.util.Map;
import?javax.naming.Context;
import?javax.naming.InitialContext;
import?javax.sql.DataSource;
import?com.tntxia.dbmanager.DBManager;
import?com.tntxia.dbmanager.datasource.DefaultDataSource;
import?com.tntxia.web.util.DatasourceStore;
public?class?RegisterPool?{
private?static?DBManager?dbManager?=?new?DBManager(DatasourceStore.getDatasource(“default“));
private?static?Map?pool?=?new?HashMap();
//?當前連接的ID
public?static?String?currentConnId;
public?static?void?register(String?key)?throws?Exception{
currentConnId?=?key;
DataSource?dataSource?=?pool.get(key);
if(dataSource!=null){
return;
}
String?sql?=?“select?*?from?connect_info?where?id?=?“;
Mapject>?map?=?dbManager.queryForMap(sql?new?object[]{key}true);
if(map==null){
throw?new?Exception(“連接不存在!!“);
}
String?db_type?=?(String)?map.get(“db_type“);
String?url?=?(String)?map.get(“url“);
if(“jndi“.equals(db_type)){
DataSource?ds=null;
try
????{
????????//?初始化查找命名空間
????????Context?ctx?=?new?InitialContext();
????????//?找到DataSource
????????ds?=?(DataSource)ctx.lookup(url);
???????
????}
????catch(Exception?e)
????{
????????System.out.println(e);
????}
pool.put(key?ds);
}else{
String?driver?=?(String)?map.get(“driver“);
String?username?=?(String)?map.get(“username“);
String?password?=?(String)?map.get(“password“);
DefaultDataSource?defaultdataSource?=?new?DefaultDataSource();
defaultdataSource.setDriverClassName(driver);
defaultdataSource.setUrl(url);
defaultdataSource.setUsername(username);
defaultdataSource.setPassword(password);
pool.put(key?defaultdataSource);
}
}
public?static?DataSource?getCurrentDataSource(){
return?pool.get(currentConnId);
}
public?static?DataSource?getDataSource(String?connid)?throws?Exception{
DataSource?res?=?pool.get(connid);
if(res==null){
register(connid);
res?=?pool.get(connid);
}
return?res;
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-01-15?11:54??DBConnector\
?????文件????????2469??2017-04-02?12:58??DBConnector\.classpath
?????文件????????1044??2016-08-06?00:34??DBConnector\.project
?????目錄???????????0??2017-01-14?23:07??DBConnector\.settings\
?????文件?????????503??2016-08-06?00:34??DBConnector\.settings\.jsdtscope
?????文件?????????187??2017-04-03?03:37??DBConnector\.settings\org.eclipse.core.resources.prefs
?????文件?????????670??2017-04-02?12:58??DBConnector\.settings\org.eclipse.jdt.core.prefs
?????文件?????????461??2016-08-06?00:34??DBConnector\.settings\org.eclipse.wst.common.component
?????文件?????????305??2017-04-02?12:55??DBConnector\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2016-08-06?00:34??DBConnector\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-08-06?00:34??DBConnector\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-01-15?11:54??DBConnector\build\
?????文件??????????36??2017-05-21?20:41??DBConnector\build.properties
?????文件????????1338??2016-08-06?12:42??DBConnector\build.xm
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\
?????文件????????4072??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\DBConnectorAction.class
?????文件????????3263??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\ExecuteAction.class
?????文件????????1875??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\FileChooseAction.class
?????文件?????????872??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\HistoryAction.class
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\mvc\
?????文件????????1616??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\mvc\IndexAction.class
?????文件????????1891??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\action\RegisterAction.class
?????目錄???????????0??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\bean\
?????文件?????????942??2017-08-12?12:27??DBConnector\build\classes\com\tntxia\dbconn\bean\FileBean.class
?????文件????????3026??2017-08-14?19:22??DBConnector\build\classes\com\tntxia\dbconn\RegisterPool.class
?????文件??????????82??2016-06-07?21:28??DBConnector\build\classes\jdbc.properties
?????文件?????????328??2016-06-06?20:59??DBConnector\build\classes\log4j.properties
............此處省略97個文件信息
評論
共有 條評論