package librarysystem;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.net.*;
import java.util.Vector;
import javax.swing.table.AbstractTableModel;
import baseclass.User;
import databaseoperate.DatabaseQuery;
import baseclass.Book;
import baseclass.Books;
import databaseoperate.DatabaseProcedure;
import baseclass.UserBook;
import baseclass.WarningFrame;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CounterFrame extends JFrame {
    Vector vector;                                         // 聲明一個向量對象
    Vector vec;
    AbstractTableModel tm;                                 // 聲明一個AbstractTableModel類對象tm
    AbstractTableModel tmm;
    String title[] = {"ISBN","索引","書名","作者","類型","出版社","出版時間","狀態(tài)","書架"};    // 二維表列名
    //String title[] = {"bookIndex","ISBN","bookState"};
    String titl[] = {"會員編號","姓名","書籍索引","書名","借出日期","借閱期限"};
    private JPanel contentPane;////////////////////////////以后恢復(fù)
    private JPanel content;
    String[] nn = {"","計算機(jī)", "文學(xué)","經(jīng)濟(jì)","生物","法學(xué)","天文","歷史","地理","管理"};

    public CounterFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        URL url=this.getClass().getResource("user.bmp");
        jLabel1.setIcon(new ImageIcon(url));
        contentPane = (JPanel) this.getContentPane();////////////////////////////以后恢復(fù)
        content = (JPanel) this.getContentPane();
        setTitle("Counter");
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(UIManager.getColor(
                "inactiveCaptionText"));
        setSize(new Dimension(1024, 768));
        jLabel1.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel1.setBounds(new Rectangle(39, 34, 189, 175));
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel3.setForeground(Color.blue);
        jLabel3.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel3.setText("     姓    名");
        jLabel3.setBounds(new Rectangle(272, 46, 130, 33));
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel4.setForeground(Color.blue);
        jLabel4.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel4.setText("     編    號");
        jLabel4.setBounds(new Rectangle(272, 87, 130, 34));
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel5.setForeground(Color.blue);
        jLabel5.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel5.setText("     性    別");
        jLabel5.setBounds(new Rectangle(272, 129, 130, 31));
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel6.setForeground(Color.blue);
        jLabel6.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel6.setText("     類    型");
        jLabel6.setBounds(new Rectangle(272, 174, 130, 30));
        jTextField1.setEnabled(true);
        jTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField1.setEditable(false);
        jTextField1.setText("");
        jTextField1.setBounds(new Rectangle(425, 46, 146, 33));
        jTextField2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField2.setEditable(false);
        jTextField2.setText("");
        jTextField2.setBounds(new Rectangle(425, 87, 146, 34));
        jTextField3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField3.setEditable(false);
        jTextField3.setBounds(new Rectangle(425, 129, 146, 31));
        jTextField4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField4.setEditable(false);
        jTextField4.setBounds(new Rectangle(425, 174, 146, 30));
        jLabel7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel7.setForeground(Color.blue);
        jLabel7.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel7.setText("      院  系");
        jLabel7.setBounds(new Rectangle(618, 46, 138, 33));
        jLabel8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel8.setForeground(Color.blue);
        jLabel8.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel8.setText("     E-MAIL");
        jLabel8.setBounds(new Rectangle(618, 87, 138, 34));
        jLabel9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel9.setForeground(Color.blue);
        jLabel9.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel9.setText("    可借本數(shù)");
        jLabel9.setBounds(new Rectangle(618, 129, 138, 31));
        jLabel10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel10.setForeground(Color.blue);
        jLabel10.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel10.setText("    已借本數(shù)");
        jLabel10.setBounds(new Rectangle(618, 174, 138, 30));
        jTextField6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        jTextField6.setEditable(false);
        jTextField6.setBounds(new Rectangle(785, 87, 160, 34));
        jTextField7.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField7.setEditable(false);
        jTextField7.setBounds(new Rectangle(785, 129, 160, 31));
        jTextField8.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField8.setEditable(false);
        jTextField8.setBounds(new Rectangle(785, 174, 160, 30));
        //jLabel11.setBorder(BorderFactory.createLoweredBevelBorder());
        //jLabel11.setText("");
        //jLabel11.setBounds(new Rectangle(39, 221, 939, 181));
        jLabel12.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel12.setBounds(new Rectangle(39, 370, 939, 140));
        jLabel13.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel13.setBounds(new Rectangle(40, 529, 939, 65));
        jLabel14.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
        jLabel14.setForeground(Color.green);
        jLabel14.setBorder(null);
        jLabel14.setText("用戶登錄");
        jLabel14.setBounds(new Rectangle(44, 541, 101, 25));
        jLabel15.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel15.setForeground(Color.blue);
        jLabel15.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel15.setText("  輸入ID號");
        jLabel15.setBounds(new Rectangle(154, 545, 114, 28));
        jTextField9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField9.setBounds(new Rectangle(293, 545, 163, 28));
        jLabel16.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel16.setForeground(Color.blue);
        jLabel16.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel16.setText("  輸入密碼");
        jLabel16.setBounds(new Rectangle(481, 545, 116, 28));
        jPasswordField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jPasswordField1.setBounds(new Rectangle(621, 545, 165, 28));
        jButton1.setBounds(new Rectangle(811, 545, 131, 28));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton1.setForeground(Color.magenta);
        jButton1.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton1.setText("  登  錄");
        jButton1.addActionListener(new CounterFrame_jButton1_actionAdapter(this));
        jLabel17.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel17.setBounds(new Rectangle(41, 606, 936, 108));
        jLabel18.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
        jLabel18.setForeground(Color.green);
        jLabel18.setText("借書還書");
        jLabel18.setBounds(new Rectangle(44, 613, 106, 33));
        jLabel19.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel19.setForeground(Color.blue);
        jLabel19.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel19.setToolTipText("");
        jLabel19.setText("書籍索引");
        jLabel19.setBounds(new Rectangle(154, 621, 87, 29));
        jTextField11.setBounds(new Rectangle(256, 620, 135, 29));
        jButton2.setBounds(new Rectangle(153, 667, 139, 31));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton2.setForeground(Color.red);
        jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton2.setText("  查  看");
        jButton2.addActionListener(new CounterFrame_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(349, 667, 139, 31));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton3.setForeground(Color.red);
        jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton3.setText("  借  書");
        jButton3.addActionListener(new CounterFrame_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(545, 667, 139, 31));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton4.setForeground(Color.red);
        jButton4.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton4.setText("  還  書");
        jButton4.addActionListener(new CounterFrame_jButton4_actionAdapter(this));
        jButton5.setBounds(new Rectangle(741, 667, 139, 31));
        jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton5.setForeground(Color.red);
        jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton5.setText("  刷  新");
        jButton5.addActionListener(new CounterFrame_jButton5_actionAdapter(this));
        jTextField12.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField12.setEditable(false);
        jTextField12.setBounds(new Rectangle(785, 48, 160, 30));
        jLabel20.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel20.setForeground(Color.blue);
        jLabel20.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel20.setText("  書    名");
        jLabel20.setBounds(new Rectangle(413, 620, 89, 29));
        jTextField13.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField13.setBounds(new Rectangle(517, 621, 124, 29));
        jLabel21.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel21.setForeground(Color.blue);
        jLabel21.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel21.setText("書籍類型");
        jLabel21.setBounds(new Rectangle(653, 621, 86, 29));
        jComboBox1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jComboBox1.setBounds(new Rectangle(757, 622, 143, 29));
        jLabel11.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
        jLabel11.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel11.setBounds(new Rectangle(39, 221, 939, 139));
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jLabel5);
        this.getContentPane().add(jLabel6);
        this.getContentPane().add(jTextField1);
        this.getContentPane().add(jTextField2);
        this.getContentPane().add(jTextField3);
        this.getContentPane().add(jTextField4);
        this.getContentPane().add(jLabel7);
        this.getContentPane().add(jLabel8);
        this.getContentPane().add(jLabel9);
        this.getContentPane().add(jLabel10);
        this.getContentPane().add(jTextField6);
        this.getContentPane().add(jTextField7);
        this.getContentPane().add(jTextField8);
        //this.getContentPane().add(jLabel11);
        this.getContentPane().add(jLabel12);
        this.getContentPane().add(jLabel13);
        this.getContentPane().add(jLabel14);
        this.getContentPane().add(jTextField9);
        this.getContentPane().add(jLabel16);
        this.getContentPane().add(jPasswordField1);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(jLabel17);
        this.getContentPane().add(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton5);
        this.getContentPane().add(jTextField12);
        this.getContentPane().add(jLabel18);
        this.getContentPane().add(jLabel19);
        this.getContentPane().add(jTextField11);
        this.getContentPane().add(jLabel20);
        this.getContentPane().add(jTextField13);
        this.getContentPane().add(jLabel21);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jLabel15);
        //content.add(jLabel11);
        jLabel2.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel2.setText("");
        jLabel2.setBounds(new Rectangle(247, 36, 732, 174));

        createtable();

        //createtable1();
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JLabel jLabel6 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JTextField jTextField2 = new JTextField();
    JTextField jTextField3 = new JTextField();
    JTextField jTextField4 = new JTextField();
    JLabel jLabel7 = new JLabel();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JLabel jLabel10 = new JLabel();
    JTextField jTextField5 = new JTextField();
    JTextField jTextField6 = new JTextField();
    JTextField jTextField7 = new JTextField();
    JTextField jTextField8 = new JTextField();
    //JLabel jLabel11 = new JLabel();
    JLabel jLabel12 = new JLabel();
    JLabel jLabel13 = new JLabel();
    JLabel jLabel14 = new JLabel();
    JLabel jLabel15 = new JLabel();
    JTextField jTextField9 = new JTextField();
    JLabel jLabel16 = new JLabel();
    JPasswordField jPasswordField1 = new JPasswordField();
    JButton jButton1 = new JButton();
    JLabel jLabel17 = new JLabel();
    JLabel jLabel18 = new JLabel();
    JLabel jLabel19 = new JLabel();
    JTextField jTextField11 = new JTextField();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();