employeeframe.java

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

        String upadte = "update employee set id = '" + employee.getId() +
                        "',name = '" + employee.getName()
                        + "',age = '" + employee.getAge() + "',address = '" +
                        employee.getAdress() + "',phone = '" +
                        employee.getPhone()
                        + "',title = '" + employee.getTitle() + "',remark = '" +
                        employee.getRemark() + "' where id = '"
                        + this.txtsqlRs.getText() + "'";

        if (dbo.updateNoReturn(upadte)) {
            JOptionPane.showMessageDialog(this, "保存成功！！");
        } else {
            JOptionPane.showMessageDialog(this, "保存失败！！请重新修改信息并保存！！");

        }

    }


    //注册新员工退出按钮
    public void btnExitRs_actionPerformed(ActionEvent e) {
        this.dispose();
    }


    //离职面版的确认离职按钮事件
    public void btnQueryD_actionPerformed(ActionEvent e) {

        if (this.txtSqlIDD.getText().equals("")) {
            JOptionPane.showMessageDialog(this, "请输入要查询的员工ID号！！");
            return;
        }
        String sql = "select * from employee where id = '" +
                     this.txtSqlIDD.getText() + "'";
        ResultSet rst = dbo.returnQuery(sql);
        String info = "该员工信息如下：\n";
        try {
            if (rst.next()) {

                info += "ID号："+rst.getString(1) +"\n";
                info += "姓名："+rst.getString(2) +"\n";
                info += "性别："+rst.getString(3) +"\n";
                info += "民族："+rst.getString(4) +"\n";
                info += "年龄："+rst.getInt(5) +"\n";
                info += "身份证号："+rst.getString(6) +"\n";
                info += "籍贯："+rst.getString(7) +"\n";
                info += "住址："+rst.getString(8) +"\n";
                info += "联系电话："+rst.getString(9) +"\n";
                info += "职务："+rst.getString(10) +"\n";
                info += "备注："+rst.getString(11) +"\n";
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
      //使用文本域显示信息
        this.txtShowD.setText(info);

    }


    //员工离职确认事件
    public void btnDelD_actionPerformed(ActionEvent e) {

    if(this.txtShowD.getText().equals(""))
    {
        JOptionPane.showMessageDialog(this,"请输入准备离职人员的员工ID号！！");
        return;
    }
        Object[] op ={"确认","取消"};
        int confir = JOptionPane.showOptionDialog(this,"确认该员工离职吗？","确认",JOptionPane.OK_CANCEL_OPTION,JOptionPane.QUESTION_MESSAGE,null,op,"确认");
         if(confir == 0)
         {
             String del = "delete from employee where id = '"+this.txtSqlIDD.getText()+"'" ;
             if(dbo.updateNoReturn(del))
             {
                 JOptionPane.showMessageDialog(this,"离职信息已提交！！离职成功！！");
                 this.txtShowD.setText("");
                 this.txtSqlIDD.setText("");
                 this.txtSqlIDD.requestFocus();
             }
             else
             {
                 JOptionPane.showMessageDialog(this,"离职信息未提交成功！！离职失败！！");
             }
         }
         if(confir==1)
         {
             return;
         }
    }

    //离职面板的退出按钮
    public void btnExitD_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void txtSqlIDD_actionPerformed(ActionEvent e) {
        btnDelD_actionPerformed(e);
    }

    public void txtsqlRs_actionPerformed(ActionEvent e) {
          btnsqlRs_actionPerformed(e) ;
    }

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


}


class EmployeeFrame_btnQExit_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnQExit_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_txtsqlRs_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_txtsqlRs_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_txtSqlIDD_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_txtSqlIDD_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.txtSqlIDD_actionPerformed(e);
    }
}


class EmployeeFrame_txtSql_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_txtSql_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnExitD_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnExitD_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnDelD_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnDelD_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.btnDelD_actionPerformed(e);
    }
}


class EmployeeFrame_btnQueryD_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnQueryD_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnExitRs_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnExitRs_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnSaveRs_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnSaveRs_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnsqlRs_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnsqlRs_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnExit_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnExit_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnReg_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnReg_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnSql_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnSql_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnDel_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnDel_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnReset_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnReset_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnRegist_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnRegist_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class EmployeeFrame_btnQuery_actionAdapter implements ActionListener {
    private EmployeeFrame adaptee;
    EmployeeFrame_btnQuery_actionAdapter(EmployeeFrame adaptee) {
        this.adaptee = adaptee;
    }

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