txtIdentityCard.setText("");
         txtTel.setText("");
         txtLoanableNum.setText("");
         txtAlreadyNum.setText("");
         txtTransactTime.setText("");
         txtEndTime.setText("");
         txtBorrowCount.setText("");
         txtAddress.setText("");
         txtRemark.setText("");
     }

    //******************************顯示所有讀者********************************
     public void DisplayAllReader() {
         ReaderConDB readerDB = new ReaderConDB();
         vt = readerDB.SearchAll();
         readerDB.CloseReaderDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
         txtId.setText(String.valueOf(tblDisplay.getValueAt(0, 0)));
         txtName.setText(String.valueOf(tblDisplay.getValueAt(0, 1)));
         txtSex.setText(String.valueOf(tblDisplay.getValueAt(0, 2)));
         txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(0, 3)));
         txtVocation.setText(String.valueOf(tblDisplay.getValueAt(0, 4)));
         txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(0, 5)));
         txtTel.setText(String.valueOf(tblDisplay.getValueAt(0, 6)));
         txtLoanableNum.setText(String.valueOf(tblDisplay.getValueAt(0, 7)));
         txtAlreadyNum.setText(String.valueOf(tblDisplay.getValueAt(0, 8)));
         txtTransactTime.setText(String.valueOf(tblDisplay.getValueAt(0, 9)));
         txtEndTime.setText(String.valueOf(tblDisplay.getValueAt(0, 10)));
         txtBorrowCount.setText(String.valueOf(tblDisplay.getValueAt(0, 11)));
         txtAddress.setText(String.valueOf(tblDisplay.getValueAt(0, 12)));
         txtRemark.setText(String.valueOf(tblDisplay.getValueAt(0, 13)));
     }

    //**************************顯示窗口************************************
     public void ShowReaUpdate() {
         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) {
         pnlReaMessage.setLocation((this.getWidth() - pnlReaMessage.getWidth()) /
                                   2, 0);
         jScrollPane1.setSize(this.getWidth() - 30,
                              this.getHeight() - pnlReaMessage.getHeight() - 85);
         tblDisplay.setSize(jScrollPane1.getWidth(), jScrollPane1.getHeight());
     }

    //******************************查詢按鈕事件********************************
     public void btnSearch_actionPerformed(ActionEvent e) {
         ReaderConDB readerDB = new ReaderConDB();
         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(null, "模糊查詢不能含有特殊符號\"%\"!");
                     return;
                 }
             }
             Isnot = false;
         }
         if (txtSearchContent.getText().equals("")) {
             Displaynull();
             JOptionPane.showMessageDialog(this, "請輸入內容");
         } else {
             vt = readerDB.SearchUpdateReader(txtSearchContent.getText(),
                                              cbbSearchSort.getSelectedItem().
                                              toString(), Isnot);
             readerDB.CloseReaderDB();
             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)));
                 txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 1)));
                 txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
                 txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row,
                         3)));
                 txtVocation.setText(String.valueOf(tblDisplay.getValueAt(row,
                         4)));
                 txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 5)));
                 txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 6)));
                 txtLoanableNum.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 7)));
                 txtAlreadyNum.setText(String.valueOf(tblDisplay.getValueAt(row,
                         8)));
                 txtTransactTime.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 9)));
                 txtEndTime.setText(String.valueOf(tblDisplay.getValueAt(row,
                         10)));
                 txtBorrowCount.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 11)));
                 txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row,
                         12)));
                 txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 13)));
             }
         }
     }

    //******************************鼠標點擊表格********************************
     public void tblDisplay_mouseClicked(MouseEvent e) {
         int row = tblDisplay.getSelectedRow();
         txtId.setText(String.valueOf(tblDisplay.getValueAt(row, 0)));
         txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 1)));
         txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
         txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row, 3)));
         txtVocation.setText(String.valueOf(tblDisplay.getValueAt(row, 4)));
         txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(row, 5)));
         txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 6)));
         txtLoanableNum.setText(String.valueOf(tblDisplay.getValueAt(row, 7)));
         txtAlreadyNum.setText(String.valueOf(tblDisplay.getValueAt(row, 8)));
         txtTransactTime.setText(String.valueOf(tblDisplay.getValueAt(row, 9)));
         txtEndTime.setText(String.valueOf(tblDisplay.getValueAt(row, 10)));
         txtBorrowCount.setText(String.valueOf(tblDisplay.getValueAt(row, 11)));
         txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row, 12)));
         txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 13)));
     }

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

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

    //**************************更新按鈕事件************************************
     public void btnUpdate_actionPerformed(ActionEvent e) {
         String Id = txtId.getText();
         String Name = txtName.getText();
         String Sex = txtSex.getText();
         String BirthTime = txtBirthTime.getText();
         String Vocation = txtVocation.getText();
         String IdentityCard = txtIdentityCard.getText();
         String Tel = txtTel.getText();
         String LoanableNum = txtLoanableNum.getText();
         String AlreadyNum = txtAlreadyNum.getText();
         String TransactTime = txtTransactTime.getText();
         String EndTime = txtEndTime.getText();
         String BorrowCount = txtBorrowCount.getText();
         String Address = txtAddress.getText();
         String Remark = txtRemark.getText();
         ReaderConDB readerDB = new ReaderConDB();
         boolean Success = readerDB.UpdateReader(Id, Name, Sex, BirthTime,
                                                 Vocation, IdentityCard, Tel,
                                                 LoanableNum, AlreadyNum,
                                                 TransactTime, EndTime,
                                                 BorrowCount, Address, Remark);
         if (!Success) {
             JOptionPane.showMessageDialog(this, "修改失敗,請檢查填寫內容是否正確或含有特殊符號!");
             return;
         }
         vt = readerDB.SearchAll();
         readerDB.CloseReaderDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
         JOptionPane.showMessageDialog(this, "修改成功");
     }

    //**************************刪除按鈕事件************************************
     public void btnDelete_actionPerformed(ActionEvent e) {
         int AlreadyNum = Integer.parseInt(txtAlreadyNum.getText());
         if (AlreadyNum > 0) {
             JOptionPane.showMessageDialog(this, "讀者未還書,不能刪除!");
         } else {
             ReaderConDB readerDB = new ReaderConDB();
             readerDB.DeleteReader(txtId.getText());
             readerDB.CloseReaderDB();
             DisplayAllReader();
             JOptionPane.showMessageDialog(this, "成功刪除");
         }
     }
}


class frmReaUpdate_btnDelete_actionAdapter implements ActionListener {
    private frmReaUpdate adaptee;
    frmReaUpdate_btnDelete_actionAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_btnExit_actionAdapter implements ActionListener {
    private frmReaUpdate adaptee;
    frmReaUpdate_btnExit_actionAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_btnUpdate_actionAdapter implements ActionListener {
    private frmReaUpdate adaptee;
    frmReaUpdate_btnUpdate_actionAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_btnCancel_actionAdapter implements ActionListener {
    private frmReaUpdate adaptee;
    frmReaUpdate_btnCancel_actionAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_tblDisplay_mouseAdapter extends MouseAdapter {
    private frmReaUpdate adaptee;
    frmReaUpdate_tblDisplay_mouseAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_btnSearch_actionAdapter implements ActionListener {
    private frmReaUpdate adaptee;
    frmReaUpdate_btnSearch_actionAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmReaUpdate_this_componentAdapter extends ComponentAdapter {
    private frmReaUpdate adaptee;
    frmReaUpdate_this_componentAdapter(frmReaUpdate adaptee) {
        this.adaptee = adaptee;
    }

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