guestchechinroom.java

酒店信息管理系统包括客户的信息

package GuestManagement;

import java.awt.*;

import javax.swing.*;
import java.awt.BorderLayout;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.BorderFactory;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import hotelinformationmanagesystem.SetFormCenter;
import hotelinformationmanagesystem.ReturnPopedom;
import java.sql.DriverManager;
import java.sql.SQLException;
import hotelinformationmanagesystem.DataConnect;
import hotelinformationmanagesystem.MainFrame;
import java.sql.ResultSet;
import hotelinformationmanagesystem.JudgeValidity;

/**
 * <p>Title: 酒店信息管理系统</p>
 *
 * <p>Description: The Management Information System of Hotel</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: JSP</p>
 *
 * @author 江世澎
 * @version 1.0
 */
public class GuestChechInRoom extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPGuestRegID = new JPanel();
    XYLayout xYLayout2 = new XYLayout();
    JLabel jLGuestRegID = new JLabel();
    JTextField jTFGuestRegID = new JTextField();
    JPanel jPRoomID01 = new JPanel();
    XYLayout xYLayout3 = new XYLayout();
    JLabel jLRoomID01 = new JLabel();
    JLabel jLRoomID02 = new JLabel();
    JLabel jLRoomID03 = new JLabel();
    JLabel jLRoomID04 = new JLabel();
    JPanel jPRoomID02 = new JPanel();
    XYLayout xYLayout4 = new XYLayout();
    JLabel jLRoomID05 = new JLabel();
    JLabel jLRoomID07 = new JLabel();
    JLabel jLRoomID06 = new JLabel();
    JLabel jLRoomID08 = new JLabel();
    JPanel jPCommand02 = new JPanel();
    XYLayout xYLayout5 = new XYLayout();
    JTextField jTFRoomID01 = new JTextField();
    JTextField jTFRoomID02 = new JTextField();
    JTextField jTFRoomID03 = new JTextField();
    JTextField jTFRoomID04 = new JTextField();
    JTextField jTFRoomID05 = new JTextField();
    JTextField jTFRoomID06 = new JTextField();
    JTextField jTFRoomID07 = new JTextField();
    JTextField jTFRoomID08 = new JTextField();
    JPanel jPCommand03 = new JPanel();
    XYLayout xYLayout7 = new XYLayout();
    JButton jBChange = new JButton();
    JButton jBYes = new JButton();
    JPanel jPCommand01 = new JPanel();
    JButton jBShowFreeRoom = new JButton();
    XYLayout xYLayout6 = new XYLayout();

    hotelinformationmanagesystem.JudgeValidity judgeval = new JudgeValidity();
    ChangeRoom changeroom = new ChangeRoom();
    GuestRegister guestreg = new GuestRegister();

    DataConnect connect1;
    DataConnect connect2;
    ResultSet rs1l = null;

    public static String strRoomName01 = "";
    public static String strRoomName02 = "";
    public static String strRoomName03 = "";
    public static String strRoomName04 = "";
    public static String strRoomName05 = "";
    public static String strRoomName06 = "";
    public static String strRoomName07 = "";
    public static String strRoomName08 = "";
    JButton jBPush = new JButton();
    public GuestChechInRoom() {
        try {
            jbInit();
            localinf();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void localinf() {
        try {
            //-----------------------------------------------------------------------------------------------------
            connect1 = new DataConnect();
            connect1.con1 = DriverManager.getConnection(connect1.url); //建立连接
            connect1.stmt1 = connect1.con1.createStatement(); //创建语句
            connect1.sql1 = "SELECT * FROM HIMS_Register_CheckInRoom;";
            rs1l = connect1.stmt1.executeQuery(connect1.sql1);
            //-----------------------------------------------------------------------------------------------------
            while (rs1l.next()) {
                String strID = rs1l.getString("RegRoomID");
                strRoomName01 = rs1l.getString("RoomName01");
                strRoomName02 = rs1l.getString("RoomName02");
                strRoomName03 = rs1l.getString("RoomName03");
                strRoomName04 = rs1l.getString("RoomName04");
                strRoomName05 = rs1l.getString("RoomName05");
                strRoomName06 = rs1l.getString("RoomName06");
                strRoomName07 = rs1l.getString("RoomName07");
                strRoomName08 = rs1l.getString("RoomName08");

                if (strID.equals(guestreg.RegisterID)) {
                    jTFRoomID01.setText(strRoomName01);
                    jTFRoomID02.setText(strRoomName02);
                    jTFRoomID03.setText(strRoomName03);
                    jTFRoomID04.setText(strRoomName04);
                    jTFRoomID05.setText(strRoomName05);
                    jTFRoomID06.setText(strRoomName06);
                    jTFRoomID07.setText(strRoomName07);
                    jTFRoomID08.setText(strRoomName08);
                    if (!strRoomName01.equals("")) {
                        jBChange.setEnabled(true);
                        jBShowFreeRoom.setEnabled(false);
                        jTFRoomID01.setEnabled(false);
                        jTFRoomID02.setEnabled(false);
                        jTFRoomID03.setEnabled(false);
                        jTFRoomID04.setEnabled(false);
                        jTFRoomID05.setEnabled(false);
                        jTFRoomID06.setEnabled(false);
                        jTFRoomID07.setEnabled(false);
                        jTFRoomID08.setEnabled(false);
                    } else {
                        jBYes.setEnabled(true);
                        jBChange.setEnabled(false);
                        jBPush.setEnabled(false);
                    }
                    return;
                }
            } //while
        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {
            try {
                if (connect1.con1 != null) {
                    connect1.con1.close(); //关闭数据库admin
                    connect1.stmt1.close();

                } //if
            } catch (SQLException ex) {
                System.out.println(ex);
            } //catch
        } //finally
    }


    private void jbInit() throws Exception {
        getContentPane().setLayout(xYLayout1);
        this.setResizable(false);
        this.setSize(470, 230);
        this.setTitle("客房入住设置");
        jPGuestRegID.setBorder(BorderFactory.createEtchedBorder());
        jPGuestRegID.setLayout(xYLayout2);
        jLGuestRegID.setFont(new java.awt.Font("宋体", Font.BOLD, 16));
        jLGuestRegID.setText("客人登记号");
        xYLayout1.setWidth(461);
        xYLayout1.setHeight(194);
        jTFGuestRegID.setEnabled(false);
        jTFGuestRegID.setBorder(BorderFactory.createEtchedBorder());
        jPRoomID01.setBorder(BorderFactory.createEtchedBorder());
        jPRoomID01.setLayout(xYLayout3);
        jLRoomID01.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID01.setText("客房号");
        jLRoomID02.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID02.setText("客房号");
        jLRoomID03.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID03.setText("客房号");
        jLRoomID04.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID04.setText("客房号");
        jPRoomID02.setBorder(BorderFactory.createEtchedBorder());
        jPRoomID02.setLayout(xYLayout4);
        jLRoomID05.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID05.setText("客房号");
        jLRoomID07.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID07.setText("客房号");
        jLRoomID06.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID06.setText("客房号");
        jLRoomID08.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLRoomID08.setText("客房号");
        jPCommand02.setLayout(xYLayout5);
        jPCommand02.setBorder(BorderFactory.createEtchedBorder());
        jTFRoomID01.setEnabled(false);
        jTFRoomID02.setEnabled(false);
        jTFRoomID03.setEnabled(false);
        jTFRoomID04.setEnabled(false);
        jTFRoomID05.setEnabled(false);
        jTFRoomID06.setEnabled(false);
        jTFRoomID07.setEnabled(false);
        jTFRoomID08.setEnabled(false);
        jBYes.addActionListener(new GuestChechInRoom_jButton3_actionAdapter(this));
        jBYes.setEnabled(false);
        jBYes.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jBYes.setText("确定");
        jPCommand01.setBorder(BorderFactory.createEtchedBorder());
        jPCommand01.setLayout(xYLayout6);
        jBShowFreeRoom.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jBShowFreeRoom.setText("查看空客房");
        jBShowFreeRoom.addActionListener(new
                                         GuestChechInRoom_jButton1_actionAdapter(this));
        jPCommand03.setBorder(BorderFactory.createEtchedBorder());
        jPCommand03.setLayout(xYLayout7);
        jBChange.setEnabled(false);
        jBChange.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jBChange.setText("换房");
        jBChange.addActionListener(new GuestChechInRoom_jBChange_actionAdapter(this));
        jBPush.setEnabled(false);
        jBPush.setFont(new java.awt.Font("宋体", Font.PLAIN, 10));
        jBPush.setText("刷新");
        jBPush.addActionListener(new GuestChechInRoom_jBPush_actionAdapter(this));
        jPGuestRegID.add(jLGuestRegID, new XYConstraints(1, 5, -1, -1));
        jPGuestRegID.add(jTFGuestRegID, new XYConstraints(90, 1, 128, 25));
        jPRoomID01.add(jLRoomID01, new XYConstraints(10, 10, -1, -1));
        jPRoomID01.add(jLRoomID02, new XYConstraints(10, 49, -1, -1));
        this.getContentPane().add(jPRoomID02,
                                  new XYConstraints(232, 37, 226, 154));
        jPRoomID02.add(jLRoomID06, new XYConstraints(9, 49, -1, -1));
        jPRoomID02.add(jLRoomID05, new XYConstraints(9, 10, -1, -1));
        jPRoomID02.add(jTFRoomID05, new XYConstraints(86, 5, 128, 29));
        this.getContentPane().add(jPRoomID01, new XYConstraints(4, 37, 226, 154));
        this.getContentPane().add(jPGuestRegID, new XYConstraints(4, 3, 226, 32));
        jPRoomID01.add(jTFRoomID01, new XYConstraints(90, 5, 128, 29));
        jPRoomID01.add(jTFRoomID02, new XYConstraints(90, 43, 128, 29));
        jPRoomID01.add(jTFRoomID03, new XYConstraints(90, 79, 128, 29));
        jPRoomID01.add(jLRoomID03, new XYConstraints(10, 84, -1, -1));
        jPRoomID01.add(jTFRoomID04, new XYConstraints(90, 115, 128, 29));
        jPRoomID01.add(jLRoomID04, new XYConstraints(10, 123, -1, -1));
        jPRoomID02.add(jTFRoomID06, new XYConstraints(86, 41, 128, 29));
        jPRoomID02.add(jTFRoomID07, new XYConstraints(86, 79, 128, 29));
        jPRoomID02.add(jTFRoomID08, new XYConstraints(86, 115, 128, 29));
        jPRoomID02.add(jLRoomID08, new XYConstraints(9, 123, -1, -1));
        jPRoomID02.add(jLRoomID07, new XYConstraints(9, 84, -1, -1));
        jPCommand01.add(jBShowFreeRoom, new XYConstraints(2, 4, 85, 20));
        this.getContentPane().add(jPCommand02, new XYConstraints(394, 3, 64, 32));
        jPCommand02.add(jBYes, new XYConstraints(3, 4, -1, 20));
        this.getContentPane().add(jPCommand01, new XYConstraints(232, 3, 93, 32));
        this.getContentPane().add(jPCommand03, new XYConstraints(327, 3, 66, 32));
        jPCommand03.add(jBChange, new XYConstraints(3, 2, -1, -1));
        jPCommand03.add(jBPush, new XYConstraints(3, 2, -1, -1));
        SetFormCenter windowcenter = new SetFormCenter();
        windowcenter.setcenter(this);

        if (guestreg.RoomMon.equals("1")) {
            jTFRoomID01.setEnabled(true);
        } else if (guestreg.RoomMon.equals("2")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
        } else if (guestreg.RoomMon.equals("3")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
        } else if (guestreg.RoomMon.equals("4")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
        } else if (guestreg.RoomMon.equals("5")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
        } else if (guestreg.RoomMon.equals("6")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
        } else if (guestreg.RoomMon.equals("7")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
            jTFRoomID07.setEnabled(true);
        } else if (guestreg.RoomMon.equals("8")) {
            jTFRoomID01.setEnabled(true);
            jTFRoomID02.setEnabled(true);
            jTFRoomID03.setEnabled(true);
            jTFRoomID04.setEnabled(true);
            jTFRoomID05.setEnabled(true);
            jTFRoomID06.setEnabled(true);
            jTFRoomID07.setEnabled(true);
            jTFRoomID08.setEnabled(true);
        } else {
            jTFRoomID01.setEnabled(false);
            jTFRoomID02.setEnabled(false);