getconn.java~31~

来自「oracle的一些详细资料oracle的一些详细资料 看看吧~~」· JAVA~31~ 代码 · 共 38 行

package java_call_oracle_procedure;

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

public class GetConn {
    private 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 void safeClose() {
        try {
            if (conn != null) {
                conn.close();
            }
        } catch (Exception e) {
            System.out.println(e.getMessage().toString());
        }
    }

}