connectionfactory.java

纯JAVA代码的考试系统

package org.fangsoft.testcenter.dao.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectionFactory {
	public static final String ORACLE_DRIVER="oracle.jdbc.OracleDriver";
	public static final String ORACLE_USER="system";
	public static final String ORACLE_PASSWORD="h123456";
	public static final String ORACLE_HOST="localhost";
	public static final String ORACLE_PORT="1521";
	public static final String ORACLE_DATABASE="MS";
	
	static{
		try {
			Class.forName(ORACLE_DRIVER);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	public static String getOracleDriver() {
		return ORACLE_DRIVER;
	}
	public static String getOracleUser() {
		return ORACLE_USER;
	}
	public static String getOraclePassword() {
		return ORACLE_PASSWORD;
	}
	public static String getOracleURL() {
		return "jdbc:oracle:thin:@"+ORACLE_HOST+":"+ORACLE_PORT+":"+ORACLE_DATABASE;
	}
	
	public static Connection getConnection(){
		try {
			return DriverManager.getConnection(getOracleURL(),getOracleUser(),getOraclePassword());
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

}