txtName.setText("");
        txtSex.setText("");
        txtBirthTime.setText("");
        txtVocation.setText("");
        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);
    }
}