package java_call_oracle_procedure;

import java.sql.Connection;
import java.sql.DriverManager;
import oracle.jdbc.driver.OracleDriver;

public class GetConn {
    private static Connection conn = null;
    public GetConn() {
    }

    public static Connection getOracleConn() {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection conn = DriverManager.getConnection(
                    "jdbc:oracle:thin:@localhost:1521:ORAC", "scott", "tiger");
            System.out.println("恭喜 恭喜 連接成功!");
        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        } finally {
            safeClose();
        }
        return conn;
    }

    //寫一個安全關閉的連接函數
    public static void safeClose() {
        try {
            if (conn != null) {
                conn.close();
            }
        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        }
    }

}