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