returnroomframe.java

酒店管理系统后台数据库存储过程

package operation;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;
import entity.AccountBean;
import entity.GuestRegistBean;
import java.util.Calendar;
import javax.swing.Timer;

/**
 * <p>Title: Hawaii rummery manage</p>
 *
 * <p>Description: minityperummery manage</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: Yue.</p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ReturnRoomFrame extends JFrame {
    public ReturnRoomFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setBackground(new Color(212, 255, 255));
        this.setResizable(false);
        this.setTitle("客人退房");
        this.getContentPane().setLayout(null);
        lblTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 30));
        lblTitle.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("客人退房");
        lblTitle.setBounds(new Rectangle(271, 7, 162, 50));
        btnQuery.setBackground(new Color(220, 255, 255));
        btnQuery.setEnabled(false);
        btnQuery.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnQuery.setForeground(Color.red);
        btnQuery.addActionListener(new ReturnRoomFrame_btnQuery_actionAdapter(this));
        lblRoomNo.setBackground(new Color(212, 230, 255));
        lblRoomNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        sqlPanel.setBackground(new Color(212, 230, 255));
        sqlPanel.setBorder(BorderFactory.createEtchedBorder());
        sqlPanel.setBounds(new Rectangle(50, 69, 300, 87));
        sqlPanel.setLayout(null);
        cboRoomNo.setBackground(new Color(255, 230, 255));
        cboRoomNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboRoomNo.setBounds(new Rectangle(167, 50, 110, 25));
        cboRoomNo.addItem("房间号");
        lblRoomNo.setText("请选择客房房间号：");
        lblRoomNo.setBounds(new Rectangle(16, 12, 137, 28));
        infoPanel.setBackground(new Color(212, 230, 255));
        infoPanel.setBorder(BorderFactory.createEtchedBorder());
        infoPanel.setBounds(new Rectangle(51, 167, 299, 335));
        infoPanel.setLayout(null);
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtName.setText("");
        txtName.setBounds(new Rectangle(143, 11, 130, 25));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jLabel1.setText("客人姓名：");
        jLabel1.setBounds(new Rectangle(11, 11, 110, 25));
        txtAccount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAccount.setText("");
        txtAccount.setBounds(new Rectangle(141, 42, 130, 25));
        lblAccount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAccount.setText("客人帐号：");
        lblAccount.setBounds(new Rectangle(11, 45, 110, 25));
        lblTime.setForeground(new Color(255, 0, 208));
        lblTime.setBorder(BorderFactory.createRaisedBevelBorder());
        lblTime.setText("");
        lblTime.setBounds(new Rectangle(458, 44, 199, 23));
        lblCheckIn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblCheckIn.setText("抵店日期：");
        lblCheckIn.setBounds(new Rectangle(11, 76, 110, 25));
        lblCheckOut.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblCheckOut.setText("离店日期：");
        lblCheckOut.setBounds(new Rectangle(11, 110, 110, 25));
        txtCheckIn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtCheckIn.setText("");
        txtCheckIn.setBounds(new Rectangle(142, 72, 130, 25));
        txtCheckOut.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtCheckOut.setText("");
        txtCheckOut.setBounds(new Rectangle(141, 102, 130, 27));
        lblDepatePri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDepatePri.setText("打 折 价：");
        lblDepatePri.setBounds(new Rectangle(11, 175, 110, 25));
        lblLivDays.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblLivDays.setToolTipText("");
        lblLivDays.setText("入住天数：");
        lblLivDays.setBounds(new Rectangle(11, 140, 110, 25));
        txtDepatePri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtDepatePri.setText("");
        txtDepatePri.setBounds(new Rectangle(141, 169, 130, 25));
        txtlivDays.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtlivDays.setText("");
        txtlivDays.setBounds(new Rectangle(141, 135, 130, 26));
        lblDeposit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDeposit.setText("押      金：");
        lblDeposit.setBounds(new Rectangle(11, 203, 110, 25));
        txtDeposit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtDeposit.setText("");
        txtDeposit.setBounds(new Rectangle(141, 201, 129, 25));
        txtTotal.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTotal.setText("");
        txtTotal.setBounds(new Rectangle(142, 233, 130, 25));
        lblTotal.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTotal.setText("总      额：");
        lblTotal.setBounds(new Rectangle(11, 234, 110, 25));
        Panpicture.setBorder(BorderFactory.createEtchedBorder());
        Panpicture.setBounds(new Rectangle(382, 73, 280, 330));
        Panpicture.setLayout(card);
        btnPanel.setBackground(new Color(212, 230, 255));
        btnPanel.setBorder(BorderFactory.createEtchedBorder());
        btnPanel.setBounds(new Rectangle(380, 420, 280, 78));
        btnPanel.setLayout(null);
        btnOK.setBackground(new Color(220, 255, 255));
        btnOK.setBounds(new Rectangle(24, 24, 102, 28));
        btnOK.setEnabled(false);
        btnOK.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnOK.setForeground(Color.magenta);
        btnOK.setText("");
        btnOK.addActionListener(new ReturnRoomFrame_btnOK_actionAdapter(this));
        btnCancel.setBackground(new Color(220, 255, 255));
        btnCancel.setBounds(new Rectangle(143, 24, 95, 28));
        btnCancel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnCancel.setForeground(Color.magenta);
        btnCancel.setText("");
        btnCancel.addActionListener(new ReturnRoomFrame_btnCancel_actionAdapter(this));
        txtAdmin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAdmin.setText("");
        txtAdmin.setBounds(new Rectangle(144, 297, 130, 25));
        lblAdmin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAdmin.setText("操  作 员：");
        lblAdmin.setBounds(new Rectangle(13, 295, 110, 25));
        cboRoomType.setBackground(new Color(255, 230, 255));
        cboRoomType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboRoomType.setBounds(new Rectangle(167, 16, 110, 26));
        cboRoomType.addItem("房间类别");
        cboRoomType.addItem("豪华间");
        cboRoomType.addItem("标准间");
        cboRoomType.addItem("普通间");
        cboRoomType.addItemListener(new ReturnRoomFrame_cboRoomType_itemAdapter(this));
        txtReckoning.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtReckoning.setText("");
        txtReckoning.setBounds(new Rectangle(143, 264, 130, 25));
        lblReckoning.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblReckoning.setText("客人结帐：");
        lblReckoning.setBounds(new Rectangle(10, 262, 110, 25));
        this.btnQuery.setIcon(new ImageIcon("image\\frame\\ReturnRoomFrame\\query.jpg"));
        this.btnCancel.setIcon(new ImageIcon("image\\frame\\ReturnRoomFrame\\cancel.jpg"));
        this.btnOK.setIcon(new ImageIcon("image\\frame\\ReturnRoomFrame\\confir.jpg"));
        lbl1.setText("");
        lbl2.setText("");
        lbl3.setText("");
        lbl4.setText("");
        lbl5.setText("");
        lbl6.setText("");
        lbl7.setText("");
        lbl8.setText("");
        sqlPanel.add(cboRoomType);
        sqlPanel.add(cboRoomNo);
        sqlPanel.add(btnQuery);
        sqlPanel.add(lblRoomNo);
        this.getContentPane().add(lblTime);
        this.getContentPane().add(lblTitle);
        infoPanel.add(txtName);
        infoPanel.add(jLabel1);
        infoPanel.add(lblCheckIn);
        infoPanel.add(lblTotal);
        infoPanel.add(lblDeposit);
        infoPanel.add(lblDepatePri);
        infoPanel.add(lblLivDays);
        infoPanel.add(lblCheckOut);
        infoPanel.add(lblAccount);
        infoPanel.add(txtAccount);
        infoPanel.add(txtCheckIn);
        infoPanel.add(txtCheckOut);
        infoPanel.add(txtlivDays);
        infoPanel.add(txtDepatePri);
        infoPanel.add(txtTotal);
        infoPanel.add(txtDeposit);
        infoPanel.add(txtReckoning);
        infoPanel.add(txtAdmin);
        infoPanel.add(lblReckoning);
        infoPanel.add(lblAdmin);
        this.getContentPane().add(btnPanel);
        btnPanel.add(btnOK);
        btnPanel.add(btnCancel);
        this.getContentPane().add(Panpicture);
        lbl1.setIcon(i1);
        lbl2.setIcon(i2);
        lbl3.setIcon(i3);
        lbl4.setIcon(i4);
        lbl5.setIcon(i5);
        lbl6.setIcon(i6);
        lbl7.setIcon(i7);
        lbl8.setIcon(i8);



        Panpicture.add(lbl1, "lbl1");
        Panpicture.add(lbl3, "lbl3");
        Panpicture.add(lbl4, "lbl4");
        Panpicture.add(lbl5, "lbl5");
        Panpicture.add(lbl6, "lbl6");
        Panpicture.add(lbl7, "lbl7");
        Panpicture.add(lbl8, "lbl8");
        Panpicture.add(lbl2, "lbl2");
        this.getContentPane().add(sqlPanel);
        this.getContentPane().add(infoPanel);
        btnQuery.setBounds(new Rectangle(27, 51, 98, 25));
        btnQuery.setText("");
        dbo = new DBOperatorBean();
        showPicture();
        showTime();

    }

    JLabel lblTitle = new JLabel();
    JButton btnQuery = new JButton();
    JLabel lblRoomNo = new JLabel();
    JComboBox cboRoomNo = new JComboBox();
    JPanel sqlPanel = new JPanel();
    JPanel infoPanel = new JPanel();
    JTextField txtName = new JTextField();
    JLabel jLabel1 = new JLabel();
    JTextField txtAccount = new JTextField();
    JLabel lblAccount = new JLabel();
    JLabel lblTime = new JLabel();
    JLabel lblCheckIn = new JLabel();
    JLabel lblCheckOut = new JLabel();
    JTextField txtCheckIn = new JTextField();
    JTextField txtCheckOut = new JTextField();
    JLabel lblDepatePri = new JLabel();
    JLabel lblLivDays = new JLabel();
    JTextField txtDepatePri = new JTextField();
    JTextField txtlivDays = new JTextField();
    JLabel lblDeposit = new JLabel();
    JTextField txtDeposit = new JTextField();
    JTextField txtTotal = new JTextField();
    JLabel lblTotal = new JLabel();
    JPanel Panpicture = new JPanel();
    JPanel btnPanel = new JPanel();
    JButton btnOK = new JButton();
    JButton btnCancel = new JButton();
    JTextField txtAdmin = new JTextField();
    JLabel lblAdmin = new JLabel();
    JComboBox cboRoomType = new JComboBox();

    DBOperatorBean dbo;
    ResultSet rs = null;
    JTextField txtReckoning = new JTextField();
    JLabel lblReckoning = new JLabel();
    RegisterFrame register = new RegisterFrame();
    Timer timer;
    CardLayout card = new CardLayout();
    JLabel lbl1 = new JLabel();
    JLabel lbl2 = new JLabel();
    JLabel lbl3 = new JLabel();
    JLabel lbl4 = new JLabel();
    JLabel lbl5 = new JLabel();
    JLabel lbl6 = new JLabel();
    JLabel lbl7 = new JLabel();
    JLabel lbl8 = new JLabel();
    ImageIcon i1 = new ImageIcon("image\\img2\\2001.jpg");
    ImageIcon i2 = new ImageIcon("image\\img2\\2002.jpg");
    ImageIcon i3 = new ImageIcon("image\\img2\\2003.jpg");
    ImageIcon i4 = new ImageIcon("image\\img2\\2004.jpg");
    ImageIcon i5 = new ImageIcon("image\\img2\\2005.jpg");
    ImageIcon i6 = new ImageIcon("image\\img2\\2006.jpg");
    ImageIcon i7 = new ImageIcon("image\\img2\\2007.jpg");
    ImageIcon i8 = new ImageIcon("image\\img2\\2008.jpg");


    int number = 0;
    Timer timer2;


    public void showPicture() {
        ActionListener show = new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                number++;
                String name = "lbl" + number;
                card.show(Panpicture, name);
                if (number == 8) {
                    number = 0;
                }
            }
        };

        timer2 = new Timer(1500, show);
        timer2.start();

    }


    //单击查询按钮事件！
    public void btnQuery_actionPerformed(ActionEvent e) {
        //判断用户选择的房间类别和房间号
        String roomtype = this.cboRoomType.getSelectedItem().toString();
        if (roomtype.equals("房间类别")) {