guestregister.java~172~

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

                        jRBGroupDestine.setEnabled(false);
                        jRBGroupRegist.setEnabled(false);
                        jBChickIn.setEnabled(false); //入住
                        jBDelete.setEnabled(false); //删除
                    } else if (strRegiTypes.equals("T") &&
                               strCheckInTypes.equals("N")) { //客人类型:团体||入住形式:现入
                        jRBGroupRegist.setEnabled(true);
                        jRBGroupRegist.setSelected(true);
                        jRBGuestDestine.setEnabled(false);
                        jRBGroupDestine.setEnabled(false);
                        jRBGuestRegist.setEnabled(false);
                        jBChickIn.setEnabled(false); //入住
                        jBDelete.setEnabled(false); //删除
                    }

                    jTFGuestRegID.setText(strRID); //ID号
                    jTFName.setText(strName); //客人姓名
                    jTFCompany.setText(strCompany); //单位
                    jTFCounty.setText(strCounty); //国家
                    jTFRegPhone.setText(strRegPhone); //联系电话
                    jCBPaperType.removeAllItems();
                    jCBPaperType.addItem(strPaperType); //证件类型
                    jTFPaperNo.setText(strPaperNo); //证件号码
                    jTextField7.setText(flDeposit); //押金
                    jTFWillCheckDate.setText(dateformat.format(daWillCheckDate)); //抵店日期
                    jTFCheckInDate.setText(dateformat.format(daCheckInDate)); //入住日期
                    jTFCheckInDay.setText(strCheckInDay); //入住天数
                    jTFPersonMon.setText(strPersonMon); //入住人数
                    jTFRoomMon.setText(strRoomMon); //房间数
                    jTACHOReason.setText(strReason); //入住原因

                    jTFGuestRegID.setEnabled(false); //ID号
                    jTFName.setEnabled(false); //客人姓名
                    jTFRoomMon.setEnabled(false); //单位
                    jTFRegPhone.setEnabled(false); //国家
                    jTFName.setEnabled(false); //联系电话
                    jCBPaperType.setEnabled(false); //证件类型
                    jTFRoomMon.setEnabled(false); //证件号码
                    jTextField7.setEnabled(false); //押金
                    jTFWillCheckDate.setEnabled(false); //抵店日期
                    jTFCheckInDate.setEnabled(false); //入住日期
                    jTFCheckInDay.setEnabled(false); //入住天数
                    jTFPersonMon.setEnabled(false); //入住人数
                    jTACHOReason.setEnabled(false); //入住原因
                    return;
                }

            } //while

            JOptionPane.showMessageDialog(null, "您所查找的内容不在库中！", "酒店信息管理系统提示",
                                          JOptionPane.WARNING_MESSAGE);
            jTFEmpIDQuery.setText("");
            //-----------------------------------------------------------------------------------------------------------

        }

        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


    }

    public void jBChickIn_actionPerformed(ActionEvent e) {//入住
        RegisterID = jTFGuestRegID.getText(); //ID号
        //----------------------------------------------------------------------- 散客预定管理||团体预定管理
        if (buttonGroup1.getSelection() == jRBGuestDestine.getModel() ||
            buttonGroup1.getSelection() == jRBGroupDestine.getModel()) { //散客预定管理||团体预定管理
            try {
                connect1 = new DataConnect();
                connect2 = new DataConnect();
                connect1.con1 = DriverManager.getConnection(connect1.url); //建立连接
                connect2.con2 = DriverManager.getConnection(connect2.url); //建立连接

                connect1.stmt1 = connect1.con1.createStatement(); //创建语句
                connect2.stmt2 = connect2.con2.createStatement(); //创建语句

                connect1.sql1 = connect1.sql1 =
                        " UPDATE  HIMS_Register SET CheckInType = 'N' , CheckInDate ='" +
                        jTFWillCheckDate.getText() + "' where RegisterID = '"
                        + RegisterID + "'";
                connect2.sql2 =
                        " UPDATE  HIMS_RoomState SET  OnUser = '1' , Reason  = '此房间有客人入住！！' where   HIMS_RoomState.RoomID  in (select RoomName01 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName02 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName03 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName04 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName05 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName06 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName07 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "') or HIMS_RoomState.RoomID  in (select RoomName08 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                        RegisterID + "')";

                connect1.stmt1.executeUpdate(connect1.sql1);
                connect2.stmt2.executeUpdate(connect2.sql2);

    //---------------------------------------------------------------------------------------散客预约管理||团体预约管理
                JOptionPane.showMessageDialog(this, "入住成功！", "酒店信息管理系统提示",
                                              JOptionPane.INFORMATION_MESSAGE);
                jBDelete.setEnabled(false); //删除
                jBNewBuild.setEnabled(true); //新单
            } catch (SQLException ex) {
                ex.printStackTrace();
            } finally {
                try {
                    if (connect1.con1 != null && connect2.con2 != null) {
                        connect1.con1.close(); //关闭数据库
                        connect2.con2.close(); //关闭数据库
                        connect1.stmt1.close();
                        connect2.stmt2.close();
                    } //if
                } catch (SQLException ex) {
                    System.out.println(ex);
                } //catch
            } //finally
        }


    }
}


class GuestRegister_jBChickIn_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBChickIn_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBChickIn_actionPerformed(e);
    }
}


class GuestRegister_jBEmpIDQuery_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBEmpIDQuery_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBEmpIDQuery_actionPerformed(e);
    }
}


class GuestRegister_jBNewBuildFinish_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBNewBuildFinish_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBNewBuildFinish_actionPerformed(e);
    }
}


class GuestRegister_jBFSetRoomMon_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBFSetRoomMon_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBFSetRoomMon_actionPerformed(e);
    }
}


class GuestRegister_jBDelete_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBDelete_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBDelete_actionPerformed(e);
    }
}


class GuestRegister_jBGuestRegID_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBGuestRegID_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBGuestRegID_actionPerformed(e);
    }
}


class GuestRegister_jBNewBuild_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBNewBuild_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBNewBuild_actionPerformed(e);
    }
}


class GuestRegister_jBQueryFreeRoom_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBQueryFreeRoom_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBQueryFreeRoom_actionPerformed(e);
    }
}


class GuestRegister_jBQueryRoomInfo_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBQueryRoomInfo_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBQueryRoomInfo_actionPerformed(e);
    }
}


class GuestRegister_jBQuit_actionAdapter implements ActionListener {
    private GuestRegister adaptee;
    GuestRegister_jBQuit_actionAdapter(GuestRegister adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.jBQuit_actionPerformed(e);
    }
}