connectiondb.java~1~

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

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;
//连接类，返回一个连接
class ConnectionDB {
        public static Connection getCon()
        {
                Connection cn=null;
                String url="jdbc:microsoft:sqlserver://172.29.1.202;DatabaseName=SMSDB";
                String user="lab";
                String pwd="software";

                try {
                        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
                        cn=DriverManager.getConnection(url,user,pwd);
                } catch (ClassNotFoundException e) {
                        // TODO Auto-generated catch block
                        JOptionPane.showMessageDialog(null, "导入SQL包错误");
                } catch (SQLException e) {
                        // TODO Auto-generated catch block
                        JOptionPane.showMessageDialog(null, "配置文件出错！");
                }
                return cn;
        }
        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();
                        }
                }
        }
}