ondutyframe.java

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

        asDutyPan.add(txtATitle);
        asDutyPan.add(txtAName);
        asDutyPan.add(lblAproseeding);
        asDutyPan.add(lblAFloor);
        asDutyPan.add(lblAOndutyNo);
        asDutyPan.add(lblAstatus);
        asDutyPan.add(lblATitle);
        asDutyPan.add(cboEmIDNO);
        asDutyPan.add(lblAemIDNO);
        assignPan.add(btnASql);
        assignPan.add(btnAReset);
        assignPan.add(btnOK);
        assignPan.add(asDutyPan);
        Pan1.add(txtTime);
        Pan1.add(txtOndutyNo);
        Pan1.add(txtTitle);
        Pan1.add(txtOnduty);
        Pan1.add(txtFloor);
        Pan1.add(txtProceeding);
        Pan1.add(lblOndutyNo);
        Pan1.add(lblProceeding);
        Pan1.add(lblFloor);
        Pan1.add(lblonDuty);
        Pan1.add(txtName);
        Pan1.add(lblTime);
        Pan1.add(lbLTitile);
        Pan1.add(lblNama);
        sqlPan.add(btnQuery);
        sqlPan.add(btnSave);
        sqlPan.add(lblTip);
        sqlPan.add(lblPicture);
        sqlPan.add(Pan2);
        Pan2.add(txtPhone);
        Pan2.add(lblPhone);
        Pan2.add(lblRemark);
        Pan2.add(txtRemark);
        sqlPan.add(SpinnerDate);
        sqlPan.add(Pan1);
        this.getContentPane().add(lblTitle);
        this.getContentPane().add(toolBar);
        this.getContentPane().add(dutyPan);
        dbo = new DBOperatorBean();
        isEnable();
        addItem();
    }

    JLabel lblTitle = new JLabel();
    JToolBar toolBar = new JToolBar();
    JButton btnSql = new JButton();
    JButton btnAssgin = new JButton();
    JPanel dutyPan = new JPanel();
    CardLayout cardLayout1 = new CardLayout();
    JPanel sqlPan = new JPanel();
    JPanel assignPan = new JPanel();
    JButton btnOK = new JButton();
    JButton btnQuery = new JButton();
    SpinnerModel smd = new SpinnerDateModel();
    JButton btnExit = new JButton();
    SpinnerModel Spinmodel;
    JSpinner SpinnerDate;

    JLabel lblTip = new JLabel();
    JTextField txtName = new JTextField();
    JLabel lblNama = new JLabel();
    JLabel lbLTitile = new JLabel();
    JPanel Pan1 = new JPanel();
    JTextField txtTitle = new JTextField();
    JTextField txtFloor = new JTextField();
    JTextField txtOndutyNo = new JTextField();
    JLabel lblOndutyNo = new JLabel();
    JLabel lblFloor = new JLabel();
    JLabel lblProceeding = new JLabel();
    JLabel lblPhone = new JLabel();
    JTextField txtProceeding = new JTextField();
    JTextField txtPhone = new JTextField();
    JTextField txtRemark = new JTextField();
    JLabel lblRemark = new JLabel();
    JLabel lblPicture = new JLabel();
    JLabel lblTime = new JLabel();
    JTextField txtTime = new JTextField();
    DBOperatorBean dbo;
    ResultSet rs = null;
    OnDutyBean onduty;
    JPanel Pan2 = new JPanel();
    JLabel lblonDuty = new JLabel();
    JTextField txtOnduty = new JTextField();
    JPanel asDutyPan = new JPanel();
    JLabel lblATitle = new JLabel();
    JLabel lblAstatus = new JLabel();
    JTextField txtAStatue = new JTextField();
    JTextField txtAPhone = new JTextField();
    JTextField txtARemark = new JTextField();
    JTextField txtAOndutyNo = new JTextField();
    JLabel lblAproseeding = new JLabel();
    JTextField txtAName = new JTextField();
    JTextField txtAproseeding = new JTextField();
    JLabel lblARemark = new JLabel();
    JLabel lblAPhone = new JLabel();
    JLabel lblANow = new JLabel();
    JTextField txtAFloor = new JTextField();
    JLabel lblAFloor = new JLabel();
    JTextField txtATitle = new JTextField();
    JLabel lblAOndutyNo = new JLabel();
    JLabel lblAName = new JLabel();
    SpinnerModel ASpinmodel;
    JSpinner ASpinner;
    JButton btnAReset = new JButton();
    JLabel lblP2 = new JLabel();
    JButton btnSave = new JButton();
    ImageIcon i1 = new ImageIcon("image\\img3\\3009.jpg");
    ImageIcon i2 = new ImageIcon("image\\img3\\3004.jpg");

    LoginFrame login = new LoginFrame();
    JComboBox cboEmIDNO = new JComboBox();
    JLabel lblAemIDNO = new JLabel();
   static  int countFloor = 1;
    JButton btnASql = new JButton();
    //得到值班员工ID号
    public void addItem() {
        String sql =
                "select * from employee where id like 'sh3%' or Id like 'sh4%'";
        rs = dbo.returnQuery(sql);

        try {
            while (rs.next()) {
                this.cboEmIDNO.addItem(rs.getString(1));
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }


    public void isEnable() {
        if (login.manager.equals("经营管理员") || login.manager.equals("系统管理员")) {
            this.btnAssgin.setEnabled(true);
        }
    }

    public void btnQuery_actionPerformed(ActionEvent e) {

        String d = this.SpinnerDate.getValue().toString();

        String year = d.substring(24, 28);
        //JOptionPane.showMessageDialog(this, year);
        String date = d.substring(8, 11);
        // JOptionPane.showMessageDialog(this, date);
        String month = d.substring(4, 7);
        //JOptionPane.showMessageDialog(this, month);
        /* Jan Feb  Mar Apr May  Jun Jul Aug Sep  Oct  Nov Dec
         */
        String monthNum = "";
        if (month.equals("Jan")) {
            monthNum = "01";
        }
        if (month.equals("Feb")) {
            monthNum = "02";
        }
        if (month.equals("Mar")) {
            monthNum = "03";
        }
        if (month.equals("Apr")) {
            monthNum = "04";
        }
        if (month.equals("May")) {
            monthNum = "05";
        }
        if (month.equals("Jun")) {
            monthNum = "06";
        }
        if (month.equals("Jul")) {
            monthNum = "07";
        }
        if (month.equals("Aug")) {
            monthNum = "08";
        }
        if (month.equals("Sep")) {
            monthNum = "09";
        }
        if (month.equals("Oct")) {
            monthNum = "10";
        }
        if (month.equals("Nov")) {
            monthNum = "11";
        }
        if (month.equals("Dec")) {
            monthNum = "12";
        }

        String sqlDate = year + "-" + monthNum + "-" + date;
        // String sqlDate = getDate();
        //  JOptionPane.showMessageDialog(this, sqlDate);
        onduty = new OnDutyBean();
        try {
            String sql = "select * from  onduty where ondate = '" + sqlDate +
                         "'";
            rs = dbo.returnQuery(sql);
            if (rs.next()) {
                onduty.setOndate(rs.getString(1).substring(0, 10));
                onduty.setName(rs.getString(2));
                onduty.setOnDutyNo(rs.getInt(3));
                onduty.setODuty(rs.getString(4));
                onduty.setTitle(rs.getString(5));
                onduty.setFloorNo(rs.getInt(6));
                onduty.setProcceding(rs.getString(7));
                onduty.setPhone(rs.getString(8));
                onduty.setRemark(rs.getString(9));
            } else {
                JOptionPane.showMessageDialog(this, "没有找到相关数据！！请重新查询！！");
                this.txtTime.setText("");
                this.txtName.setText("");
                this.txtOndutyNo.setText("");
                this.txtOnduty.setText("");
                this.txtTitle.setText("");
                this.txtFloor.setText("");
                this.txtProceeding.setText("");
                this.txtPhone.setText("");
                this.txtRemark.setText("");
                return;
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }

        this.txtTime.setText(onduty.getOndate());
        this.txtName.setText(onduty.getName());
        this.txtOndutyNo.setText("" + onduty.getOnDutyNo());
        this.txtOnduty.setText(onduty.getODuty());
        this.txtTitle.setText(onduty.getTitle());
        this.txtFloor.setText("" + onduty.getFloorNo());
        this.txtProceeding.setText(onduty.getProcceding());
        this.txtPhone.setText(onduty.getPhone());
        this.txtRemark.setText(onduty.getRemark());

    }

    public void 查询值班_actionPerformed(ActionEvent e) {
        this.sqlPan.setVisible(true);
        this.assignPan.setVisible(false);
    }

    public void 安排值班_actionPerformed(ActionEvent e) {
        this.sqlPan.setVisible(false);
        this.assignPan.setVisible(true);
    }

    public void btnExit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnOK_actionPerformed(ActionEvent e) {

        if (this.txtAName.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "姓名不能为空！！请重新输入！！");
            this.txtAName.requestFocus();
            return;
        }
        if (this.txtATitle.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "员工职务不能为空！！请重新输入！！");
            this.txtATitle.requestFocus();
            return;
        }

        if (this.txtAStatue.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "状态不能为空！！请重新输入！！");
            this.txtAStatue.requestFocus();
            return;
        }

        if (this.txtAFloor.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "搂层号不能为空！！请重新输入！！");
            this.txtAFloor.requestFocus();
            return;
        }
        if (this.txtAproseeding.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "负责事项不能为空！！请重新输入！！");
            this.txtAproseeding.requestFocus();
            return;
        }