frmuserupdate.java~27~

用java实现的一个应用程序,源码非常完整,可以直接运行

    {
        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 DisplayAllUser()
    {
        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)));
    }
    public void ShowUserUpdate()
    {
        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()-40,this.getHeight()-pnlUserMessage.getHeight()-70);
        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<txtSearchContent.getText().length();i++)
            {
                if(String.valueOf(txtSearchContent.getText().charAt(i)).equals("%"))
                {
                    JOptionPane.showMessageDialog(this, "模糊查询不能输入\"%\"!");
                    return;
                }
            }
            isnot = false;
        }
        if(txtSearchContent.getText().equals(""))
        {
            Displaynull();
            JOptionPane.showMessageDialog(this, "请输入内容");
        }
        else
        {
            vt = userDB.SearchUser(txtSearchContent.getText(),
                                   cbbSearchSort.getSelectedItem().toString(),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 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)));
    }

    public void btnUpdate_actionPerformed(ActionEvent e) {
        String Id = txtId.getText();
        String Password = txtPassword.getText();
        String Popedom = txtPopedom.getText();
        String Name = txtName.getText();
        String Sex = txtSex.getText();
        String BirthTime = txtBirthTime.getText();
        String IdentityCard = txtIdentityCard.getText();
        String Tel = txtTel.getText();
        String Address = txtAddress.getText();
        String Remark = txtRemark.getText();
        UserConDB userDB = new UserConDB();
        userDB.UpdateUser(Id, Password, Popedom, Name, Sex, BirthTime,
                       IdentityCard, Tel, Address, Remark);
        JOptionPane.showMessageDialog(this, "修改成功");
        vt = userDB.SearchAll();
        userDB.CloseUserDB();
        dt = new DefaultTableModel(vt, vtColName);
        tblDisplay.setModel(dt);

    }

    public void btnCancel_actionPerformed(ActionEvent e) {
        txtSearchContent.setText("");
    }

    public void btnExit_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void btnDelet_actionPerformed(ActionEvent e) {
        UserConDB userDB = new UserConDB();
        String usingId = userDB.SearchUsing().getId();
        if(txtId.getText().equals(usingId))
        {
            JOptionPane.showMessageDialog(this, "用户正在使用,不能删除!");
        }
        else
        {
            userDB.DeleteUser(txtId.getText());
            JOptionPane.showMessageDialog(this, "成功删除");
            DisplayAllUser();
        }
    }
}


class frmUserUpdate_btnDelet_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnDelet_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnExit_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnExit_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnCancel_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnCancel_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnUpdate_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnUpdate_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_tblDisplay_mouseAdapter extends MouseAdapter {
    private frmUserUpdate adaptee;
    frmUserUpdate_tblDisplay_mouseAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_btnSearch_actionAdapter implements ActionListener {
    private frmUserUpdate adaptee;
    frmUserUpdate_btnSearch_actionAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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


class frmUserUpdate_this_componentAdapter extends ComponentAdapter {
    private frmUserUpdate adaptee;
    frmUserUpdate_this_componentAdapter(frmUserUpdate adaptee) {
        this.adaptee = adaptee;
    }

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