frmuserupdate.java

用java实现的一个应用程序,源码非常完整,可以直接运行

         txtTel.setText("");
         txtAddress.setText("");
         txtRemark.setText("");
     }

    //**************************显示所有用户************************************
     public void DisplayAllUser() {
         UserConDB userDB = new UserConDB();
         vt = userDB.SearchAll();
         userDB.CloseUserDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
         txtId.setText(String.valueOf(tblDisplay.getValueAt(0, 0)));
         txtPassword.setText(String.valueOf(tblDisplay.getValueAt(0, 1)));
         txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(0, 2)));
         txtName.setText(String.valueOf(tblDisplay.getValueAt(0, 3)));
         txtSex.setText(String.valueOf(tblDisplay.getValueAt(0, 4)));
         txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(0, 5)));
         txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(0, 6)));
         txtTel.setText(String.valueOf(tblDisplay.getValueAt(0, 7)));
         txtAddress.setText(String.valueOf(tblDisplay.getValueAt(0, 8)));
         txtRemark.setText(String.valueOf(tblDisplay.getValueAt(0, 9)));
     }

    //*************************显示窗口*************************************
     public void ShowUserUpdate() {
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
         Dimension dlgSize = this.getSize();
         if (dlgSize.height > screenSize.height) {
             dlgSize.height = screenSize.height;
         }
         if (dlgSize.width > screenSize.width) {
             dlgSize.width = screenSize.width;
         }
         this.setLocation((screenSize.width - dlgSize.width) / 2,
                          (screenSize.height - dlgSize.height) / 2);
         this.setVisible(true);
     }

    //**************************表格根随窗口改变************************************
     public void this_componentResized(ComponentEvent e) {
         pnlUserMessage.setLocation((this.getWidth() - pnlUserMessage.getWidth()) /
                                    2, 0);
         jScrollPane1.setSize(this.getWidth() - 40,
                              this.getHeight() - pnlUserMessage.getHeight() -
                              70);
         tblDisplay.setSize(jScrollPane1.getWidth(), jScrollPane1.getHeight());
     }

    //***************************查询按钮事件***********************************
     public void btnSearch_actionPerformed(ActionEvent e) {
         UserConDB userDB = new UserConDB();
         if (rbnExactSearch.isSelected()) {
             isnot = true;
         } else {
             for (int i = 0; i < txtSearchContent.getText().length(); i++) {
                 if (String.valueOf(txtSearchContent.getText().charAt(i)).
                     equals(
                             "%")) {
                     JOptionPane.showMessageDialog(this, "模糊查询不能输入\"%\"!");
                     return;
                 }
             }
             isnot = false;
         }
         if (txtSearchContent.getText().equals("")) {
             Displaynull();
             JOptionPane.showMessageDialog(this, "请输入内容");
         } else {
             vt = userDB.SearchUser(txtSearchContent.getText(),
                                    cbbSearchSort.getSelectedItem().toString(),
                                    isnot);
             userDB.CloseUserDB();
             if (vt.size() < 1) {
                 Displaynull();
                 JOptionPane.showMessageDialog(this, "找不到记录!");
             } else {
                 dt = new DefaultTableModel(vt, vtColName);
                 tblDisplay.setModel(dt);
                 int row = tblDisplay.getSelectedRow();
                 if (row < 0) {
                     row++;
                 }
                 txtId.setText(String.valueOf(tblDisplay.getValueAt(row, 0)));
                 txtPassword.setText(String.valueOf(tblDisplay.getValueAt(row,
                         1)));
                 txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
                 txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 3)));
                 txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 4)));
                 txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row,
                         5)));
                 txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 6)));
                 txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 7)));
                 txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row, 8)));
                 txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 9)));
             }
         }
     }

    //**************************鼠标点击表格************************************
     public void tblDisplay_mouseClicked(MouseEvent e) {
         int row = tblDisplay.getSelectedRow();
         txtId.setText(String.valueOf(tblDisplay.getValueAt(row, 0)));
         txtPassword.setText(String.valueOf(tblDisplay.getValueAt(row, 1)));
         txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
         txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 3)));
         txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 4)));
         txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row, 5)));
         txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(row, 6)));
         txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 7)));
         txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row, 8)));
         txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 9)));
     }

    //**************************更新按钮事件************************************
     public void btnUpdate_actionPerformed(ActionEvent e) {
         String Id = txtId.getText();
         String Password = txtPassword.getText();
         String Popedom = txtPopedom.getText();
         String Name = txtName.getText();
         String Sex = txtSex.getText();
         String BirthTime = txtBirthTime.getText();
         String IdentityCard = txtIdentityCard.getText();
         String Tel = txtTel.getText();
         String Address = txtAddress.getText();
         String Remark = txtRemark.getText();
         if(Id.equals("")){
             JOptionPane.showMessageDialog(this, "请选择一个你要修改的用户!");
             return;
         }
         if (!(Popedom.equals("Super") || Popedom.equals("Admin") ||
               Popedom.equals("Common"))) {
             JOptionPane.showMessageDialog(this, "修改失败,输入权限错误!");
             return;
         }
         if (!(Sex.trim().equals("男") || Sex.trim().equals("女"))) {
             JOptionPane.showMessageDialog(this, "修改失败,输入性别错误!");
             return;
         }
         UserConDB userDB = new UserConDB();
         boolean Success = userDB.UpdateUser(Id, Password, Popedom, Name, Sex,
                                             BirthTime,
                                             IdentityCard, Tel, Address, Remark);
         if (!Success) {
             JOptionPane.showMessageDialog(this, "修改失败,请确认填内容是否含有特殊字符!");
             return;
         }
         JOptionPane.showMessageDialog(this, "修改成功");
         vt = userDB.SearchAll();
         userDB.CloseUserDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
     }

    //******************************清空按钮事件********************************
     public void btnCancel_actionPerformed(ActionEvent e) {
         txtSearchContent.setText("");
     }

    //*******************************退出按钮事件*******************************
     public void btnExit_actionPerformed(ActionEvent e) {
         this.dispose();
     }

    //*******************************删除按钮事件*******************************
     public void btnDelet_actionPerformed(ActionEvent e) {
         UserConDB userDB = new UserConDB();
         String usingId = userDB.SearchUsing().getId();
         if (txtId.getText().equals(usingId)) {
             JOptionPane.showMessageDialog(this, "用户正在使用,不能删除!");
         } else if(txtId.getText().equals("")){
             JOptionPane.showMessageDialog(this, "请选择你要删除的用户!");
         } else {
             userDB.DeleteUser(txtId.getText());
             JOptionPane.showMessageDialog(this, "成功删除");
             DisplayAllUser();
         }
     }
}


class frmUserUpdate_btnDelet_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnDelet_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnExit_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnExit_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnCancel_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnCancel_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnUpdate_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnUpdate_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_tblDisplay_mouseAdapter extends MouseAdapter {
    private frmUserUpdate adaptee;
    frmUserUpdate_tblDisplay_mouseAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tblDisplay_mouseClicked(e);
    }
}


class frmUserUpdate_btnSearch_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnSearch_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_this_componentAdapter extends ComponentAdapter {
    private frmUserUpdate adaptee;
    frmUserUpdate_this_componentAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.this_componentResized(e);
    }
}