txtSex.setText("");
         txtBirthTime.setText("");
         txtIdentityCard.setText("");
         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, "請輸入內(nèi)容");
         } 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)));
             }
         }
     }

    //**************************鼠標(biāo)點擊表格************************************
     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();
         UserConDB userDB = new UserConDB();
         if (!(Popedom.equals("Super") || Popedom.equals("Admin") ||
               Popedom.equals("Common"))) {
             JOptionPane.showMessageDialog(this, "修改失敗,輸入權(quán)限錯誤!");
             return;
         }
         if (!(Sex.equals("男") || Sex.equals("女"))) {
             JOptionPane.showMessageDialog(this, "修改失敗,輸入性別錯誤!");
             return;
         }
         boolean Success = userDB.UpdateUser(Id, Password, Popedom, Name, Sex,
                                             BirthTime,
                                             IdentityCard, Tel, Address, Remark);
         if (!Success) {
             JOptionPane.showMessageDialog(this, "修改失敗,請確認(rèn)填內(nèi)容是否含有特殊字符!");
             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 {
             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);
    }
}