package com.hopu.util;

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

/**
 * 連接數(shù)據(jù)庫工具類
 */
public class DBHelper {
    /**
     * 獲取數(shù)據(jù)庫連接對象
     *
     * @return
     */
    public static Connection getConn() {
        Connection conn = null;
        //定義數(shù)據(jù)庫驅(qū)動
        String driver = "oracle.jdbc.OracleDriver";
        //定義數(shù)據(jù)庫連接
        String url = "jdbc:oracle:thin:@localhost:1521:orcl";
        //定義數(shù)據(jù)庫賬戶
        String user = "super";
        //定義數(shù)據(jù)庫密碼
        String password = "super";
        try {
            //加載數(shù)據(jù)庫驅(qū)動
            Class.forName(driver);
            //獲取數(shù)據(jù)庫連接
            conn = DriverManager.getConnection(url, user, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    /**
     * 釋放資源
     *
     * @param conn
     */
    public static void release(Connection conn) {
        try {
            if (conn != null)
                conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}