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.util.Vector;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.*;
import java.net.*;
import baseclass.User;
import databaseoperate.DatabaseQuery;
import baseclass.UserBook;
import databaseoperate.DatabaseProcedure;
import baseclass.WarningFrame;
import baseclass.Books;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class UserFrame extends JFrame {

    /////////////////////////////////////////////////////
    Vector vector;                                         // 聲明一個(gè)向量對(duì)象
    Vector vec;
    AbstractTableModel tm;                                 // 聲明一個(gè)AbstractTableModel類對(duì)象tm
    AbstractTableModel tmm;
    String title[] = {"ISBN","索引","書名","作者","類型","出版社","出版時(shí)間","狀態(tài)","書架"};    // 二維表列名
    //String title[] = {"bookIndex","ISBN","bookState"};
    String titl[] = {"會(huì)員編號(hào)","姓名","書籍索引","書名","借出日期","借閱期限"};
    private JPanel contentPane;////////////////////////////以后恢復(fù)
    private JPanel content;////////////////////////////以后恢復(fù)
    String[] bookType = {"","計(jì)算機(jī)", "文學(xué)","經(jīng)濟(jì)","生物","法學(xué)","天文","歷史","地理","管理"};


    /////////////////////////////////////////////////////////////////


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

    private void jbInit() throws Exception {
        setTitle("USER");
        URL url = this.getClass().getResource("D:/librarySystem/LibrarySystem/classes/librarysystem/user2.jpg");
        jLabel1.setIcon(new ImageIcon(url));
        //contentPane = (JPanel) this.getContentPane();
        contentPane = (JPanel) this.getContentPane();////////////////////////////以后恢復(fù)
        content = (JPanel) this.getContentPane();////////////////////////////以后恢復(fù)


        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("     編    號(hào)");
        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));
        jTextField5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField5.setEditable(false);
        jTextField5.setBounds(new Rectangle(785, 46, 160, 33));
        jTextField6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 10));
        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, 229, 939, 127));
        jLabel12.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel12.setBounds(new Rectangle(39, 372, 939, 117));
        jLabel13.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel13.setBounds(new Rectangle(40, 503, 937, 92));
        jLabel14.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
        jLabel14.setForeground(Color.green);
        jLabel14.setBorder(null);
        jLabel14.setText("用戶登錄");
        jLabel14.setBounds(new Rectangle(44, 516, 101, 25));
        jLabel15.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jLabel15.setForeground(Color.blue);
        jLabel15.setBorder(BorderFactory.createRaisedBevelBorder());
        jLabel15.setText("  輸入ID號(hào)");
        jLabel15.setBounds(new Rectangle(153, 515, 114, 30));
        jTextField9.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField9.setBounds(new Rectangle(277, 517, 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(459, 519, 116, 27));
        jTextField10.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jTextField10.setBounds(new Rectangle(589, 519, 165, 27));
        jButton1.setBounds(new Rectangle(811, 521, 131, 31));
        jButton1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton1.setForeground(Color.magenta);
        jButton1.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton1.setText("  登  錄");
        jButton1.addActionListener(new UserFrame_jButton1_actionAdapter(this));
        jLabel17.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel17.setBounds(new Rectangle(41, 608, 934, 108));
        jLabel18.setFont(new java.awt.Font("Dialog", Font.PLAIN, 25));
        jLabel18.setForeground(Color.green);
        jLabel18.setText("書籍查詢");
        jLabel18.setBounds(new Rectangle(44, 615, 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(165, 618, 87, 29));
        jTextField11.setBounds(new Rectangle(278, 619, 105, 29));
        jButton2.setBounds(new Rectangle(161, 665, 131, 32));
        jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton2.setForeground(Color.red);
        jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton2.setText("  查  詢");
        jButton2.addActionListener(new UserFrame_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(349, 665, 131, 32));
        jButton3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton3.setForeground(Color.red);
        jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton3.setText("  預(yù)  約");
        jButton3.addActionListener(new UserFrame_jButton3_actionAdapter(this));
        jButton4.setBounds(new Rectangle(545, 665, 131, 32));
        jButton4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton4.setForeground(Color.red);
        jButton4.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton4.setText("  續(xù)  借");
        jButton4.addActionListener(new UserFrame_jButton4_actionAdapter(this));
        jButton5.setBounds(new Rectangle(741, 665, 131, 32));
        jButton5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jButton5.setForeground(Color.red);
        jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
        jButton5.setText("  刷  新");
        jButton5.addActionListener(new UserFrame_jButton5_actionAdapter(this));
        bookName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        bookName.setForeground(Color.blue);
        bookName.setBorder(BorderFactory.createRaisedBevelBorder());
        bookName.setText("書籍名字");
        bookName.setBounds(new Rectangle(410, 618, 87, 29));
        bookNamejTextField.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        bookNamejTextField.setText("");
        bookNamejTextField.setBounds(new Rectangle(523, 618, 117, 29));
        bookTypejLabel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        bookTypejLabel.setForeground(Color.blue);
        bookTypejLabel.setBorder(BorderFactory.createRaisedBevelBorder());
        bookTypejLabel.setText("書籍類型");
        bookTypejLabel.setBounds(new Rectangle(667, 619, 86, 29));
        jComboBox1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        jComboBox1.setBounds(new Rectangle(779, 619, 139, 29));
        userBorrowInformationjButton.setBounds(new Rectangle(153, 555, 111, 28));
        userBorrowInformationjButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        userBorrowInformationjButton.setForeground(Color.magenta);
        userBorrowInformationjButton.setBorder(BorderFactory.createRaisedBevelBorder());
        userBorrowInformationjButton.setText("借閱信息");
        userBorrowInformationjButton.addActionListener(new
                UserFrame_userBorrowInformationjButton_actionAdapter(this));
        userOrderInformationjButton.setBounds(new Rectangle(294, 555, 111, 28));
        userOrderInformationjButton.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        userOrderInformationjButton.setForeground(Color.magenta);
        userOrderInformationjButton.setBorder(BorderFactory.createRaisedBevelBorder());
        userOrderInformationjButton.setText("預(yù)約信息");
        userOrderInformationjButton.addActionListener(new
                UserFrame_userOrderInformationjButton_actionAdapter(this));
        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(jTextField5);
        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(jButton2);
        this.getContentPane().add(jButton3);
        this.getContentPane().add(jButton4);
        this.getContentPane().add(jButton5);
        this.getContentPane().add(jLabel17);
        this.getContentPane().add(jLabel18);
        this.getContentPane().add(jLabel19);
        this.getContentPane().add(jTextField11);
        this.getContentPane().add(bookName);
        this.getContentPane().add(bookNamejTextField);
        this.getContentPane().add(bookTypejLabel);
        this.getContentPane().add(jComboBox1);
        this.getContentPane().add(jLabel15);
        this.getContentPane().add(jLabel14);
        this.getContentPane().add(jTextField9);
        this.getContentPane().add(jLabel16);
        this.getContentPane().add(jTextField10);
        this.getContentPane().add(jButton1);
        this.getContentPane().add(userBorrowInformationjButton);
        this.getContentPane().add(userOrderInformationjButton);
        jLabel2.setBorder(BorderFactory.createLoweredBevelBorder());
        jLabel2.setText("");
        jLabel2.setBounds(new Rectangle(247, 36, 732, 174));
        //////////////////////////////////////////////////////////
        //////////////////////////////////////////////////////////
        createtable();
        //////////////////////////////////////////////////////////
    }

    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();
    JTextField jTextField10 = new JTextField();
    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();
    JLabel bookName = new JLabel();
    JTextField bookNamejTextField = new JTextField();
    JLabel bookTypejLabel = new JLabel();
    JComboBox jComboBox1 = new JComboBox(bookType);
    JButton userBorrowInformationjButton = new JButton();
    JButton userOrderInformationjButton = new JButton();


    void createtable() {                                  // 定義createtable()函數(shù)