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

import java.sql.*;

public class ConnectionManager {
        /**
         * 獲得數(shù)據(jù)庫連接
         */
        public static Connection getConn() throws
                SQLException,ClassNotFoundException{

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


            return conn;
        }

        public static void Close(Connection conn) throws SQLException{
            try {
                conn.close();
            } catch (SQLException ex) {
                throw ex;
            }
        }
}