package 畢業(yè)設(shè)計(jì);

import java.awt.*;
import java.util.Vector;
import javax.swing.*;
import javax.swing.JTable;
import javax.swing.border.TitledBorder;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.DefaultTableModel;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.util.*;

public class frmLibSearch extends JFrame {
    JLabel lblId = new JLabel();
    JTextField txtId = new JTextField();
    JLabel lblBarCode = new JLabel();
    JTextField txtBarCode = new JTextField();
    JLabel lblName = new JLabel();
    JTextField txtName = new JTextField();
    JLabel lblAuthor = new JLabel();
    JTextField txtAuthor = new JTextField();
    JLabel lblSynopsis = new JLabel();
    JLabel lblPublish = new JLabel();
    JLabel lblPrice = new JLabel();
    JLabel lblSort = new JLabel();
    JLabel lblIntoTime = new JLabel();
    JLabel lblLocation = new JLabel();
    JTextField txtPrice = new JTextField();
    JTextField txtIntoTime = new JTextField();
    JLabel lblIsbn = new JLabel();
    JTextField txtIsbn = new JTextField();
    JTextField txtLocation = new JTextField();
    JButton btnSearch = new JButton();
    JButton btnCancel = new JButton();
    JButton btnExit = new JButton();
    JLabel lblLine = new JLabel();
    JLabel lblPage = new JLabel();
    JTextField txtPage = new JTextField();
    JLabel lblSearchId = new JLabel();
    JTextField txtSearchId = new JTextField();
    JLabel lblSearchBarCode = new JLabel();
    JTextField txtSearchBarCode = new JTextField();
    JLabel lblSearchName = new JLabel();
    JTextField txtSearchName = new JTextField();
    JLabel lblSearchAuthor = new JLabel();
    JTextField txtSearchAuthor = new JTextField();
    JLabel lblSearchPublish = new JLabel();
    JTextField txtSearchPublish = new JTextField();
    JLabel lblSearchSort = new JLabel();
    JTextField txtSearchSort = new JTextField();
    JRadioButton rbnExactSearch = new JRadioButton();
    JRadioButton rbnBlurrySearch = new JRadioButton();
    JTextField txtPublish = new JTextField();
    JTextField txtSort = new JTextField();
    JLabel lblIsin = new JLabel();
    JTextField txtIsin = new JTextField();
    JTextArea txtSynopsis = new JTextArea();
    JPanel pnlLibMessage = new JPanel();
    JTable tblDisplay = new JTable();
    JLabel lblDisplay = new JLabel();
    JLabel lblBorrowCount = new JLabel();
    JTextField txtLoanCount = new JTextField();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    boolean isnot;
    String[] column = {"編號(hào)", "條形碼", "名稱", "作者", "頁(yè)數(shù)", "出版社", "價(jià)格", "ISBN",
                      "類別", "入庫(kù)時(shí)間", "存放位置", "是否在庫(kù)", "借出次數(shù)", "簡(jiǎn)介"};
    JScrollPane jScrollPane1 = new JScrollPane();
    public frmLibSearch() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(800, 600));
        this.setTitle("圖書查詢");
        this.addComponentListener(new frmLibSearch_this_componentAdapter(this));
        lblId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblId.setText("編      號(hào):");
        lblId.setBounds(new Rectangle(334, 23, 56, 24));
        txtId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtId.setEditable(false);
        txtId.setBounds(new Rectangle(391, 24, 156, 24));
        lblBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblBarCode.setText("條 形 碼:");
        lblBarCode.setBounds(new Rectangle(334, 56, 51, 23));
        txtBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtBarCode.setEditable(false);
        txtBarCode.setText("");
        txtBarCode.setBounds(new Rectangle(392, 54, 156, 23));
        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtName.setEditable(false);
        txtName.setText("");
        txtName.setBounds(new Rectangle(393, 86, 155, 26));
        lblAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblAuthor.setText("作     者:");
        lblAuthor.setBounds(new Rectangle(332, 115, 51, 24));
        txtAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtAuthor.setEditable(false);
        txtAuthor.setText("");
        txtAuthor.setBounds(new Rectangle(393, 119, 153, 23));
        lblSynopsis.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSynopsis.setText("簡(jiǎn)       介:");
        lblSynopsis.setBounds(new Rectangle(569, 148, 55, 22));
        lblName.setText("名     稱:");
        lblName.setBounds(new Rectangle(334, 86, 50, 23));
        lblPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPublish.setText("出 版 社:");
        lblPublish.setBounds(new Rectangle(333, 145, 55, 23));
        lblPrice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPrice.setText("價(jià)     格:");
        lblPrice.setBounds(new Rectangle(333, 207, 50, 19));
        lblSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSort.setText("類       別:");
        lblSort.setBounds(new Rectangle(332, 264, 61, 22));
        lblIntoTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIntoTime.setText("入庫(kù)時(shí)間:");
        lblIntoTime.setBounds(new Rectangle(569, 56, 56, 26));
        lblLocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblLocation.setText("存放位置:");
        lblLocation.setBounds(new Rectangle(569, 86, 56, 28));
        txtPrice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPrice.setEditable(false);
        txtPrice.setText("");
        txtPrice.setBounds(new Rectangle(393, 177, 153, 22));
        txtIntoTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIntoTime.setEditable(false);
        txtIntoTime.setText("");
        txtIntoTime.setBounds(new Rectangle(633, 56, 143, 25));
        lblIsbn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIsbn.setText("I S B N:");
        lblIsbn.setBounds(new Rectangle(333, 175, 50, 22));
        txtIsbn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIsbn.setEditable(false);
        txtIsbn.setText("");
        txtIsbn.setBounds(new Rectangle(393, 205, 155, 24));
        txtLocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtLocation.setEditable(false);
        txtLocation.setText("");
        txtLocation.setBounds(new Rectangle(632, 87, 143, 25));
        btnSearch.setBounds(new Rectangle(96, 234, 67, 27));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnSearch.setText("查詢");
        btnSearch.addActionListener(new frmLibSearch_btnSearch_actionAdapter(this));
        btnCancel.setBounds(new Rectangle(168, 234, 66, 27));
        btnCancel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnCancel.setText("清空");
        btnCancel.addActionListener(new frmLibSearch_btnCancel_actionAdapter(this));
        btnExit.setBounds(new Rectangle(243, 234, 65, 28));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnExit.setText("退出");
        btnExit.addActionListener(new frmLibSearch_btnExit_actionAdapter(this));
        lblLine.setBorder(BorderFactory.createEtchedBorder());
        lblLine.setText("");
        lblLine.setBounds(new Rectangle(14, 12, 772, 291));
        lblPage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPage.setText("總 頁(yè) 數(shù):");
        lblPage.setBounds(new Rectangle(333, 235, 54, 25));
        txtPage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPage.setEditable(false);
        txtPage.setText("");
        txtPage.setBounds(new Rectangle(392, 235, 156, 23));
        lblSearchId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchId.setText("圖書編號(hào):");
        lblSearchId.setBounds(new Rectangle(25, 23, 61, 26));
        txtSearchId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchId.setText("");
        txtSearchId.setBounds(new Rectangle(83, 25, 229, 24));
        lblSearchBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchBarCode.setText("條 形 碼:");
        lblSearchBarCode.setBounds(new Rectangle(25, 61, 61, 21));
        txtSearchBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchBarCode.setText("");
        txtSearchBarCode.setBounds(new Rectangle(83, 58, 229, 25));
        lblSearchName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchName.setText("圖書名稱:");
        lblSearchName.setBounds(new Rectangle(23, 92, 63, 19));
        txtSearchName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchName.setText("");
        txtSearchName.setBounds(new Rectangle(83, 89, 229, 24));
        lblSearchAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchAuthor.setText("圖書作者:");
        lblSearchAuthor.setBounds(new Rectangle(23, 118, 62, 22));
        txtSearchAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchAuthor.setText("");
        txtSearchAuthor.setBounds(new Rectangle(84, 118, 227, 24));
        lblSearchPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchPublish.setText("出 版 社:");
        lblSearchPublish.setBounds(new Rectangle(24, 146, 59, 22));
        txtSearchPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchPublish.setText("");
        txtSearchPublish.setBounds(new Rectangle(84, 148, 227, 23));
        lblSearchSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSearchSort.setText("圖書類別:");
        lblSearchSort.setBounds(new Rectangle(23, 177, 62, 22));
        txtSearchSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchSort.setText("");
        txtSearchSort.setBounds(new Rectangle(84, 176, 227, 24));
        rbnExactSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        rbnExactSearch.setText("精確查找");
        rbnExactSearch.setBounds(new Rectangle(19, 218, 75, 26));
        rbnBlurrySearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        rbnBlurrySearch.setText("模糊查找");
        rbnBlurrySearch.setBounds(new Rectangle(19, 246, 74, 27));
        txtPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPublish.setEditable(false);
        txtPublish.setText("");
        txtPublish.setBounds(new Rectangle(392, 148, 154, 21));
        txtSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSort.setEditable(false);
        txtSort.setText("");
        txtSort.setBounds(new Rectangle(392, 266, 157, 23));
        lblIsin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIsin.setText("是否在庫(kù):");
        lblIsin.setBounds(new Rectangle(568, 22, 60, 24));
        txtIsin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIsin.setEditable(false);
        txtIsin.setText("");
        txtIsin.setBounds(new Rectangle(633, 21, 143, 26));
        txtSynopsis.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
        txtSynopsis.setEditable(false);
        txtSynopsis.setText("");
        txtSynopsis.setBounds(new Rectangle(571, 175, 206, 116));
        pnlLibMessage.setBorder(null);
        pnlLibMessage.setBounds(new Rectangle( -1, 0, 801, 309));
        pnlLibMessage.setLayout(null);
        tblDisplay.setBounds(new Rectangle(17, 346, 766, 205));
        tblDisplay.addMouseListener(new frmLibSearch_tblDisplay_mouseAdapter(this));
        lblDisplay.setText("圖書列表");
        lblDisplay.setBounds(new Rectangle(399, 305, 77, 20));
        lblBorrowCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblBorrowCount.setText("借出次數(shù):");
        lblBorrowCount.setBounds(new Rectangle(569, 122, 58, 23));
        txtLoanCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtLoanCount.setEditable(false);
        txtLoanCount.setText("");
        txtLoanCount.setBounds(new Rectangle(633, 119, 142, 26));
        jScrollPane1.setBounds(new Rectangle(9, 324, 779, 237));
        pnlLibMessage.add(lblSearchId);
        pnlLibMessage.add(txtSearchId);
        pnlLibMessage.add(txtSearchBarCode);
        pnlLibMessage.add(lblSearchBarCode);
        pnlLibMessage.add(lblSearchName);
        pnlLibMessage.add(txtSearchName);
        pnlLibMessage.add(lblSearchAuthor);
        pnlLibMessage.add(txtSearchAuthor);
        pnlLibMessage.add(txtSearchPublish);
        pnlLibMessage.add(lblSearchSort);
        pnlLibMessage.add(txtSearchSort);
        pnlLibMessage.add(txtId);
        pnlLibMessage.add(txtLocation);
        pnlLibMessage.add(txtIntoTime);
        pnlLibMessage.add(lblIntoTime);
        pnlLibMessage.add(txtBarCode);
        pnlLibMessage.add(txtName);
        pnlLibMessage.add(txtAuthor);
        pnlLibMessage.add(txtPublish);
        pnlLibMessage.add(txtPrice);
        pnlLibMessage.add(txtIsbn);
        pnlLibMessage.add(txtPage);
        pnlLibMessage.add(lblId);
        pnlLibMessage.add(lblBarCode);
        pnlLibMessage.add(lblName);
        pnlLibMessage.add(lblAuthor);
        pnlLibMessage.add(lblPublish);
        pnlLibMessage.add(lblIsbn);
        pnlLibMessage.add(lblPrice);
        pnlLibMessage.add(lblPage);
        pnlLibMessage.add(lblSearchPublish);
        pnlLibMessage.add(lblSort);
        pnlLibMessage.add(txtSort);
        pnlLibMessage.add(txtIsin);