connectiondb.java

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

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 {


        public ConnectionDB()
        {}

        public  static  Connection getCon() {
          String dbDriver = "sun.jdbc.odbc.JdbcOdbcDriver";//声明数据库驱动
          String url = "jdbc:odbc:Bookingsystemdb";//声明数据源
          Connection conn = null;//声明与数据库的连接

                      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;
                          }
                 }
      }
      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();
                       }
               }
       }


   }