package console.oracle;

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

import console.AbstractOperation;

/**
 * @author Allan(劉新福)
 * @version 1.0
 */
public class OracleOperation extends AbstractOperation {
	private Connection con;

	public OracleOperation(String serverIP, String serverPort,
			String databaseName, String userName, String password) {
		super(serverIP, serverPort, databaseName, userName, password);
	}

	public OracleOperation(String serverIP, String serverPort,
			String databaseName, String userName, String password,
			int transactionIsolation) {
		super(serverIP, serverPort, databaseName, userName, password,
				transactionIsolation);
	}

	public Connection getConnection() throws Exception {
		if (con == null) {
			try {
				Class.forName("oracle.jdbc.driver.OracleDriver");
				String jdbcURL = "jdbc:oracle:thin:@" + serverIP + ":"
						+ serverPort + ":" + databaseName;
				con = DriverManager.getConnection(jdbcURL, userName, password);
			} catch (ClassNotFoundException e) {
				System.out
						.println("Can not load oracle jdbc driver, please verify your CLASSPATH!");
				throw e;
			} catch (SQLException e) {
				System.out
						.println("Fail to get database connection, please verify	 your database information!");
				throw e;
			}
		}
		return con;
	}
}