displayroominfo.java

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

package GuestManagement;

import java.awt.*;
import ShowTable.*;
import javax.swing.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import hotelinformationmanagesystem.SetFormCenter;
import java.awt.Font;
import javax.swing.event.AncestorEvent;
import javax.swing.event.AncestorListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

/**
 * <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 DisplayRoomInfo extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JTable jTable1;
    TableExample table = new TableExample();
    JScrollPane jSPCONRoomInfo = new JScrollPane();
    JLabel jLQuit = new JLabel();
    String RegisterID = "";
    GuestSettleAccounts guestSettleaccounts = new GuestSettleAccounts();

    public DisplayRoomInfo() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        jTable1 = table.createTable();
        getContentPane().setLayout(xYLayout1);
        this.setResizable(false);
        this.setTitle("客人入住的房间信息");
        this.setSize(380, 300);
        SetFormCenter wcenter = new SetFormCenter();
        wcenter.setcenter(this);
        xYLayout1.setWidth(374);
        xYLayout1.setHeight(263);
        jLQuit.addMouseListener(new DisplayRoomInfo_jLQuit_mouseAdapter(this));
        this.getContentPane().add(jSPCONRoomInfo,
                                  new XYConstraints(3, 3, 368, 231));
        this.getContentPane().add(jLQuit, new XYConstraints(316, 239, -1, -1));
        jLQuit.setFont(new java.awt.Font("宋体", Font.BOLD, 19));
        jLQuit.setText("退出");

        jSPCONRoomInfo.getViewport().add(jTable1);
        table.fetch("Select distinct RoomID as 客房ID,Class as 客房类型,RoomArea as 客房面积,BedNo as 床位数 ,StandardPri as 标准价,RebatePri as 折扣价,Place as 客房位置 ,RoomIntro as 客房信息,Remark as 备注 from HIMS_Register_CheckInRoom,HIMS_RoomInfo  where   HIMS_RoomInfo .RoomID  in (select RoomName01 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName02 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName03 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName04 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName05 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName06 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName07 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "') or HIMS_RoomInfo.RoomID  in (select RoomName08 from HIMS_Register_CheckInRoom where RegRoomID = '" +
                    guestSettleaccounts.strID + "');");

    }

    public void jLQuit_mouseClicked(MouseEvent e) {
        this.setVisible(false);
    }


}


class DisplayRoomInfo_jLQuit_mouseAdapter extends MouseAdapter {
    private DisplayRoomInfo adaptee;
    DisplayRoomInfo_jLQuit_mouseAdapter(DisplayRoomInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.jLQuit_mouseClicked(e);
    }
}