Web版的数据库管理工具

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.settingsorg.eclipse.core.resources.prefs
     文件         670  2017-04-02 12:58  DBConnector.settingsorg.eclipse.jdt.core.prefs
     文件         461  2016-08-06 00:34  DBConnector.settingsorg.eclipse.wst.common.component
     文件         305  2017-04-02 12:55  DBConnector.settingsorg.eclipse.wst.common.project.facet.core.xml
     文件          49  2016-08-06 00:34  DBConnector.settingsorg.eclipse.wst.jsdt.ui.superType.container
     文件           6  2016-08-06 00:34  DBConnector.settingsorg.eclipse.wst.jsdt.ui.superType.name
     目录           0  2017-01-15 11:54  DBConnectoruild
     文件          36  2017-05-21 20:41  DBConnectoruild.properties
     文件        1338  2016-08-06 12:42  DBConnectoruild.xml
     目录           0  2017-08-12 12:27  DBConnectoruildclasses
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom ntxia
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconn
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnaction
     文件        4072  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionDBConnectorAction.class
     文件        3263  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionExecuteAction.class
     文件        1875  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionFileChooseAction.class
     文件         872  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionHistoryAction.class
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionmvc
     文件        1616  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionmvcIndexAction.class
     文件        1891  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnactionRegisterAction.class
     目录           0  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconnean
     文件         942  2017-08-12 12:27  DBConnectoruildclassescom ntxiadbconneanFileBean.class
     文件        3026  2017-08-14 19:22  DBConnectoruildclassescom ntxiadbconnRegisterPool.class
     文件          82  2016-06-07 21:28  DBConnectoruildclassesjdbc.properties
     文件         328  2016-06-06 20:59  DBConnectoruildclasseslog4j.properties
............此处省略97个文件信息