package com.accp.gz.th.zm.server.dao;

import java.sql.*;

public class ConnectionManager {
    /**
     * 1、獲得數據庫連接
     */
    public static Connection getConn() {

        Connection conn = null;
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection("jdbc:odbc:GoodsSystem");
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        } catch (ClassNotFoundException ex) {
            System.out.println(ex.toString());
        }
        return conn;
    }

    /**
     * 2、關閉數據庫連接
     */
    public static void Close(Connection conn) {
        try {
            conn.close();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
    }

    /**
     * 3、關閉語句對象
     */
    public static void Close(Statement stmt) {
        try {
            stmt.close();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
    }

    /**
     * 4、關閉預處理語句對象
     */
    public static void Close(PreparedStatement pstmt) {
        try {
            pstmt.close();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
    }


    /**
     * 5、關閉結果集
     */
    public static void Close(ResultSet rs) {
        try {
            rs.close();
        } catch (SQLException ex) {
            System.out.println(ex.toString());
        }
    }
}