package 畢業設計;

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

public class frmLibManage extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    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 btnClear = new JButton();
    JButton btnExit = new JButton();
    JLabel lblLine = new JLabel();
    JLabel lblPage = new JLabel();
    JTextField txtPage = new JTextField();
    JLabel lblFindId = new JLabel();
    JTextField txtContent = new JTextField();
    JLabel lblFindBarCode = new JLabel();
    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 pnlFind = new JPanel();
    JTable tblDisplay = new JTable();
    JLabel lblDisplay = new JLabel();
    JLabel lblLoanCount = new JLabel();
    JTextField txtLoanCount = new JTextField();
    JButton btnUpdate = new JButton();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JComboBox cbbSort = new JComboBox();
    JButton btnDelete = new JButton();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    boolean Isnot;
    String[] column = {"編號", "條形碼", "名稱", "作者", "頁數", "出版社", "價格", "ISBN",
                      "類別", "入庫時間", "存放位置", "是否在庫", "借出次數", "簡介"};
    JLabel lblLineSearch = new JLabel();
    JScrollPane jScrollPane1 = new JScrollPane();
    public frmLibManage() {
        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 frmLibManage_this_componentAdapter(this));
        lblId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblId.setText("編      號:");
        lblId.setBounds(new Rectangle(22, 22, 56, 24));
        txtId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtId.setEditable(true);
        txtId.setBounds(new Rectangle(73, 21, 156, 24));
        lblBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblBarCode.setText("條 形 碼:");
        lblBarCode.setBounds(new Rectangle(23, 51, 51, 23));
        txtBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtBarCode.setEditable(true);
        txtBarCode.setText("");
        txtBarCode.setBounds(new Rectangle(73, 49, 156, 23));
        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtName.setEditable(true);
        txtName.setText("");
        txtName.setBounds(new Rectangle(73, 78, 157, 26));
        lblAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblAuthor.setText("作      者:");
        lblAuthor.setBounds(new Rectangle(22, 109, 51, 24));
        txtAuthor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtAuthor.setEditable(true);
        txtAuthor.setText("");
        txtAuthor.setBounds(new Rectangle(73, 111, 158, 23));
        lblSynopsis.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSynopsis.setText("簡       介:");
        lblSynopsis.setBounds(new Rectangle(252, 140, 55, 22));
        lblName.setText("名      稱:");
        lblName.setBounds(new Rectangle(23, 80, 50, 23));
        lblPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPublish.setText("出 版 社:");
        lblPublish.setBounds(new Rectangle(24, 141, 55, 23));
        lblPrice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPrice.setText("價     格 :");
        lblPrice.setBounds(new Rectangle(23, 200, 50, 19));
        lblSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblSort.setText("類     別:");
        lblSort.setBounds(new Rectangle(24, 261, 61, 22));
        lblIntoTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIntoTime.setText("入庫時間:");
        lblIntoTime.setBounds(new Rectangle(251, 49, 55, 26));
        lblLocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblLocation.setText("存放位置:");
        lblLocation.setBounds(new Rectangle(252, 77, 57, 28));
        txtPrice.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPrice.setEditable(true);
        txtPrice.setText("");
        txtPrice.setBounds(new Rectangle(73, 169, 157, 22));
        txtIntoTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIntoTime.setEditable(true);
        txtIntoTime.setText("");
        txtIntoTime.setBounds(new Rectangle(311, 50, 167, 25));
        lblIsbn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIsbn.setText("I S B N :");
        lblIsbn.setBounds(new Rectangle(23, 168, 50, 22));
        txtIsbn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIsbn.setEditable(true);
        txtIsbn.setText("");
        txtIsbn.setBounds(new Rectangle(73, 199, 157, 24));
        txtLocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtLocation.setEditable(true);
        txtLocation.setText("");
        txtLocation.setBounds(new Rectangle(310, 82, 169, 25));
        btnSearch.setBounds(new Rectangle(605, 160, 67, 27));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnSearch.setText("查詢");
        btnSearch.addActionListener(new frmLibManage_btnSearch_actionAdapter(this));
        btnClear.setBounds(new Rectangle(535, 242, 67, 27));
        btnClear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnClear.setText("清空");
        btnClear.addActionListener(new frmLibManage_btnCancel_actionAdapter(this));
        btnExit.setBounds(new Rectangle(677, 242, 65, 28));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnExit.setText("退出");
        btnExit.addActionListener(new frmLibManage_btnExit_actionAdapter(this));
        lblLine.setBorder(BorderFactory.createEtchedBorder());
        lblLine.setText("");
        lblLine.setBounds(new Rectangle(16, 13, 772, 291));
        lblPage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblPage.setText("總 頁 數:");
        lblPage.setBounds(new Rectangle(22, 230, 54, 25));
        txtPage.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPage.setEditable(true);
        txtPage.setText("");
        txtPage.setBounds(new Rectangle(73, 232, 156, 23));
        lblFindId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblFindId.setText("查詢的類別:");
        lblFindId.setBounds(new Rectangle(528, 68, 71, 24));
        txtContent.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtContent.setText("");
        txtContent.setBounds(new Rectangle(594, 26, 178, 24));
        lblFindBarCode.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblFindBarCode.setText("查詢的內容:");
        lblFindBarCode.setBounds(new Rectangle(529, 27, 69, 21));
        rbnExactSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        rbnExactSearch.setText("精確查找");
        rbnExactSearch.setBounds(new Rectangle(529, 113, 75, 26));
        rbnBlurrySearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        rbnBlurrySearch.setText("模糊查找");
        rbnBlurrySearch.setBounds(new Rectangle(670, 115, 74, 27));
        txtPublish.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtPublish.setEditable(true);
        txtPublish.setText("");
        txtPublish.setBounds(new Rectangle(72, 140, 157, 21));
        txtSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSort.setEditable(true);
        txtSort.setText("");
        txtSort.setBounds(new Rectangle(73, 263, 157, 23));
        lblIsin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblIsin.setText("是否在庫:");
        lblIsin.setBounds(new Rectangle(252, 19, 58, 24));
        txtIsin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtIsin.setEditable(true);
        txtIsin.setText("");
        txtIsin.setBounds(new Rectangle(311, 19, 169, 26));
        txtSynopsis.setFont(new java.awt.Font("Dialog", Font.PLAIN, 11));
        txtSynopsis.setEditable(true);
        txtSynopsis.setText("");
        txtSynopsis.setBounds(new Rectangle(252, 161, 226, 127));
        pnlFind.setBorder(null);
        pnlFind.setBounds(new Rectangle( -1, 0, 801, 309));
        pnlFind.setLayout(null);
        tblDisplay.setBounds(new Rectangle(22, 346, 755, 197));
        tblDisplay.addMouseListener(new frmLibManage_tblDisplay_mouseAdapter(this));
        lblDisplay.setText("圖書列表");
        lblDisplay.setBounds(new Rectangle(399, 305, 77, 20));
        lblLoanCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        lblLoanCount.setText("借出次數:");
        lblLoanCount.setBounds(new Rectangle(252, 112, 58, 23));
        txtLoanCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtLoanCount.setEditable(true);
        txtLoanCount.setText("");
        txtLoanCount.setBounds(new Rectangle(311, 112, 167, 26));
        btnUpdate.setBounds(new Rectangle(534, 199, 68, 28));
        btnUpdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new frmLibManage_btnUpdate_actionAdapter(this));
        cbbSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cbbSort.setBounds(new Rectangle(595, 70, 178, 25));
        btnDelete.setBounds(new Rectangle(674, 202, 68, 27));
        btnDelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new frmLibManage_btnDelete_actionAdapter(this));
        lblLineSearch.setBorder(BorderFactory.createRaisedBevelBorder());
        lblLineSearch.setText("");
        lblLineSearch.setBounds(new Rectangle(496, 15, 291, 288));
        jScrollPane1.setBounds(new Rectangle(16, 322, 767, 239));
        pnlFind.add(lblId);
        pnlFind.add(txtId);
        pnlFind.add(lblName);
        pnlFind.add(lblBarCode);
        pnlFind.add(lblAuthor);
        pnlFind.add(lblPublish);
        pnlFind.add(lblIsbn);
        pnlFind.add(lblPrice);
        pnlFind.add(lblPage);
        pnlFind.add(lblSort);
        pnlFind.add(txtBarCode);
        pnlFind.add(txtName);
        pnlFind.add(txtAuthor);
        pnlFind.add(txtPrice);
        pnlFind.add(txtPublish);
        pnlFind.add(txtIsbn);
        pnlFind.add(txtPage);
        pnlFind.add(txtSort);
        pnlFind.add(lblLocation);
        pnlFind.add(lblLoanCount);
        pnlFind.add(lblSynopsis);
        pnlFind.add(txtIsin);
        pnlFind.add(txtSynopsis);
        pnlFind.add(txtIntoTime);
        pnlFind.add(txtLocation);
        pnlFind.add(txtLoanCount);
        pnlFind.add(lblIsin);
        pnlFind.add(lblIntoTime);
        pnlFind.add(txtContent);
        pnlFind.add(cbbSort);
        pnlFind.add(rbnBlurrySearch);
        pnlFind.add(btnExit);
        pnlFind.add(btnSearch);
        pnlFind.add(btnDelete);
        pnlFind.add(btnUpdate);
        pnlFind.add(lblLine);
        pnlFind.add(lblFindBarCode);
        pnlFind.add(lblFindId);
        pnlFind.add(lblLineSearch);
        pnlFind.add(rbnExactSearch);
        pnlFind.add(btnClear);
        this.getContentPane().add(pnlFind);
        this.getContentPane().add(lblDisplay);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(tblDisplay);
        buttonGroup1.add(rbnExactSearch);
        buttonGroup1.add(rbnBlurrySearch);
        rbnExactSearch.setSelected(true);
        cbbSort.addItem("圖書編號");
        cbbSort.addItem("圖書條形碼");
        cbbSort.addItem("圖書名稱");
        cbbSort.addItem("圖書作者");
        cbbSort.addItem("圖書出版社");
        cbbSort.addItem("圖書類別");
        txtId.setEditable(false);
        for (int i = 0; i < column.length; i++) {
            vtColName.add(column[i]);
        }
        DisplayAllBook();