dbconnection.java

来自「培训时做的学生管理系统.基于J2SE平台开发」· Java 代码 · 共 46 行

package cn.com.util;

import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class DBConnection {
	static Connection conn = null;
	/**
	 * 加载数据库程序，连接数据库
	 * @return
	 */
	public static Connection getConnectionOracle(){
		Properties properties = getProperties();
		String driver = properties.getProperty("driver");
		String url = properties.getProperty("url");
		String user = properties.getProperty("user");
		String pwd = properties.getProperty("pwd");
	try {
		Class.forName(driver);
		conn = DriverManager.getConnection(url,user,pwd);
		System.out.println("连接成功");
	} catch(Exception e){
		System.out.println("数据库连接异常："+e.getMessage());
	}
	return conn;
	
	}	
	/**
	 * 从connectionoracle文件中读取信息
	 * @return
	 */
	public static Properties getProperties(){
		Properties properties = null;
		try{
			properties = new Properties();
			properties.load(new FileInputStream(new File("db.properties")));
		}catch(Exception e){
			System.out.println("文件信息读取异常："+e.getMessage());
		}
		return properties;
		
	}
}