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

 

1. jdbc.properties

### oracle ###
jdbc.driverclass=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl
jdbc.username=scott
jdbc.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());
			//放入Map
			JDBCConstants.jdbcMap.put(key, value);
		}
		return JDBCConstants.jdbcMap;
	}
}