JButton jButton5 = new JButton();
    JTextField jTextField12 = new JTextField();
    JLabel jLabel20 = new JLabel();
    JTextField jTextField13 = new JTextField();
    JLabel jLabel21 = new JLabel();
    JComboBox jComboBox1 = new JComboBox(nn);
    JLabel jLabel11 = new JLabel();


    void createtable() {                                  // 定義createtable()函數
    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, 370, 939, 140);
    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, 221, 939, 139);//39, 221, 939, 181
    content.add(scr);//////////39, 410, 939, 111//////////////////以后恢復*/
  }



    public void jButton1_actionPerformed(ActionEvent e) {
        vec.removeAllElements();
        User user=new User();
        user.setUserID(jTextField9.getText());
        user.setUserPWD(jTextField10.getText());
        if(DatabaseQuery.userListQueryForWhetherWright(user))
        {
            DatabaseQuery.userListQueryForInformation(user);
            jTextField1.setText(user.getUserName());
            jTextField2.setText(user.getUserID());
            jTextField3.setText(user.getUserSex());
            jTextField4.setText(user.getUserType());
            jTextField12.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 jButton2_actionPerformed(ActionEvent e) {
        //Vector vector=new Vector();
        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(!jTextField13.getText().equals(""))
        {
            book.setBookName(jTextField13.getText());
            if(DatabaseQuery.bookInformationQueryForWhetherExistWithName(book))
            {

                DatabaseQuery.bookInformationQueryForInformationWithName(book, vector);


                //tm.fireTableStructureChanged();                      // 更新表格內容
                        //vector.removeAllElements();
            }

        }
        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);
                //tm.fireTableStructureChanged();                      // 更新表格內容
                //vector.removeAllElements();
            }
        }
        if(vector.size()==0)
        {
            WarningFrame.warningFrame("please input one item you want!");
        }
        else
        {
            tm.fireTableStructureChanged();                      // 更新表格內容
        }

    }

    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.borrowBook(userBook);
    }

    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.returnBook(userBook,0);

    }

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


class CounterFrame_jButton4_actionAdapter implements ActionListener {
    private CounterFrame adaptee;
    CounterFrame_jButton4_actionAdapter(CounterFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class CounterFrame_jButton3_actionAdapter implements ActionListener {
    private CounterFrame adaptee;
    CounterFrame_jButton3_actionAdapter(CounterFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class CounterFrame_jButton2_actionAdapter implements ActionListener {
    private CounterFrame adaptee;
    CounterFrame_jButton2_actionAdapter(CounterFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {

        adaptee.jButton2_actionPerformed(e);
    }
}


class CounterFrame_jButton1_actionAdapter implements ActionListener {
    private CounterFrame adaptee;
    CounterFrame_jButton1_actionAdapter(CounterFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class CounterFrame_jButton5_actionAdapter implements ActionListener {
    private CounterFrame adaptee;
    CounterFrame_jButton5_actionAdapter(CounterFrame adaptee) {
        this.adaptee = adaptee;
    }

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