package 畢業設計;

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 frmReaSearch extends JFrame {
    BorderLayout borderLayout1 = new BorderLayout();
    JLabel lblId = new JLabel();
    JTextField txtId = new JTextField();
    JLabel lblName = new JLabel();
    JTextField txtName = new JTextField();
    JLabel lblSex = new JLabel();
    JTextField txtVocation = new JTextField();
    JLabel lblBirthTime = new JLabel();
    JTextField txtBirthTime = new JTextField();
    JLabel lblRemark = new JLabel();
    JTextArea txtRemark = new JTextArea();
    JLabel lblVocation = new JLabel();
    JLabel lblAddress = new JLabel();
    JTextField txtIdentityCard = new JTextField();
    JLabel lblIdentityCard = new JLabel();
    JTextField txtAddress = new JTextField();
    JButton btnSearch = new JButton();
    JButton btnCancel = new JButton();
    JButton btnExit = new JButton();
    JLabel lblTransactTime = new JLabel();
    JTextField txtTransactTime = new JTextField();
    JLabel lblEndTime = new JLabel();
    JTextField txtEndTime = new JTextField();
    JLabel lblLine = new JLabel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JTextField txtSex = new JTextField();
    JLabel lblLoanableNum = new JLabel();
    JLabel lblBorrowCount = new JLabel();
    JTextField txtLoanableNum = new JTextField();
    JTextField txtBorrowCount = new JTextField();
    JLabel lblAlreadyNum = new JLabel();
    JTextField txtAlreadyNum = new JTextField();
    JLabel lblTel = new JLabel();
    JTextField txtTel = new JTextField();
    JLabel lblSearchId = new JLabel();
    JTextField txtSearchId = new JTextField();
    JLabel lblSearchName = new JLabel();
    JTextField txtSearchName = new JTextField();
    JLabel lblSearchVocation = new JLabel();
    JTextField txtSearchVocation = new JTextField();
    JRadioButton rbnExactSearch = new JRadioButton();
    JRadioButton rbnBlurrySearch = new JRadioButton();
    JPanel pnlReaMessage = new JPanel();
    JTable tblDisplay = new JTable();
    JLabel lblDisplay = new JLabel();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    boolean isnot;
    String[] column = {"卡號", "姓名", "性別", "出生年月", "職業", "身份證號", "電話", "可借數量",
                      "已借數量", "辦證日期", "有效日期", "借書數量", "地址", "備注"};
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JScrollPane jScrollPane1 = new JScrollPane();
    public frmReaSearch() {
        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 frmReaSearch_this_componentAdapter(this));
        lblId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblId.setText("卡      號:");
        lblId.setBounds(new Rectangle(297, 5, 74, 28));
        txtId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtId.setEditable(false);
        txtId.setBounds(new Rectangle(366, 5, 161, 28));
        lblName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblName.setText("姓      名:");
        lblName.setBounds(new Rectangle(297, 44, 58, 22));
        txtName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtName.setEditable(false);
        txtName.setText("");
        txtName.setBounds(new Rectangle(365, 39, 163, 28));
        lblSex.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtVocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtVocation.setEditable(false);
        txtVocation.setText("");
        txtVocation.setBounds(new Rectangle(616, 41, 158, 28));
        lblBirthTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblBirthTime.setText("出生年月:");
        lblBirthTime.setBounds(new Rectangle(547, 6, 66, 28));
        txtBirthTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtBirthTime.setEditable(false);
        txtBirthTime.setText("");
        txtBirthTime.setBounds(new Rectangle(615, 6, 158, 28));
        lblRemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblRemark.setText("備      注:");
        lblRemark.setBounds(new Rectangle(296, 254, 76, 25));
        txtRemark.setEditable(false);
        txtRemark.setText("");
        txtRemark.setBounds(new Rectangle(365, 258, 406, 77));
        lblSex.setText("性      別:");
        lblSex.setBounds(new Rectangle(296, 76, 60, 28));
        lblVocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblVocation.setText("職       業:");
        lblVocation.setBounds(new Rectangle(546, 41, 67, 28));
        lblAddress.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAddress.setText("地      址:");
        lblAddress.setBounds(new Rectangle(296, 220, 81, 28));
        txtIdentityCard.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtIdentityCard.setEditable(false);
        txtIdentityCard.setText("");
        txtIdentityCard.setBounds(new Rectangle(616, 78, 157, 28));
        lblIdentityCard.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblIdentityCard.setText("身份證號:");
        lblIdentityCard.setBounds(new Rectangle(544, 78, 81, 28));
        txtAddress.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAddress.setEditable(false);
        txtAddress.setText("");
        txtAddress.setBounds(new Rectangle(365, 221, 407, 28));
        btnSearch.setBounds(new Rectangle(94, 239, 84, 28));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnSearch.setText("查詢");
        btnSearch.addActionListener(new frmReaSearch_btnSearch_actionAdapter(this));
        btnCancel.setBounds(new Rectangle(38, 287, 82, 28));
        btnCancel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnCancel.setText("清空");
        btnCancel.addActionListener(new frmReaSearch_btnCancel_actionAdapter(this));
        btnExit.setBounds(new Rectangle(158, 286, 82, 28));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setText("退出");
        btnExit.addActionListener(new frmReaSearch_btnExit_actionAdapter(this));
        lblTransactTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTransactTime.setText("辦證日期:");
        lblTransactTime.setBounds(new Rectangle(296, 111, 66, 32));
        txtTransactTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTransactTime.setEditable(false);
        txtTransactTime.setBounds(new Rectangle(365, 113, 166, 28));
        lblEndTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEndTime.setText("有 效 期 :");
        lblEndTime.setBounds(new Rectangle(544, 110, 85, 28));
        txtEndTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEndTime.setEditable(false);
        txtEndTime.setText("");
        txtEndTime.setBounds(new Rectangle(616, 114, 157, 27));
        lblLine.setBorder(BorderFactory.createRaisedBevelBorder());
        lblLine.setText("");
        lblLine.setBounds(new Rectangle(2, 2, 279, 340));
        txtSex.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtSex.setEditable(false);
        txtSex.setText("");
        txtSex.setBounds(new Rectangle(365, 75, 164, 29));
        lblLoanableNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblLoanableNum.setText("可 借 書 :");
        lblLoanableNum.setBounds(new Rectangle(297, 151, 64, 24));
        lblBorrowCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblBorrowCount.setText("借書數量:");
        lblBorrowCount.setBounds(new Rectangle(294, 189, 64, 25));
        txtLoanableNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtLoanableNum.setEditable(false);
        txtLoanableNum.setText("");
        txtLoanableNum.setBounds(new Rectangle(365, 148, 165, 30));
        txtBorrowCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtBorrowCount.setEditable(false);
        txtBorrowCount.setText("");
        txtBorrowCount.setBounds(new Rectangle(365, 186, 165, 28));
        lblAlreadyNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAlreadyNum.setText("已 借 書 :");
        lblAlreadyNum.setBounds(new Rectangle(544, 147, 70, 26));
        txtAlreadyNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAlreadyNum.setEditable(false);
        txtAlreadyNum.setText("");
        txtAlreadyNum.setBounds(new Rectangle(616, 149, 157, 29));
        lblTel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTel.setText("聯系電話:");
        lblTel.setBounds(new Rectangle(544, 187, 67, 24));
        txtTel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtTel.setEditable(false);
        txtTel.setText("");
        txtTel.setBounds(new Rectangle(616, 186, 157, 26));
        lblSearchId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSearchId.setText("讀者卡號:");
        lblSearchId.setBounds(new Rectangle(7, 19, 70, 24));
        txtSearchId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchId.setText("");
        txtSearchId.setBounds(new Rectangle(81, 15, 184, 28));
        lblSearchName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSearchName.setText("讀者姓名:");
        lblSearchName.setBounds(new Rectangle(6, 84, 72, 25));
        txtSearchName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtSearchName.setText("");
        txtSearchName.setBounds(new Rectangle(78, 82, 186, 28));
        lblSearchVocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSearchVocation.setText("讀者職業:");
        lblSearchVocation.setBounds(new Rectangle(8, 146, 71, 24));
        txtSearchVocation.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtSearchVocation.setText("");
        txtSearchVocation.setBounds(new Rectangle(79, 144, 188, 28));
        rbnExactSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rbnExactSearch.setText("精確查詢");
        rbnExactSearch.setBounds(new Rectangle(18, 198, 88, 26));
        rbnBlurrySearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rbnBlurrySearch.setText("模糊查詢");
        rbnBlurrySearch.setBounds(new Rectangle(167, 195, 107, 26));
        pnlReaMessage.setBorder(BorderFactory.createEtchedBorder());
        pnlReaMessage.setBounds(new Rectangle(11, 14, 776, 344));
        pnlReaMessage.setLayout(null);
        tblDisplay.setBounds(new Rectangle(21, 390, 757, 171));
        tblDisplay.addMouseListener(new frmReaSearch_tblDisplay_mouseAdapter(this));
        lblDisplay.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDisplay.setText("查詢結果");
        lblDisplay.setBounds(new Rectangle(373, 360, 115, 22));
        jScrollPane1.setBounds(new Rectangle(16, 384, 769, 186));
        pnlReaMessage.add(txtBirthTime);
        pnlReaMessage.add(txtId);
        pnlReaMessage.add(lblId);
        pnlReaMessage.add(txtVocation);
        pnlReaMessage.add(txtIdentityCard);
        pnlReaMessage.add(txtEndTime);
        pnlReaMessage.add(txtName);
        pnlReaMessage.add(txtSex);
        pnlReaMessage.add(txtTransactTime);
        pnlReaMessage.add(lblName);
        pnlReaMessage.add(lblSex);
        pnlReaMessage.add(lblTransactTime);
        pnlReaMessage.add(lblLoanableNum);
        pnlReaMessage.add(txtLoanableNum);
        pnlReaMessage.add(txtAlreadyNum);
        pnlReaMessage.add(txtBorrowCount);
        pnlReaMessage.add(txtAddress);
        pnlReaMessage.add(lblAddress);
        pnlReaMessage.add(txtTel);
        pnlReaMessage.add(txtRemark);
        pnlReaMessage.add(lblRemark);
        pnlReaMessage.add(txtSearchVocation);
        pnlReaMessage.add(lblSearchVocation);
        pnlReaMessage.add(lblLine);
        pnlReaMessage.add(txtSearchId);
        pnlReaMessage.add(txtSearchName);
        pnlReaMessage.add(lblSearchName);