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 frmReaUpdate 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 lblLoanCount = 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 lblContent = new JLabel();
    JTextField txtSearchContent = new JTextField();
    JLabel lblSort = new JLabel();
    JRadioButton rbnExactSearch = new JRadioButton();
    JRadioButton rbnBlurrySearch = new JRadioButton();
    JPanel pnlReaMessage = new JPanel();
    JTable tblDisplay = new JTable();
    JLabel lblDisplay = new JLabel();
    JButton btnUpdate = new JButton();
    JComboBox cbbSearchSort = new JComboBox();
    JButton btnDelete = new JButton();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    boolean Isnot;
    String []column = {"卡號","姓名","性別","出生年月","職業","身份證號","電話","可借書數",
                      "未還書數","辦證日期","有效日期","借書總數","地址","備注"};
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JScrollPane jScrollPane1 = new JScrollPane();
    public frmReaUpdate() {
        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 frmReaUpdate_this_componentAdapter(this));
        lblId.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblId.setText("卡      號:");
        lblId.setBounds(new Rectangle(297, 5, 74, 28));
        txtId.setBackground(Color.lightGray);
        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.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.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.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.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.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.setText("");
        txtAddress.setBounds(new Rectangle(365, 221, 407, 28));
        btnSearch.setBounds(new Rectangle(101, 176, 80, 28));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnSearch.setText("查詢");
        btnSearch.addActionListener(new frmReaUpdate_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 frmReaUpdate_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 frmReaUpdate_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.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.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.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));
        lblLoanCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblLoanCount.setText("借書總數:");
        lblLoanCount.setBounds(new Rectangle(297, 189, 64, 25));
        txtLoanableNum.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtLoanableNum.setText("");
        txtLoanableNum.setBounds(new Rectangle(365, 148, 165, 30));
        txtBorrowCount.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        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.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.setText("");
        txtTel.setBounds(new Rectangle(616, 186, 157, 26));
        lblContent.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblContent.setText("讀者信息:");
        lblContent.setBounds(new Rectangle(9, 27, 70, 24));
        txtSearchContent.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12));
        txtSearchContent.setText("");
        txtSearchContent.setBounds(new Rectangle(78, 26, 197, 28));
        lblSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSort.setText("查詢類別:");
        lblSort.setBounds(new Rectangle(8, 86, 71, 24));
        rbnExactSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rbnExactSearch.setText("精確查詢");
        rbnExactSearch.setBounds(new Rectangle(21, 129, 88, 26));
        rbnBlurrySearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rbnBlurrySearch.setText("模糊查詢");
        rbnBlurrySearch.setBounds(new Rectangle(170, 130, 107, 26));
        pnlReaMessage.setBorder(BorderFactory.createEtchedBorder());
        pnlReaMessage.setBounds(new Rectangle(11, 14, 776, 344));
        pnlReaMessage.setLayout(null);
        tblDisplay.setBounds(new Rectangle(15, 408, 770, 161));
        tblDisplay.addMouseListener(new frmReaUpdate_tblDisplay_mouseAdapter(this));
        lblDisplay.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDisplay.setText("請選擇要更新或刪除的讀者");
        lblDisplay.setBounds(new Rectangle(363, 360, 184, 22));
        btnUpdate.setBounds(new Rectangle(41, 229, 80, 31));
        btnUpdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new frmReaUpdate_btnUpdate_actionAdapter(this));
        cbbSearchSort.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cbbSearchSort.setBounds(new Rectangle(77, 86, 198, 27));
        btnDelete.setBounds(new Rectangle(160, 230, 80, 31));
        btnDelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new frmReaUpdate_btnDelete_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(10, 382, 780, 180));
        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(lblLoanCount);
        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(btnExit);
        pnlReaMessage.add(btnCancel);
        pnlReaMessage.add(lblBirthTime);
        pnlReaMessage.add(lblIdentityCard);
        pnlReaMessage.add(lblEndTime);
        pnlReaMessage.add(lblAlreadyNum);
        pnlReaMessage.add(lblTel);
        pnlReaMessage.add(lblVocation);
        pnlReaMessage.add(txtSearchContent);
        pnlReaMessage.add(cbbSearchSort);
        pnlReaMessage.add(rbnBlurrySearch);
        pnlReaMessage.add(rbnExactSearch);
        pnlReaMessage.add(btnSearch);
        pnlReaMessage.add(btnUpdate);
        pnlReaMessage.add(btnDelete);
        pnlReaMessage.add(lblContent);
        pnlReaMessage.add(lblSort);
        pnlReaMessage.add(lblLine);
        this.getContentPane().add(pnlReaMessage);
        this.getContentPane().add(lblDisplay);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(tblDisplay);
        rbnExactSearch.setSelected(true);
        cbbSearchSort.addItem("讀者卡號");
        cbbSearchSort.addItem("讀者姓名");
        cbbSearchSort.addItem("讀者職業");
        buttonGroup1.add(rbnExactSearch);
        buttonGroup1.add(rbnBlurrySearch);
        for (int i = 0; i < column.length; i++) {
            vtColName.add(column[i]);
        }
        DisplayAllReader();
        tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    public void Displaynull()
    {
        Vector vt = new Vector();
        dt = new DefaultTableModel(vt, vtColName);
        tblDisplay.setModel(dt);
        txtId.setText("");