package bookingsystem;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;
import javax.swing.JOptionPane;
//連接類，返回一個(gè)連接
public class ConnectionDB {


        public ConnectionDB()
        {}

        public  static  Connection getCon() {
          String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//聲明數(shù)據(jù)庫驅(qū)動(dòng)
          String url = "jdbc:odbc:Bookingsystemdb";//聲明數(shù)據(jù)源
          Connection conn = null;//聲明與數(shù)據(jù)庫的連接

                      try{
                          Class.forName(dbDriver);//加載數(shù)據(jù)庫驅(qū)動(dòng)
                          conn = DriverManager.getConnection(url);//連接數(shù)據(jù)庫
                      }
                      catch (SQLException ex) {
                          System.out.println(ex.toString());
                      }
                      catch (ClassNotFoundException ex) {
                          System.out.println(ex.toString());
                      }
                      finally {
                          if (conn == null) {
                              //System.out.println("數(shù)據(jù)庫連接失敗！");
                              return null;
                          }
                           {
                              //System.out.println("數(shù)據(jù)庫連接成功！");
                               return conn;
                          }
                 }
      }
      public static void close(Connection n)
       {
               if(n!=null)
               {
                       try {
                               n.close();
                       } catch (SQLException e) {
                               // TODO Auto-generated catch block
                               e.printStackTrace();
                       }
               }
       }
       public static void close(Statement n)
       {
               if(n!=null)
               {
                       try {
                               n.close();
                       } catch (SQLException e) {
                               // TODO Auto-generated catch block
                               e.printStackTrace();
                       }
               }
       }
       public static void close(ResultSet n)
       {
               if(n!=null)
               {
                       try {
                               n.close();
                       } catch (SQLException e) {
                               // TODO Auto-generated catch block
                               e.printStackTrace();
                       }
               }
       }


   }