roominfoquery.java~22~

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

            }

            table.fetch("Select HIMS_RoomInfo.RoomID as 客房ID,Class as 客房类型,RoomArea as 房间面积,BedNo as 床位数,StandardPri as 标准价,RebatePri as 折扣价,Place as 客房位置,RoomIntro as 客房信息,Remark as 备注  From HIMS_RoomState, HIMS_RoomInfo where HIMS_RoomState.RoomID = HIMS_RoomInfo.RoomID AND HIMS_RoomInfo.Class = '" +
                        strClass + "';");
            return;
        }
        if (BGQueryChange.getSelection() == jRBRoomID.getModel()) { //按客房ID查询
            String strRoomID = jTFRoomID.getText();
            table.fetch("Select HIMS_RoomInfo.RoomID as 客房ID,Class as 客房类型,RoomArea as 房间面积,BedNo as 床位数,StandardPri as 标准价,RebatePri as 折扣价,Place as 客房位置,RoomIntro as 客房信息,Remark as 备注  From HIMS_RoomState, HIMS_RoomInfo where HIMS_RoomState.RoomID = HIMS_RoomInfo.RoomID AND HIMS_RoomInfo.RoomID like '%" +
                        strRoomID + "%'; ");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(null,
                                              "没有您要找的客房!!",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
            }

            return;
        }
        if (BGQueryChange.getSelection() == jRBBedNom.getModel()) { //按客房床位数查询
            String strBedNo = jTFBedNom.getText();
            if (!judgeval.isFigure(strBedNo)) {
                JOptionPane.showMessageDialog(null,
                                              "房位数必须是数字，请重新输入！",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
                jTFBedNom.setText("");
                return;
            }
            if (strBedNo.length() > 4) {
                JOptionPane.showMessageDialog(null,
                                              "房位数不能超过四位，请重新输入！",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
                jTFBedNom.setText("");
                return;
            }
            table.fetch("Select HIMS_RoomInfo.RoomID as 客房ID,Class as 客房类型,RoomArea as 房间面积,BedNo as 床位数,StandardPri as 标准价,RebatePri as 折扣价,Place as 客房位置,RoomIntro as 客房信息,Remark as 备注  From HIMS_RoomState, HIMS_RoomInfo where HIMS_RoomState.RoomID = HIMS_RoomInfo.RoomID AND HIMS_RoomInfo.BedNo = '" +
                        strBedNo + "'; ");
            if (jTable1.getRowCount() == 0) {
                JOptionPane.showMessageDialog(null,
                                              "没有您要找的客房!!",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
            }
            return;
        }
    }

    public void jRBCON_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //ID
        jTFRoomID.setEnabled(false);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(false); //Bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(false); //class
    }

    public void jRBDestine_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //ID
        jTFRoomID.setEnabled(false);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(false); //Bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(false); //class
    }

    public void jRBBadRoom_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //ID
        jTFRoomID.setEnabled(false);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(false); //Bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(false); //class
    }

    public void jRBRoomClass_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //id
        jTFRoomID.setEnabled(false);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(false); //bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(true); //class
        jCBRoomClass.addItem("　");
        jCBRoomClass.addItem("标准单人间");
        jCBRoomClass.addItem("标准双人间");
        jCBRoomClass.addItem("标准四人间");
        jCBRoomClass.addItem("家庭间");
        jCBRoomClass.addItem("商务间");
        jCBRoomClass.addItem("经济间");
        jCBRoomClass.addItem("豪华套房");
    }

    public void jRBBedNom_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //id
        jTFRoomID.setEnabled(false);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(true); //bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(false); //class
    }

    public void jRBRoomID_actionPerformed(ActionEvent e) {
        jTFRoomID.setText(""); //id
        jTFRoomID.setEnabled(true);

        jTFBedNom.setText("");
        jTFBedNom.setEnabled(false); //bed

        jCBRoomClass.removeAllItems();
        jCBRoomClass.setEnabled(false); //class
    }
}


class RoomInfoQuery_jRBRoomID_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBRoomID_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jRBBedNom_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBBedNom_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jRBRoomClass_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBRoomClass_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jRBBadRoom_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBBadRoom_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jRBDestine_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBDestine_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jRBCON_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jRBCON_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jBQuery_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jBQuery_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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


class RoomInfoQuery_jBQuit_actionAdapter implements ActionListener {
    private RoomInfoQuery adaptee;
    RoomInfoQuery_jBQuit_actionAdapter(RoomInfoQuery adaptee) {
        this.adaptee = adaptee;
    }

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