ondutyframe.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 entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;
import entity.OnDutyBean;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import rummery.LoginFrame;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

/**
 * <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 OnDutyFrame extends JFrame {
    public OnDutyFrame() {
        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.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("员 工 值 班 信 息");
        lblTitle.setBounds(new Rectangle(197, 1, 306, 52));
        toolBar.setBackground(new Color(212, 230, 255));
        toolBar.setBorder(BorderFactory.createEtchedBorder());
        toolBar.setBounds(new Rectangle(43, 58, 398, 42));
        btnSql.setBackground(new Color(212, 255, 255));
        btnSql.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnSql.setForeground(Color.blue);
        btnSql.setText("");
        btnSql.addActionListener(new OnDutyFrame_查询值班_actionAdapter(this));
        btnAssgin.setBackground(new Color(212, 255, 255));
        btnAssgin.setEnabled(false);
        btnAssgin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAssgin.setForeground(Color.blue);
        btnAssgin.setText("");
        btnAssgin.addActionListener(new OnDutyFrame_安排值班_actionAdapter(this));
        dutyPan.setBorder(BorderFactory.createEtchedBorder());
        dutyPan.setBounds(new Rectangle(42, 101, 621, 393));
        dutyPan.setLayout(cardLayout1);
        sqlPan.setLayout(null);
        assignPan.setBackground(new Color(212, 240, 255));
        assignPan.setInputVerifier(null);
        assignPan.setLayout(null);
        btnOK.setBackground(new Color(217, 243, 255));
        btnOK.setBounds(new Rectangle(266, 353, 100, 30));
        btnOK.setForeground(Color.blue);
        btnOK.setText("");
        btnOK.addActionListener(new OnDutyFrame_btnOK_actionAdapter(this));
        btnQuery.setBackground(new Color(212, 240, 255));
        btnQuery.setBounds(new Rectangle(323, 22, 100, 30));
        btnQuery.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnQuery.setForeground(Color.blue);

        btnQuery.setText("");
        btnQuery.addActionListener(new OnDutyFrame_btnQuery_actionAdapter(this));
        btnExit.setBackground(new Color(212, 255, 255));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setForeground(Color.blue);
        btnExit.setText("");
        btnExit.addActionListener(new OnDutyFrame_btnExit_actionAdapter(this));
        lblTip.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTip.setText("请选择查询日期");
        lblTip.setBounds(new Rectangle(25, 23, 115, 30));
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtName.setText("");
        txtName.setBounds(new Rectangle(113, 56, 130, 30));
        lblNama.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblNama.setText("员工姓名");
        lblNama.setBounds(new Rectangle(10, 55, 100, 30));
        lbLTitile.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbLTitile.setText("员工职务");
        lbLTitile.setBounds(new Rectangle(8, 88, 100, 30));
        Pan1.setBackground(new Color(212, 225, 255));
        Pan1.setBorder(BorderFactory.createEtchedBorder());
        Pan1.setBounds(new Rectangle(26, 59, 270, 310));
        Pan1.setLayout(null);
        txtTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTitle.setText("");
        txtTitle.setBounds(new Rectangle(114, 93, 130, 30));

        txtFloor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtFloor.setText("");
        txtFloor.setBounds(new Rectangle(114, 205, 130, 30));
        txtOndutyNo.setBackground(new Color(255, 235, 255));
        txtOndutyNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtOndutyNo.setEditable(false);
        txtOndutyNo.setText("");
        txtOndutyNo.setBounds(new Rectangle(114, 130, 130, 30));

        lblOndutyNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblOndutyNo.setText("*值班编号");
        lblOndutyNo.setBounds(new Rectangle(8, 129, 100, 30));
        lblFloor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblFloor.setText("值班楼层");
        lblFloor.setBounds(new Rectangle(8, 204, 100, 30));
        lblProceeding.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblProceeding.setText("负责事项");
        lblProceeding.setBounds(new Rectangle(8, 242, 96, 30));
        lblPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblPhone.setText("联系电话");
        lblPhone.setBounds(new Rectangle(17, 28, 100, 30));
        txtProceeding.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtProceeding.setText("");
        txtProceeding.setBounds(new Rectangle(114, 245, 130, 30));
        txtPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtPhone.setText("");
        txtPhone.setBounds(new Rectangle(123, 22, 130, 30));
        txtRemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtRemark.setText("");
        txtRemark.setBounds(new Rectangle(123, 58, 130, 30));
        lblRemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblRemark.setText("备注");
        lblRemark.setBounds(new Rectangle(22, 60, 99, 30));
        lblPicture.setBorder(BorderFactory.createEtchedBorder());
        lblPicture.setText("");
        lblPicture.setBounds(new Rectangle(324, 58, 270, 170));
        this.lblPicture.setIcon(i1);
        lblTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTime.setText("*当前日期");
        lblTime.setBounds(new Rectangle(7, 20, 100, 30));
        txtTime.setBackground(new Color(255, 235, 255));
        txtTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTime.setEditable(false);
        txtTime.setText("");
        txtTime.setBounds(new Rectangle(114, 19, 130, 30));
        Pan2.setBackground(new Color(212, 225, 255));
        Pan2.setBorder(BorderFactory.createEtchedBorder());
        Pan2.setBounds(new Rectangle(323, 247, 268, 116));
        Pan2.setLayout(null);
        lblonDuty.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblonDuty.setText("值班状态");
        lblonDuty.setBounds(new Rectangle(8, 166, 100, 32));
        txtOnduty.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtOnduty.setText("");
        txtOnduty.setBounds(new Rectangle(114, 167, 130, 30));
        asDutyPan.setBackground(new Color(212, 230, 255));
        asDutyPan.setBorder(BorderFactory.createEtchedBorder());
        asDutyPan.setBounds(new Rectangle(31, 23, 556, 319));
        asDutyPan.setLayout(null);
        lblATitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblATitle.setText("*员工职务");
        lblATitle.setBounds(new Rectangle(20, 124, 80, 30));
        lblAstatus.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAstatus.setText("*值班状态");
        lblAstatus.setBounds(new Rectangle(20, 202, 80, 32));
        txtAStatue.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAStatue.setDoubleBuffered(true);
        txtAStatue.setBounds(new Rectangle(115, 200, 130, 30));
        txtAPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAPhone.setBounds(new Rectangle(403, 33, 130, 30));
        txtARemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtARemark.setBounds(new Rectangle(403, 68, 130, 30));
        txtAOndutyNo.setBackground(new Color(255, 240, 255));
        txtAOndutyNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAOndutyNo.setEditable(false);
        txtAOndutyNo.setBounds(new Rectangle(116, 163, 130, 30));
        lblAproseeding.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAproseeding.setText("*负责事项");
        lblAproseeding.setBounds(new Rectangle(24, 278, 80, 30));
        txtAName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAName.setEditable(false);
        txtAName.setBounds(new Rectangle(115, 89, 130, 30));
        txtAproseeding.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAproseeding.setBounds(new Rectangle(115, 278, 130, 30));
        lblARemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblARemark.setText("备注");
        lblARemark.setBounds(new Rectangle(307, 68, 80, 30));
        lblAPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAPhone.setText("联系电话");
        lblAPhone.setBounds(new Rectangle(307, 35, 80, 30));
        lblANow.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblANow.setText("当前日期");
        lblANow.setBounds(new Rectangle(25, 7, 80, 30));
        txtAFloor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAFloor.setBounds(new Rectangle(115, 238, 130, 30));
        lblAFloor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAFloor.setText("*值班楼层");
        lblAFloor.setBounds(new Rectangle(20, 240, 80, 30));
        txtATitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtATitle.setEditable(false);
        txtATitle.setBounds(new Rectangle(115, 126, 130, 30));
        lblAOndutyNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAOndutyNo.setText("值班编号");
        lblAOndutyNo.setBounds(new Rectangle(20, 165, 80, 30));
        lblAName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAName.setText("*员工姓名");
        lblAName.setBounds(new Rectangle(20, 91, 80, 30));
        ASpinmodel = new SpinnerDateModel();
        ASpinner = new JSpinner(ASpinmodel);
        ASpinner.setBounds(new Rectangle(117, 7, 130, 30));
        btnAReset.setBackground(new Color(212, 236, 255));

        btnAReset.setBounds(new Rectangle(404, 353, 100, 30));
        btnAReset.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAReset.setForeground(Color.blue);

        btnAReset.setText("");
        btnAReset.addActionListener(new OnDutyFrame_btnAReset_actionAdapter(this));
        lblP2.setBorder(BorderFactory.createEtchedBorder());
        lblP2.setText("");
        lblP2.setBounds(new Rectangle(307, 112, 230, 180));
        this.lblP2.setIcon(i2);
        btnSave.setBackground(new Color(212, 240, 255));
        btnSave.setBounds(new Rectangle(456, 21, 100, 30));
        btnSave.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnSave.setForeground(Color.blue);
        btnSave.setText("");
        btnSave.addActionListener(new OnDutyFrame_btnSave_actionAdapter(this));
        this.getContentPane().setBackground(new Color(212, 255, 255));
        this.setResizable(false);
        this.setTitle("员工值班信息");
        sqlPan.setBackground(new Color(212, 240, 255));
        cboEmIDNO.setBounds(new Rectangle(117, 50, 128, 30));


        lblAemIDNO.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAemIDNO.setText("员工ID号");
        lblAemIDNO.setBounds(new Rectangle(22, 48, 80, 30));
        btnASql.setBackground(new Color(212, 240, 255));
        btnASql.setBounds(new Rectangle(134, 353, 99, 30));
        btnASql.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnASql.setForeground(Color.blue);
        btnASql.setText("");
        btnASql.addActionListener(new OnDutyFrame_btnASql_actionAdapter(this));
        dutyPan.add(sqlPan, "jPanel1");
        dutyPan.add(assignPan, "jPanel2");

        this.btnAssgin.setIcon(new ImageIcon("image\\onduty\\assiginOnduty.jpg"));
        this.btnSql.setIcon(new ImageIcon("image\\onduty\\ondutySql.jpg"));
        this.btnExit.setIcon(new ImageIcon("image\\onduty\\exit.jpg"));
        this.btnAReset.setIcon(new ImageIcon("image\\onduty\\reset.jpg"));
        this.btnOK.setIcon(new ImageIcon("image\\onduty\\OK.jpg"));
        this.btnQuery.setIcon(new ImageIcon("image\\onduty\\query.jpg"));
        this.btnSave.setIcon(new ImageIcon("image\\onduty\\saveReset.jpg"));
        this.btnASql.setIcon(new ImageIcon("image\\onduty\\query.jpg"));
        toolBar.add(btnSql);
        toolBar.add(btnAssgin);
        toolBar.add(btnExit);
        Spinmodel = new SpinnerDateModel();
        SpinnerDate = new JSpinner(Spinmodel);
        SpinnerDate.setBounds(new Rectangle(153, 23, 140, 30));
//    JOptionPane.showMessageDialog(this,
//                                      "" + SpinnerData.getValue().toString());
        asDutyPan.add(txtAPhone);
        asDutyPan.add(txtARemark);
        asDutyPan.add(lblARemark);
        asDutyPan.add(lblAPhone);
        asDutyPan.add(lblP2);
        asDutyPan.add(lblANow);
        asDutyPan.add(ASpinner);
        asDutyPan.add(lblAName);
        asDutyPan.add(txtAproseeding);
        asDutyPan.add(txtAFloor);
        asDutyPan.add(txtAStatue);
        asDutyPan.add(txtAOndutyNo);