pnlUserMessage.add(lblName);
        pnlUserMessage.add(lblAddress);
        pnlUserMessage.add(lblRemark);
        pnlUserMessage.add(lblSearchName);
        pnlUserMessage.add(txtSearchId);
        pnlUserMessage.add(txtSearchName);
        pnlUserMessage.add(lblSearchId);
        pnlUserMessage.add(lblSearchPopedom);
        pnlUserMessage.add(txtSearchPopedom);
        pnlUserMessage.add(rbnExactSearch);
        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
        {
            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);
    }
}