registerframe.java

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

package operation;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.*;
import rummery.LoginFrame;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import entity.GuestRegistBean;
import java.awt.event.FocusEvent;
import java.awt.event.FocusAdapter;

/**
 * <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 RegisterFrame extends JFrame {
    public RegisterFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        lblTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 35));
        lblTitle.setForeground(Color.magenta);
        lblTitle.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("客人入住登记");
        lblTitle.setBounds(new Rectangle(235, 8, 230, 55));
        this.getContentPane().setBackground(new Color(212, 255, 255));
        this.setResizable(false);
        this.setTitle("客人入住登记");
        registPanel.setBackground(new Color(212, 243, 255));
        registPanel.setBorder(BorderFactory.createEtchedBorder());
        registPanel.setBounds(new Rectangle(41, 81, 300, 380));
        registPanel.setLayout(null);
        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblName.setText("*姓名");
        lblName.setBounds(new Rectangle(8, 12, 120, 30));
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtName.setText("");
        txtName.setBounds(new Rectangle(137, 11, 150, 30));
        lblSex.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSex.setText("性别");
        lblSex.setBounds(new Rectangle(8, 64, 120, 30));
        roomPanel.setBackground(new Color(212, 243, 255));
        roomPanel.setBorder(BorderFactory.createEtchedBorder());
        roomPanel.setBounds(new Rectangle(363, 82, 300, 380));
        roomPanel.setLayout(null);
        txtIDNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtIDNo.setText("");
        txtIDNo.setBounds(new Rectangle(137, 149, 150, 30));
        lblIDType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblIDType.setText("证件");
        lblIDType.setBounds(new Rectangle(8, 105, 120, 30));
        rdoMale.setBackground(new Color(190, 217, 243));
        rdoMale.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoMale.setSelected(true);
        rdoMale.setText("男");
        rdoFemale.setBackground(new Color(249, 208, 200));
        rdoFemale.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoFemale.setText("女");
        lblIDNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblIDNo.setText("*证件号");
        lblIDNo.setBounds(new Rectangle(8, 148, 120, 30));
        txtReason.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtReason.setText("旅游");
        txtReason.setBounds(new Rectangle(136, 191, 150, 30));
        lblReason.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblReason.setText("*事由");
        lblReason.setBounds(new Rectangle(8, 188, 120, 30));
        sexPanel.setBackground(Color.yellow);
        sexPanel.setBorder(BorderFactory.createEtchedBorder());
        sexPanel.setBounds(new Rectangle(137, 53, 150, 29));
        sexPanel.setLayout(gridLayout1);
        txtAccountNo.setBackground(new Color(212, 208, 255));
        txtAccountNo.setEditable(false);
        txtAccountNo.setText("");
        txtAccountNo.setBounds(new Rectangle(137, 233, 150, 30));
        lblTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        lblTime.setForeground(Color.blue);
        lblTime.setBorder(BorderFactory.createRaisedBevelBorder());
        lblTime.setText("");
        lblTime.setBounds(new Rectangle(482, 52, 180, 26));
        txtOperater.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtOperater.setText("0");
        txtOperater.setBounds(new Rectangle(137, 325, 150, 30));
        lblAccuont.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAccuont.setText("帐单号");
        lblAccuont.setBounds(new Rectangle(8, 232, 120, 30));
        lblOperater.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblOperater.setText("退房状态：");
        lblOperater.setBounds(new Rectangle(8, 325, 120, 30));
        cboIDType.setBackground(new Color(210, 190, 255));
        cboIDType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboIDType.setBounds(new Rectangle(137, 99, 150, 30));
        cboIDType.addItem("身份证");
        cboIDType.addItem("军人证");
        cboIDType.addItem("学生证");
        cboIDType.addItem("教师证");
        cboIDType.addItem("公务员证");
        cboIDType.addItem("其他");
        cboRoomType.setBackground(new Color(210, 197, 255));
        cboRoomType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboRoomType.setBounds(new Rectangle(166, 15, 120, 30));
        cboRoomType.addItemListener(new RegisterFrame_cboRoomType_itemAdapter(this));
        cboRoomType.addItem("豪华间");
        cboRoomType.addItem("标准间");
        cboRoomType.addItem("普通间");
        txtCheckIn.setBackground(new Color(212, 190, 255));
        txtCheckIn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtCheckIn.setEditable(false);
        txtCheckIn.setText(getCheckInTime());
        txtCheckIn.setBounds(new Rectangle(165, 114, 120, 30));
        lblRoomNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblRoomNo.setText("房间号");
        lblRoomNo.setBounds(new Rectangle(7, 70, 119, 30));
        lblRoomType.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblRoomType.setText("房间类型");
        lblRoomType.setBounds(new Rectangle(7, 15, 121, 30));
        lblCheckInDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblCheckInDate.setText("*抵店日期");
        lblCheckInDate.setBounds(new Rectangle(9, 118, 120, 30));
        lblStanPri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblStanPri.setText("标准价");
        lblStanPri.setBounds(new Rectangle(9, 224, 120, 30));
        txtCheckOut.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtCheckOut.setText(getCheckOutTime());
        txtCheckOut.setBounds(new Rectangle(166, 165, 120, 30));

        txtStanPri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtStanPri.setBorder(BorderFactory.createLoweredBevelBorder());
        txtStanPri.setText("");
        txtStanPri.setBounds(new Rectangle(166, 218, 120, 30));
        lblCheckOutDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblCheckOutDate.setText("*离店日期");
        lblCheckOutDate.setBounds(new Rectangle(9, 173, 120, 30));
        lbldebatePri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbldebatePri.setText("折扣价");
        lbldebatePri.setBounds(new Rectangle(9, 303, 120, 31));
        txtDebatePri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtDebatePri.setText("");
        txtDebatePri.setBounds(new Rectangle(166, 300, 120, 30));
        cboDepate.setBackground(new Color(210, 190, 255));
        cboDepate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboDepate.setBounds(new Rectangle(167, 261, 120, 30));
        cboDepate.addItemListener(new RegisterFrame_cboDepate_itemAdapter(this));
        cboDepate.addItem("全价");
        cboDepate.addItem("九折");
        cboDepate.addItem("八折");
        cboDepate.addItem("七折");
        cboDepate.addItem("六折");
        cboDepate.addItem("五折");
        cboDepate.addItem("四折");
        cboDepate.addItem("三折");
        lblDebate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDebate.setText("打折幅度");
        lblDebate.setBounds(new Rectangle(9, 268, 120, 30));
        txtTotal.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTotal.setText("");
        txtTotal.setBounds(new Rectangle(166, 340, 120, 30));
        lblTotal.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTotal.setText("总额");
        lblTotal.setBounds(new Rectangle(9, 336, 127, 31));
        lnlDeposit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lnlDeposit.setText("押金");
        lnlDeposit.setBounds(new Rectangle(8, 277, 120, 30));
        txtDeposit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtDeposit.setText("200");
        txtDeposit.setBounds(new Rectangle(137, 274, 150, 30));
        btnConfri.setBackground(new Color(151, 255, 255));
        btnConfri.setBounds(new Rectangle(298, 473, 100, 35));
        btnConfri.setEnabled(false);
        btnConfri.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnConfri.setForeground(Color.blue);
        btnConfri.setText("");
        btnConfri.addActionListener(new RegisterFrame_btnConfri_actionAdapter(this));
        btnBack.setBackground(new Color(151, 255, 255));
        btnBack.setBounds(new Rectangle(414, 473, 100, 35));
        btnBack.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnBack.setForeground(Color.blue);
        btnBack.setText("");
        btnBack.addActionListener(new RegisterFrame_btnBack_actionAdapter(this));
        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setForeground(Color.blue);
        jLabel1.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel1.setToolTipText("");
        jLabel1.setText("当前操作员： " + this.managerName);
        jLabel1.setBounds(new Rectangle(43, 53, 180, 25));
        cboRoomNo.setBackground(new Color(210, 190, 255));
        cboRoomNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboRoomNo.setBounds(new Rectangle(166, 70, 120, 30));
        jLabel2.setForeground(Color.red);
        jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel2.setText("(yyyy-mm-dd)");
        jLabel2.setBounds(new Rectangle(164, 147, 120, 17));
        jLabel3.setForeground(Color.red);
        jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel3.setText("(yyyy-mm-dd)");
        jLabel3.setBounds(new Rectangle(167, 197, 121, 22));
        btnComput.setBackground(new Color(151, 255, 255));
        btnComput.setBounds(new Rectangle(177, 473, 100, 35));
        btnComput.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnComput.setForeground(Color.blue);
        btnComput.setText("");
        btnComput.addActionListener(new RegisterFrame_btnComput_actionAdapter(this));
        registPanel.add(txtName);
        registPanel.add(lblSex);
        this.getContentPane().add(roomPanel);
        roomPanel.add(txtStanPri);
        roomPanel.add(txtDebatePri);
        roomPanel.add(txtTotal);
        roomPanel.add(lblDebate);
        roomPanel.add(lbldebatePri);
        roomPanel.add(lblTotal);
        roomPanel.add(lblStanPri);
        roomPanel.add(lblRoomType);
        roomPanel.add(lblRoomNo);
        roomPanel.add(cboRoomNo);
        roomPanel.add(cboRoomType);
        roomPanel.add(txtCheckIn);
        roomPanel.add(lblCheckInDate);
        roomPanel.add(lblCheckOutDate);
        roomPanel.add(jLabel2);
        roomPanel.add(txtCheckOut);
        roomPanel.add(cboDepate);
        roomPanel.add(jLabel3);

        this.btnComput.setIcon(new ImageIcon ("image\\frame\\Registerfram\\comput.jpg"));
        this.btnConfri.setIcon(new ImageIcon("image\\frame\\Registerfram\\confir.jpg"));
        this.btnBack.setIcon(new ImageIcon("image\\frame\\Registerfram\\cancel.jpg"));

        this.getContentPane().add(registPanel);
        sexPanel.add(rdoMale, null);
        sexPanel.add(rdoFemale, null);
        registPanel.add(txtReason);
        registPanel.add(cboIDType);
        registPanel.add(lblIDType);
        registPanel.add(txtIDNo);
        registPanel.add(lblIDNo);
        registPanel.add(lblReason);
        registPanel.add(txtAccountNo);
        registPanel.add(lblAccuont);
        registPanel.add(lblOperater);
        registPanel.add(txtDeposit);
        registPanel.add(lnlDeposit);
        registPanel.add(txtOperater);
        this.getContentPane().add(lblTime);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(btnBack);
        this.getContentPane().add(btnConfri);
        this.getContentPane().add(btnComput);
        this.getContentPane().add(lblTitle);
        registPanel.add(lblName);
        registPanel.add(sexPanel);
        buttonGroup.add(rdoMale);