month = Integer.parseInt(NowTime.substring(5, NowTime.lastIndexOf("-")));
           day = Integer.parseInt(NowTime.substring(NowTime.lastIndexOf("-") + 1,
                                                    NowTime.length()));
           int Ryear, Rmonth, Rday;
           EndTime = txtRevertibleTime.getText();
           Ryear = Integer.parseInt(EndTime.substring(0, 4));
           Rmonth = Integer.parseInt(EndTime.substring(5, EndTime.lastIndexOf("-")));
           Rday = Integer.parseInt(EndTime.substring(NowTime.lastIndexOf("-") + 1,
                                                     EndTime.length()));
           System.out.println(year+"-"+month+"-"+day+"\n"+Ryear+"-"+Rmonth+"-"+Rday);
           if ((year > Ryear) || (year == Ryear && month > Rmonth) ||
               (year == Ryear && month == Rmonth && day > Rday)) {
               Isnot = true;
           }
           return Isnot;
       }
    //*****************************顯示窗口*********************************
     public void ShowReturnBook() {
         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.setModal(true);
         this.setVisible(true);
     }

    //***************************選擇圖書編號或條形碼***************************
     public void rbnLibId_stateChanged(ChangeEvent e) {
         if (rbnLibId.isSelected()) {
             Isnot = true;
             txtLibId.setEditable(true);
             txtLibId.setBackground(new java.awt.Color(255, 236, 125));
             txtBarCode.setText("");
             rbnLibId.setForeground(Color.magenta);
             txtBarCode.setBackground(Color.lightGray);
             txtBarCode.setEditable(false);
             rbnBarCode.setForeground(Color.BLACK);
         } else {
             Isnot = false;
             txtLibId.setText("");
             txtLibId.setBackground(Color.LIGHT_GRAY);
             txtLibId.setEditable(false);
             txtBarCode.setEditable(true);
             txtBarCode.setBackground(new java.awt.Color(255, 236, 125));
             rbnLibId.setForeground(Color.BLACK);
             rbnBarCode.setForeground(Color.magenta);
         }
     }

    //*****************************讀者確定按鈕事件*********************************
     public void btnOK_actionPerformed(ActionEvent e) {
         Vector vt = new Vector();
         Vector Readervt;
         ReaderConDB readerDB = new ReaderConDB();
         RecordConDB recordDB = new RecordConDB();
         if (txtReaId.getText().equals("")) {
             txtReaName.setText("");
             txtBorrowCount.setText("");
             txtLoanTime.setText("");
             txtRevertibleTime.setText("");
             JOptionPane.showMessageDialog(this, "請輸入讀者編號!");
         } else {
             vt = recordDB.SearchAlreadyRecord(txtReaId.getText());
             Readervt = readerDB.SearchLRReader(txtReaId.getText());
             readerDB.CloseReaderDB();
             recordDB.CloseRecordDB();
             if (Readervt.size() < 1) {
                 txtReaName.setText("");
                 txtBorrowCount.setText("");
                 txtLoanTime.setText("");
                 txtRevertibleTime.setText("");
                 JOptionPane.showMessageDialog(this, "輸入的讀者編號有誤!");
                 return;
             }
             dt = new DefaultTableModel(vt, vtColName);
             tblDisplay.setModel(dt);
             tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
             tblDisplay.getTableHeader().setReorderingAllowed(false);

             txtReaName.setText(((Reader) (Readervt.get(0))).getName());
             txtBorrowCount.setText(String.valueOf(((Reader) (Readervt.get(0))).
                     getBorrowCount()));
             if (vt.size() < 1) {
                 txtLoanTime.setText("");
                 txtRevertibleTime.setText("");
             } else {
                 txtLoanTime.setText(((Vector) (vt.get(0))).get(4).toString());
                 txtRevertibleTime.setText(((Vector) (vt.get(0))).get(6).
                                           toString());
             }
         }
     }

    //*********************************清空按鈕事件*****************************
     public void btnCancel_actionPerformed(ActionEvent e) {
         Vector nullvt = new Vector();
         dt = new DefaultTableModel(nullvt, vtColName);
         tblDisplay.setModel(dt);
         tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
         tblDisplay.getTableHeader().setReorderingAllowed(false);
         txtLibId.setText("");
         txtBarCode.setText("");
         txtReaId.setText("");
         txtLibName.setText("");
         txtAuthor.setText("");
         txtPublish.setText("");
         txtPage.setText("");
         txtPrice.setText("");
         txtReaName.setText("");
         txtBorrowCount.setText("");
         txtLoanTime.setText("");
         txtRevertibleTime.setText("");
     }

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

    //****************************還書按鈕事件**********************************
     public void btnReturn_actionPerformed(ActionEvent e) {
         Vector vt;
         Vector Readervt;
         Vector Bookvt = new Vector();
         Vector Recordvt = new Vector();
         ReaderConDB readerDB = new ReaderConDB();
         RecordConDB recordDB = new RecordConDB();
         BookConDB bookDB = new BookConDB();
         String LibId = txtLibId.getText();
         String BarCode = txtBarCode.getText();
         String ReaId = txtReaId.getText();
         if (LibId.equals("") && BarCode.equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入圖書編號或條形碼!");
             return;
         } else if (ReaId.equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入讀者編號!");
             return;
         } else {
             Bookvt = bookDB.SearchLRBook(LibId, BarCode, Isnot);
             Readervt = readerDB.SearchLRReader(ReaId);
             Recordvt = recordDB.SearchRecord(LibId, BarCode, ReaId);
             if (Bookvt.size() < 1) {
                 JOptionPane.showMessageDialog(this, "輸入的圖書編號或條形碼有誤!");
                 return;
             }
             if (Readervt.size() < 1) {
                 JOptionPane.showMessageDialog(this, "輸入的讀者編號有誤!");
                 return;
             }
             if (Recordvt.size() < 1) {
                 JOptionPane.showMessageDialog(this, "找不到相關記錄!");
                 return;
             }
             boolean IsOverdue;
             IsOverdue = IsnotOverdueBook();
             if(IsOverdue)
             {
                 JOptionPane.showMessageDialog(this, "該圖書已過期!");
             }
             bookDB.UpdateReturnBook(LibId, BarCode);
             readerDB.UpdateReturnBook(ReaId);
             recordDB.ReturnBookRecord(((Record) (Recordvt.get(0))).getId(),
                                       getNowTime());
             vt = recordDB.SearchAlreadyRecord(ReaId);

             readerDB.CloseReaderDB();
             bookDB.CloseBookDB();
             recordDB.CloseRecordDB();
             dt = new DefaultTableModel(vt, vtColName);
             tblDisplay.setModel(dt);
             tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
             tblDisplay.getTableHeader().setReorderingAllowed(false);
             JOptionPane.showMessageDialog(this, "還書成功!");
         }
     }

    //******************************圖書確定按鈕事件********************************
     public void btnLibOK_actionPerformed(ActionEvent e) {
         Vector vt;
         Vector Bookvt = new Vector();
         BookConDB bookDB = new BookConDB();
         if (txtLibId.getText().equals("") && txtBarCode.getText().equals("")) {
             txtLibName.setText("");
             txtAuthor.setText("");
             txtPublish.setText("");
             txtPage.setText("");
             txtPrice.setText("");
             JOptionPane.showMessageDialog(this, "請輸入圖書編號或條形碼!");
         } else {
             Bookvt = bookDB.SearchLRBook(txtLibId.getText(),
                                          txtBarCode.getText(),
                                          Isnot);
             bookDB.CloseBookDB();
             if (Bookvt.size() < 1) {
                 txtLibName.setText("");
                 txtAuthor.setText("");
                 txtPublish.setText("");
                 txtPage.setText("");
                 txtPrice.setText("");
                 JOptionPane.showMessageDialog(this, "輸入的圖書編號或條形碼有誤!");
             } else {
                 txtLibName.setText(((Book) (Bookvt.get(0))).getName());
                 txtAuthor.setText(((Book) (Bookvt.get(0))).getAuthor());
                 txtPublish.setText(((Book) (Bookvt.get(0))).getPublish());
                 txtPage.setText(((Book) (Bookvt.get(0))).getPage());
                 txtPrice.setText(((Book) (Bookvt.get(0))).getPrice());
             }
         }
     }
}


class dlgReturnBook_btnLibOK_actionAdapter implements ActionListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_btnLibOK_actionAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgReturnBook_btnReturn_actionAdapter implements ActionListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_btnReturn_actionAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgReturnBook_btnExit_actionAdapter implements ActionListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_btnExit_actionAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgReturnBook_btnCancel_actionAdapter implements ActionListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_btnCancel_actionAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgReturnBook_btnOK_actionAdapter implements ActionListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_btnOK_actionAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgReturnBook_rbnLibId_changeAdapter implements ChangeListener {
    private dlgReturnBook adaptee;
    dlgReturnBook_rbnLibId_changeAdapter(dlgReturnBook adaptee) {
        this.adaptee = adaptee;
    }

    public void stateChanged(ChangeEvent e) {
        adaptee.rbnLibId_stateChanged(e);
    }
}