JTable table,tab;                                       // 聲明一個JTable類對象table
    JScrollPane scroll,scr;                                 // 聲明一個滾動杠對象scroll
    vector = new Vector();                          //for information of books                          // 創建向量對象
    vec=new Vector();                               //for informaiton of user borrow book

    tm = new AbstractTableModel() {                  //for information of books    // 創建AbstractTableModel類對象tm
      public int getColumnCount() {                     // 取得表格列數
        return title.length;
      }
      public int getRowCount() {                        // 取得表格行數
        return vector.size();
      }
      public Object getValueAt(int row, int column) {   // 取得單元格中的屬性值
        if(!vector.isEmpty()) {
          return ((Vector)vector.elementAt(row)).elementAt(column);
        }
        else {
          return null;
        }
      }
      public void setValueAt(Object value, int row, int column) { // 數據模型不可編輯，該方法設置為空

      }
      public String getColumnName(int column) {         // 取得表格列名
        return title[column];
      }
      public Class getColumnClass(int c) {              // 取得列所屬對象類
        return getValueAt(0,c).getClass();
      }
      public boolean isCellEditable(int row, int column) {  // 設置單元格不可編輯，為缺省實現
        return false;
      }
    };



    tmm = new AbstractTableModel() {                     //for informaiton of user borrow book        // 創建AbstractTableModel類對象tm
      public int getColumnCount() {                     // 取得表格列數
        return titl.length;
      }
      public int getRowCount() {                        // 取得表格行數
        return vec.size();
      }
      public Object getValueAt(int row, int column) {   // 取得單元格中的屬性值
        if(!vec.isEmpty()) {
          return ((Vector)vec.elementAt(row)).elementAt(column);
        }
        else {
          return null;
        }
      }
      public void setValueAt(Object value, int row, int column) { // 數據模型不可編輯，該方法設置為空

      }
      public String getColumnName(int column) {         // 取得表格列名
        return titl[column];
      }
      public Class getColumnClass(int c) {              // 取得列所屬對象類
        return getValueAt(0,c).getClass();
      }
      public boolean isCellEditable(int row, int column) {  // 設置單元格不可編輯，為缺省實現
        return false;
      }
    };





    table = new JTable(tm);                               //for information of books    // 生成自己的數據模型
    table.setToolTipText("Display Query Result");         // 設置幫助提示
    //table.setAutoResizeMode(table.AUTO_RESIZE_OFF);       // 設置表格調整尺寸模式
    table.setCellSelectionEnabled(false);                 // 設置單元格選擇方式
    table.setShowHorizontalLines(true);                   // 設置是否顯示單元格之間的分割線
    table.setShowVerticalLines(true);
    scroll = new JScrollPane(table);                      // 給表格加上滾動杠
    scroll.setBounds(39, 372, 939, 117);
    contentPane.add(scroll);////////////////////////////以后恢復


    tab = new JTable(tmm);                               //for informaiton of user borrow book     // 生成自己的數據模型
    tab.setToolTipText("Display Query Result");         // 設置幫助提示
    //tab.setAutoResizeMode(table.AUTO_RESIZE_OFF);       // 設置表格調整尺寸模式
    tab.setCellSelectionEnabled(false);                 // 設置單元格選擇方式
    tab.setShowHorizontalLines(true);                   // 設置是否顯示單元格之間的分割線
    tab.setShowVerticalLines(true);
    scr = new JScrollPane(tab);                      // 給表格加上滾動杠
    scr.setBounds(39, 229, 939, 127);//39, 221, 939, 181
    content.add(scr);//////////39, 410, 939, 111//////////////////以后恢復
  }


    public void jButton1_actionPerformed(ActionEvent e) {
        User user=new User();
        user.setUserID(jTextField9.getText());
        user.setUserPWD(jTextField10.getText());
        if(DatabaseQuery.userListQueryForWhetherWright(user))
        {
            vec.removeAllElements();
            DatabaseQuery.userListQueryForInformation(user);
            jTextField1.setText(user.getUserName());
            jTextField2.setText(user.getUserID());
            jTextField3.setText(user.getUserSex());
            jTextField4.setText(user.getUserType());
            jTextField5.setText(user.getUserDept());
            jTextField6.setText(user.getUserEmail());
            jTextField7.setText(String.valueOf(user.getSumOfBook()));
            jTextField8.setText(String.valueOf(user.getNumOfBook()));
            DatabaseQuery.userBorrowViewQueryForInformation(user,vec);
            tmm.fireTableStructureChanged();
        }
    }

    public void jButton4_actionPerformed(ActionEvent e) {
        UserBook userBook=new UserBook();
        try{
            userBook.setUserID(jTextField9.getText());
            userBook.setUserPWD(jTextField10.getText());
            userBook.setBookIndex(Integer.parseInt(jTextField11.getText()));
        }
        catch(Exception eee)
        {
            WarningFrame.warningFrame("please input right!");
            return;
        }

        DatabaseProcedure.reborrowBook(userBook);
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        UserBook userBook=new UserBook();
        try
        {
            userBook.setUserID(jTextField9.getText());
            userBook.setUserPWD(jTextField10.getText());
            userBook.setBookIndex(Integer.parseInt(jTextField11.getText()));
        }
        catch(Exception eee)
        {
            WarningFrame.warningFrame("please input right!");
            return;
        }

        DatabaseProcedure.orderBook(userBook);
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        Books book=new Books();
        vector.removeAllElements();
        if(!jTextField11.getText().equals(""))
           {
               try{
               book.book.setBookIndex(Integer.parseInt(jTextField11.getText()));
               }
               catch(Exception ee)
               {
                   System.out.println(ee);
               }

               if(DatabaseQuery.bookInformationQueryForWhetherExistWithIndex(book))
                   {

                       DatabaseQuery.bookInformationQueryForInformationWithIndex(book, vector);


                       //tm.fireTableStructureChanged();                      // 更新表格內容
                       //vector.removeAllElements();
                   }
           }
           if(!bookNamejTextField.getText().equals(""))
           {
               book.setBookName(bookNamejTextField.getText());
               if(DatabaseQuery.bookInformationQueryForWhetherExistWithName(book))
               {

                   DatabaseQuery.bookInformationQueryForInformationWithName(book, vector);

              }

          }
          if(!String.valueOf(jComboBox1.getSelectedItem()).equals(""))
          {
              book.setBookType(String.valueOf(jComboBox1.getSelectedItem()));
              System.out.println(book.getBookType());//book.setBookName(jTextField13.getText());
              if(DatabaseQuery.bookInformationQueryForWhetherExistWithType(book))
              {
                  DatabaseQuery.bookInformationQueryForInformationWithType(book, vector);

              }
          }
          if(vector.size()==0)
          {
              WarningFrame.warningFrame("please input one item you want!");
          }
          else
          {
              tm.fireTableStructureChanged();
          }
      }

      public void jButton5_actionPerformed(ActionEvent e) {
        jTextField1.setText("");
        jTextField2.setText("");
        jTextField3.setText("");
        jTextField4.setText("");
        jTextField5.setText("");
        jTextField6.setText("");
        jTextField7.setText("");
        jTextField8.setText("");
        jTextField9.setText("");
        jTextField10.setText("");
        jTextField11.setText("");
        bookNamejTextField.setText("");
        vec.removeAllElements();
        vector.removeAllElements();
        tmm.fireTableStructureChanged();
        tm.fireTableStructureChanged();
    }

    public void userBorrowInformationjButton_actionPerformed(ActionEvent e) {
        User user=new User();
        user.setUserID(jTextField9.getText());
        user.setUserPWD(jTextField10.getText());
        if(DatabaseQuery.userListQueryForWhetherWright(user))
        {
            vec.removeAllElements();
            DatabaseQuery.userBorrowViewQueryForInformation(user,vec);
            tmm.fireTableStructureChanged();
        }

    }

    public void userOrderInformationjButton_actionPerformed(ActionEvent e) {
        User user=new User();
        user.setUserID(jTextField9.getText());
        user.setUserPWD(jTextField10.getText());
        if(DatabaseQuery.userListQueryForWhetherWright(user))
        {
            vec.removeAllElements();
            DatabaseQuery.userOrderViewQueryForInformation(user,vec);
            tmm.fireTableStructureChanged();
        }

    }
}


class UserFrame_userOrderInformationjButton_actionAdapter implements
        ActionListener {
    private UserFrame adaptee;
    UserFrame_userOrderInformationjButton_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_userBorrowInformationjButton_actionAdapter implements
        ActionListener {
    private UserFrame adaptee;
    UserFrame_userBorrowInformationjButton_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_jButton2_actionAdapter implements ActionListener {
    private UserFrame adaptee;
    UserFrame_jButton2_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_jButton3_actionAdapter implements ActionListener {
    private UserFrame adaptee;
    UserFrame_jButton3_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_jButton4_actionAdapter implements ActionListener {
    private UserFrame adaptee;
    UserFrame_jButton4_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_jButton1_actionAdapter implements ActionListener {
    private UserFrame adaptee;
    UserFrame_jButton1_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class UserFrame_jButton5_actionAdapter implements ActionListener {
    private UserFrame adaptee;
    UserFrame_jButton5_actionAdapter(UserFrame adaptee) {
        this.adaptee = adaptee;
    }

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