connectionfactory.java

来自「数据库远程同步软件NetBeans项目源文件 项目采用Jdesktop集成组件」· Java 代码 · 共 90 行

package com.qixuan.jdbc.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

/*****************************
 * 连接工厂类：
 * 目的就是为提供获取数据库连接的统一方式；
 * 而且此工厂可以进行配置，可根据配置文件来
 * 决定生成针对不同数所库驱动的连接对像；
 * @author yejf
 * @since 2008/06/17
 * @version 1.0
 */
public class ConnectionFactory {
	
	private static String filePath = "conf/dbconfig.properties";
	private static Properties info 
						= new Properties();
	
	public static final String DRIVER = "driverClass";
	public static final String URL = "url";
	public static final String USER = "user";
	public static final String PWD = "password";
	
	//把指定属性文件的内容加载进 info 中
	static {
		InputStream in = null;
		try {
			//获取输入流
			in = Thread
					.currentThread()
					.getContextClassLoader()
					.getResourceAsStream(filePath);
				/*ConnectionFactory
					.class
					.getClassLoader()
					.getResourceAsStream(filePath);*/
				
			info.load(in);
			
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			if(in != null)
				try {
					in.close();
				} catch (IOException e) {
					e.printStackTrace();
				}
		}
	}
	
	public static Connection getConnection() {
		Connection con = null;
		//1. 注册驱动
		try {
			Class.forName(
					info.getProperty(DRIVER));
			con = DriverManager	
					.getConnection(
						info.getProperty(URL), 
						info.getProperty(USER), 
						info.getProperty(PWD));
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return con;
	}
	
}