jdbcconnectionfactory.java

来自「本系统是一个跨平台的搜索引擎」· Java 代码 · 共 52 行

package com.briup;

import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class JDBCConnectionFactory {
	/*private static String driver =
		"oracle.jdbc.driver.OracleDriver";
	private static String url = 
		"jdbc:oracle:thin:@127.0.0.1:1521:XE";
	private static String user = "briup";
	private static String passwd = "briup";*/
	private static String driver = "";
	private static String url = "";
	private static String user = "";
	private static String passwd = "";
	static{
		Properties pro = new Properties();
		try{
			//pro.load(new FileInputStream("src/com/briup/common/jdbc/Application.properties"));
			// 根据类的镜像来装载文件,使用反射机制
			pro.load(JDBCConnectionFactory.
					class.getResourceAsStream
					("Application.properties"));
			driver = pro.getProperty("driver");
			url = pro.getProperty("url");
			user = pro.getProperty("user");
			passwd = pro.getProperty("passwd");
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
	
	
	//参照DriverManager.getConnection(...),定义一个静态方法获得一个数据库连接
	public static Connection getConnection(){
		Connection conn = null;
		try{
			// 注册一个driver
			Class.forName(driver);
			// 获得数据库连接
			conn = DriverManager.
			getConnection(url,user,passwd);
		}catch(Exception e){
			e.printStackTrace();
		}
		return conn;
	}
}