pnlUserMessage.add(rbnBlurrySearch);
        pnlUserMessage.add(btnExit);
        pnlUserMessage.add(btnCancel);
        pnlUserMessage.add(btnSearch);
        pnlUserMessage.add(lblLine);
        pnlUserMessage.add(lblSearchLine);
//        spnTable.add(tblDisplay);
        this.getContentPane().add(pnlUserMessage);
        this.getContentPane().add(lblDisplay);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(tblDisplay);
        rbnExactSearch.setSelected(true);
        buttonGroup1.add(rbnExactSearch);
        buttonGroup1.add(rbnBlurrySearch);
        for (int i = 0; i < column.length; i++) {
            vtColName.add(column[i]);
        }
        UserConDB userDB = new UserConDB();
        vt = userDB.SearchAll();
        userDB.CloseUserDB();
        dt = new DefaultTableModel(vt, vtColName);
        tblDisplay.setModel(dt);
        txtId.setText(String.valueOf(tblDisplay.getValueAt(0, 0)));
        txtPassword.setText(String.valueOf(tblDisplay.getValueAt(0, 1)));
        txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(0, 2)));
        txtName.setText(String.valueOf(tblDisplay.getValueAt(0, 3)));
        txtSex.setText(String.valueOf(tblDisplay.getValueAt(0, 4)));
        txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(0, 5)));
        txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(0, 6)));
        txtTel.setText(String.valueOf(tblDisplay.getValueAt(0, 7)));
        txtAddress.setText(String.valueOf(tblDisplay.getValueAt(0, 8)));
        txtRemark.setText(String.valueOf(tblDisplay.getValueAt(0, 9)));
        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("");
         txtPassword.setText("");
         txtPopedom.setText("");
         txtName.setText("");
         txtSex.setText("");
         txtBirthTime.setText("");
         txtIdentityCard.setText("");
         txtTel.setText("");
         txtAddress.setText("");
         txtRemark.setText("");
     }

    //****************************顯示窗口**********************************
     public void ShowUserSearch() {
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
         Dimension dlgSize = this.getSize();
         if (dlgSize.height > screenSize.height) {
             dlgSize.height = screenSize.height;
         }
         if (dlgSize.width > screenSize.width) {
             dlgSize.width = screenSize.width;
         }
         this.setLocation((screenSize.width - dlgSize.width) / 2,
                          (screenSize.height - dlgSize.height) / 2);
         this.setVisible(true);
     }

    //*************************表格根隨窗口改變*************************************
     public void this_componentResized(ComponentEvent e) {
         pnlUserMessage.setLocation((this.getWidth() - pnlUserMessage.getWidth()) /
                                    2, 0);
         jScrollPane1.setSize(this.getWidth() - 45,
                              this.getHeight() - pnlUserMessage.getHeight() -
                              80);
         tblDisplay.setSize(jScrollPane1.getWidth(), jScrollPane1.getHeight());
     }

    //**************************查詢按鈕事件************************************
     public void btnSearch_actionPerformed(ActionEvent e) {
         UserConDB userDB = new UserConDB();
         if (rbnExactSearch.isSelected()) {
             isnot = true;
         } else {
             for (int i = 0; i < txtSearchId.getText().length(); i++) {
                 if (String.valueOf(txtSearchId.getText().charAt(i)).equals("%")) {
                     JOptionPane.showMessageDialog(this, "模糊查詢不能輸入\"%\"!");
                     return;
                 }
             }
             for (int i = 0; i < txtSearchName.getText().length(); i++) {
                 if (String.valueOf(txtSearchName.getText().charAt(i)).equals(
                         "%")) {
                     JOptionPane.showMessageDialog(this, "模糊查詢不能輸入\"%\"!");
                     return;
                 }
             }
             for (int i = 0; i < txtSearchPopedom.getText().length(); i++) {
                 if (String.valueOf(txtSearchPopedom.getText().charAt(i)).
                     equals(
                             "%")) {
                     JOptionPane.showMessageDialog(this, "模糊查詢不能輸入\"%\"!");
                     return;
                 }
             }
             isnot = false;
         }
         if (txtSearchId.getText().equals("") &&
             txtSearchName.getText().equals("") &&
             txtSearchPopedom.getText().equals("")) {
             Displaynull();
             JOptionPane.showMessageDialog(this, "請輸入內(nèi)容");
         } else {
             vt = userDB.SearchUser(txtSearchId.getText(),
                                    txtSearchName.getText(),
                                    txtSearchPopedom.getText(), isnot);
             userDB.CloseUserDB();
             if (vt.size() < 1) {
                 Displaynull();
                 JOptionPane.showMessageDialog(this, "找不到記錄!");
             } else {
                 dt = new DefaultTableModel(vt, vtColName);
                 tblDisplay.setModel(dt);
                 int row = tblDisplay.getSelectedRow();
                 if (row < 0) {
                     row++;
                 }
                 txtId.setText(String.valueOf(tblDisplay.getValueAt(row, 0)));
                 txtPassword.setText(String.valueOf(tblDisplay.getValueAt(row,
                         1)));
                 txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
                 txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 3)));
                 txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 4)));
                 txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row,
                         5)));
                 txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(
                         row, 6)));
                 txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 7)));
                 txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row, 8)));
                 txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 9)));
             }
         }
     }

    //*****************************清空按鈕事件*********************************
     public void btnCancel_actionPerformed(ActionEvent e) {
         txtSearchId.setText("");
         txtSearchName.setText("");
         txtSearchPopedom.setText("");
     }

    //*****************************退出按鈕事件*********************************
     public void btnExit_actionPerformed(ActionEvent e) {
         this.dispose();
     }

    //*****************************鼠標點擊表格*********************************
     public void tblDisplay_mouseClicked(MouseEvent e) {
         int row = tblDisplay.getSelectedRow();
         txtId.setText(String.valueOf(tblDisplay.getValueAt(row, 0)));
         txtPassword.setText(String.valueOf(tblDisplay.getValueAt(row, 1)));
         txtPopedom.setText(String.valueOf(tblDisplay.getValueAt(row, 2)));
         txtName.setText(String.valueOf(tblDisplay.getValueAt(row, 3)));
         txtSex.setText(String.valueOf(tblDisplay.getValueAt(row, 4)));
         txtBirthTime.setText(String.valueOf(tblDisplay.getValueAt(row, 5)));
         txtIdentityCard.setText(String.valueOf(tblDisplay.getValueAt(row, 6)));
         txtTel.setText(String.valueOf(tblDisplay.getValueAt(row, 7)));
         txtAddress.setText(String.valueOf(tblDisplay.getValueAt(row, 8)));
         txtRemark.setText(String.valueOf(tblDisplay.getValueAt(row, 9)));
     }
}


class frmUserSearch_tblDisplay_mouseAdapter extends MouseAdapter {
    private frmUserSearch adaptee;
    frmUserSearch_tblDisplay_mouseAdapter(frmUserSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tblDisplay_mouseClicked(e);
    }
}


class frmUserSearch_btnExit_actionAdapter implements ActionListener {
    private frmUserSearch adaptee;
    frmUserSearch_btnExit_actionAdapter(frmUserSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}


class frmUserSearch_btnCancel_actionAdapter implements ActionListener {
    private frmUserSearch adaptee;
    frmUserSearch_btnCancel_actionAdapter(frmUserSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnCancel_actionPerformed(e);
    }
}


class frmUserSearch_btnSearch_actionAdapter implements ActionListener {
    private frmUserSearch adaptee;
    frmUserSearch_btnSearch_actionAdapter(frmUserSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSearch_actionPerformed(e);
    }
}


class frmUserSearch_this_componentAdapter extends ComponentAdapter {
    private frmUserSearch adaptee;
    frmUserSearch_this_componentAdapter(frmUserSearch adaptee) {
        this.adaptee = adaptee;
    }

    public void componentResized(ComponentEvent e) {
        adaptee.this_componentResized(e);
    }
}