ondutyframe.java

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

        String date = getDate();
        String name = this.txtAName.getText();
        String ondutyNo = this.txtAOndutyNo.getText();
        String status = this.txtAStatue.getText();
        String title = this.txtATitle.getText();
        String floorNo = this.txtAFloor.getText();
        String proceeding = this.txtAproseeding.getText();
        String phone = this.txtAPhone.getText();
        String remark = this.txtARemark.getText();

        String sql = "select * from onduty where ondate = '" + date + "'";
       // JOptionPane.showMessageDialog(this, sql);
        try {
            rs = dbo.returnQuery(sql);
            if (rs.next()) {
                JOptionPane.showMessageDialog(this, "该日期值班人员已经安排！！，请重新安排其它日期！！");
                return;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        }

        String insert = " insert into onduty values ('" + date + "','" + name +
                        "','" + status + "','"
                        + title + "','" + floorNo + "','" + proceeding + "','" +
                        phone + "','" + remark + "')";
        if (dbo.updateNoReturn(insert)) {
            JOptionPane.showMessageDialog(this, "安排成功！！");

        } else {
            JOptionPane.showMessageDialog(this, "安排失败！！请重新安排值班人员！！");

        }
        //insert into onduty values ('2007-08-21','部长1','否','经理','1','检查工作','13030002656','')
    }

    public void btnAReset_actionPerformed(ActionEvent e) {

        this.txtAName.setText("");
        this.txtAName.requestFocus();
        this.txtAOndutyNo.setText("");
        this.txtAStatue.setText("");
        this.txtATitle.setText("");
        this.txtAFloor.setText("");
        this.txtAproseeding.setText("");
        this.txtAPhone.setText("");
        this.txtARemark.setText("");
    }

    public void btnSave_actionPerformed(ActionEvent e) {

        if (this.txtName.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "姓名不能为空！！，请重新保存修改！！");
            this.txtName.requestFocus();
            return;
        }
        if (this.txtFloor.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "楼层号不能为空！！，请重新保存修改！！");
            this.txtFloor.requestFocus();
            return;
        }
        if (this.txtOnduty.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "值班状态不能为空！！，请重新保存修改！！");
            this.txtOnduty.requestFocus();
            return;
        }
        if (this.txtProceeding.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "负责事项不能为空！！，请重新保存修改！！");
            this.txtProceeding.requestFocus();
            return;
        }

        //this.txtTime.getText();
        String name = this.txtName.getText();
        String ondutyNo = this.txtOndutyNo.getText();
        String onduty = this.txtOnduty.getText();
        String title = this.txtTitle.getText();
        String floor = this.txtFloor.getText();
        String proseeding = this.txtProceeding.getText();
        String phone = this.txtPhone.getText();
        String remark = this.txtRemark.getText();
        String update = "update onduty set name='" + name + "',onduty = '" +
                        onduty + "',title='" + title + "',floorNO = '"
                        + floor + "',proceeding='" + proseeding + "',phone ='" +
                        phone + "',remark= '" + remark + "' where ondutyNo = '" +
                        ondutyNo + "'";
        if (dbo.updateNoReturn(update)) {
            JOptionPane.showMessageDialog(this, "保存修改成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "保存修改失败！！请重新保存！！");
        }

    }


    public String getDate() {
        String d = this.ASpinner.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;
        return sqlDate;

    }



    public void btnASql_actionPerformed(ActionEvent e) {

        String ID = this.cboEmIDNO.getSelectedItem().toString();
        String sql = "select * from employee where id = '" + ID + "'";

        rs = dbo.returnQuery(sql);

        try {
            if (rs.next()) {
                this.txtAName.setText(rs.getString(2));
                this.txtATitle.setText(rs.getString(10));
                this.txtAStatue.setText("0");
                this.txtAFloor.setText(""+countFloor);
                countFloor++;
                if(countFloor ==4)
                {
                    countFloor=1;
                }


            }
        } catch (SQLException ex) {
        }



    }


}


class OnDutyFrame_btnASql_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnASql_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnASql_actionPerformed(e);
    }
}




class OnDutyFrame_btnSave_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnSave_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSave_actionPerformed(e);
    }
}


class OnDutyFrame_btnAReset_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnAReset_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnAReset_actionPerformed(e);
    }
}


class OnDutyFrame_btnOK_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnOK_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnOK_actionPerformed(e);
    }
}


class OnDutyFrame_btnExit_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnExit_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}


class OnDutyFrame_安排值班_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_安排值班_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.安排值班_actionPerformed(e);
    }
}


class OnDutyFrame_查询值班_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_查询值班_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.查询值班_actionPerformed(e);
    }
}


class OnDutyFrame_btnQuery_actionAdapter implements ActionListener {
    private OnDutyFrame adaptee;
    OnDutyFrame_btnQuery_actionAdapter(OnDutyFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnQuery_actionPerformed(e);
    }
}