connectiondb.java~2~

这个一个餐厅预定系统,可实现查询目前餐厅预订情况,实现餐桌预订以及就餐时为顾客调节餐桌的情况.

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;
//连接类，返回一个连接
public class ConnectionDB {

        String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//声明数据库驱动
        String url = "jdbc:odbc:RestaurantBooking";//声明数据源
        Connection conn = null;//声明与数据库的连接
        public ConnectionDB()
        {}
        public void open() throws java.lang.Exception{
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
              conn = DriverManager.getConnection(url);
              System.out.println("DB OPEN");
       }
       public void close() throws java.lang.Exception{
              conn.close();
              System.out.println("DB CLOSE");
      }
      public  Connection getDBCon() {
                      try{
                          Class.forName(dbDriver);//加载数据库驱动
                          conn = DriverManager.getConnection(url);//连接数据库
                      }
                      catch (SQLException ex) {
                          System.out.println(ex.toString());
                      }
                      catch (ClassNotFoundException ex) {
                          System.out.println(ex.toString());
                      }
                      finally {
                          if (conn == null) {
                              //System.out.println("数据库连接失败！");
                              return null;
                          }
                           {
                              //System.out.println("数据库连接成功！");
                               return conn;
                          }
                 }
      }





}