JDBC公共操作方法(1):JDBC配置文件及其解析

JDBC公共操作方法(一):JDBC配置文件及其解析

?

1.?jdbc.properties

### oracle ###jdbc.driverclass=oracle.jdbc.driver.OracleDriverjdbc.url=jdbc:oracle:thin:@localhost:1521:orcljdbc.username=scottjdbc.password=tiger

2.?常量类

import java.util.HashMap;import java.util.Map;public final class JDBCConstants {private JDBCConstants() {}//用于存放jdbc.properties中的内容public static Map<String, String> jdbcMap = new HashMap<String, String>(4);}

?

3.解析?jdbc.properties

?

import java.io.IOException;import java.io.InputStream;import java.util.Iterator;import java.util.Map;import java.util.Map.Entry;import java.util.Properties;import java.util.Set;import org.apache.log4j.Logger;public final class ParseSqlPropertiesFile {private static final Logger LOG = Logger.getLogger(ParseSqlPropertiesFile.class);private static ParseSqlPropertiesFile instance = new ParseSqlPropertiesFile();private ParseSqlPropertiesFile() {}public static ParseSqlPropertiesFile getInstance() {return instance;}private static final String SQL_FILE_PATH = "jdbc.properties";/** * @Title: getJDBCConfig   * @Description: 获取jdbc.properties中配置的key-value * @return   * @author   * @date 2011-12-29 */public Map<String, String> getJDBCConfig() {InputStream is = ParseSqlPropertiesFile.class.getClassLoader().getResourceAsStream(SQL_FILE_PATH);Properties prop = new Properties();try {prop.load(is);} catch (IOException e) {LOG.error("load file faile!", e);} catch (Exception e) {LOG.error("load file faile!", e);}Set<Entry<Object, Object>> set = prop.entrySet();Iterator<Entry<Object, Object>> it = set.iterator();String key = null, value = null;while (it.hasNext()) {Entry<Object, Object> entry = it.next();key = String.valueOf(entry.getKey());value = String.valueOf(entry.getValue());//放入MapJDBCConstants.jdbcMap.put(key, value);}return JDBCConstants.jdbcMap;}}