employeemanagepanel.java

自己做的超市管理系统

             } catch (Exception ee) {
             } finally {
                 try {
                     ds.closed();
                 } catch (Exception ex) {

                 }
             }
         // EmployeeTablePanel a=new EmployeeTablePanel();
         //a.setVisible(true);
     }
    public void btnQAgain_actionPerformed(ActionEvent e) {
        txtQId.setText(null);
    }

    public void btnRConfirm_actionPerformed(ActionEvent e) {
       try{
           int i = 0;
            rs = ds.GetRs("select * from employeeinfo");
            while (rs.next()) {
                if (txtRId.getText().toString().equals(rs.getString(1).toString())) {
                    i++;
                    break;
                }
            }
           if(txtRId.getText().length()==0)
           {
               JOptionPane.showMessageDialog(this, "您没有输入员工的编号");
           } else if (i==0) {
               JOptionPane.showMessageDialog(this, "您输入的员工编号不存在，请重新输入！");
               txtRId.setText(null);
           } else if (txtRDuty.getText().length() == 0) {
               JOptionPane.showMessageDialog(this, "您没有输入员工的职务");
           } else if (txtRWage.getText().length() == 0) {
               JOptionPane.showMessageDialog(this, "您没有输入员工的工资");
           } else if (isNum(txtRWage.getText().toString()) <
                      txtRWage.getText().length()) {
               JOptionPane.showMessageDialog(this, "员工的工资必须是数字，请重新输入！");
               txtRWage.setText(null);
           } else {
               if (txtRAddress.getText().length() != 0) {
                   String strSql = "update EmployeeInfo set Dwelling='"
                                   + txtRAddress.getText() + "'where Id='" +
                                   txtRId.getText() + "'";
                   ds.ResultSql(strSql);
               }
               if (txtRTouch.getText().length() != 0) {
                   String strSql = "update EmployeeInfo set ConnectMode='"
                                   + txtRTouch.getText() + "'where Id='" +
                                   txtRId.getText() + "'";
                   ds.ResultSql(strSql);
               }
               if (txtRremark.getText().length() != 0) {
                   String strSql = "update EmployeeInfo set Remark='"
                                   + txtRremark.getText() + "'where Id='" +
                                   txtRId.getText() + "'";
                   ds.ResultSql(strSql);
               }

               String strSql = "update EmployeeInfo set Duty='" +
                               txtRDuty.getText() +
                               "',Wage='" + Float.valueOf(txtRWage.getText()) +
                               "' where Id='" + txtRId.getText()+ "'";
               ds.ResultSql(strSql);
               JOptionPane.showMessageDialog(this,"更改成功");
               String str = "select * from EmployeeInfo where Id='" +
                  this.txtRId.getText().toString() + "'";
            rs = ds.GetRs(str);
            vc.removeAllElements();
           //更新表格内容
           tm.fireTableStructureChanged();
           while (rs.next()) {
               Vector rec_vector = new Vector();
               //从结果集中取数据放入向量rec_vector中
               rec_vector.addElement(rs.getString(1));
               rec_vector.addElement(rs.getString(2));
               rec_vector.addElement(rs.getString(3));
               rec_vector.addElement(rs.getString(4));
               rec_vector.addElement(rs.getString(5));
               rec_vector.addElement(rs.getString(6));
               rec_vector.addElement(rs.getString(7));
               rec_vector.addElement(rs.getString(8));
               rec_vector.addElement(rs.getString(9));
               //向量rec_vector加入向量vect中
               vc.addElement(rec_vector);

           }
           //更新表格，显示向量vect的内容
           tm.fireTableStructureChanged();
           pnlRejigger.setVisible(false);
           queryFile.setVisible(true);
           txtRId.setText(null);
           txtRDuty.setText(null);
           txtRWage.setText(null);
           txtRAddress.setText(null);
           txtRTouch.setText(null);
           txtRremark.setText(null);
           }
        }catch(Exception ee){
       }
       finally
       {
           try{
              ds.closed();
             }catch(Exception ee){
             }
       }
    }

    public void btnRAgian_actionPerformed(ActionEvent e) {
        txtRId.setText(null);
        txtRDuty.setText(null);
        txtRWage.setText(null);
    }

    public void btnDConfirm_actionPerformed(ActionEvent e) {
        try {
            int i=0;
            rs=ds.GetRs("select * from employeeinfo");
            while (rs.next()) {
                if (txtDId.getText().toString().equals(rs.getString(1).toString())) {
                    i++;
                    break;
                }
            }
            if(txtDId.getText().length()==0)
            {
                JOptionPane.showMessageDialog(this,"您没有输入要删除员工的编号，请重新输入！");
            }
            else if (i == 0) {
                JOptionPane.showMessageDialog(this, "您输入的员工编号不存在，请重新输入");
                txtDId.setText(null);
            } else {
                String strSql = "delete from EmployeeInfo where Id='" +
                                txtDId.getText() + "'";
                rs = ds.GetRs(strSql);
                JOptionPane.showMessageDialog(this, "删除成功");
                txtDId.setText(null);
            }
        } catch (Exception ee) {
        } finally
        {
            try {
                 ds.closed();
            } catch (Exception ee) {
            }
        }
    }
    public void btnDAgian_actionPerformed(ActionEvent e) {
        txtDId.setText(null);
    }


    class EmployeeManagePanel_btnDAgian_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnDAgian_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnDConfirm_actionAdapter implements
            ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnDConfirm_actionAdapter(EmployeeManagePanel
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnRAgian_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnRAgian_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnRConfirm_actionAdapter implements
            ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnRConfirm_actionAdapter(EmployeeManagePanel
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnQAgain_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnQAgain_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnQConfirm_actionAdapter implements
            ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnQConfirm_actionAdapter(EmployeeManagePanel
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnAagain_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnAagain_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnAConfirm_actionAdapter implements
            ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnAConfirm_actionAdapter(EmployeeManagePanel
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnExit_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnExit_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnDelete_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnDelete_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnRejigger_actionAdapter implements
            ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnRejigger_actionAdapter(EmployeeManagePanel
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnAppend_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnAppend_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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


    class EmployeeManagePanel_btnQuery_actionAdapter implements ActionListener {
        private EmployeeManagePanel adaptee;
        EmployeeManagePanel_btnQuery_actionAdapter(EmployeeManagePanel adaptee) {
            this.adaptee = adaptee;
        }

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