membermanagepanel.java

自己做的超市管理系统

        pnlAdd.add(lblAge);
        pnlAdd.add(lblName);
        pnlAdd.add(txtName);
        pnlAdd.add(lblStarAge);
        pnlAdd.add(lblStarName);
        pnlAdd.add(lblStarSex);
        pnlAdd.add(lblTelphone);
        pnlAdd.add(txtTelphone);
        pnlAdd.add(lblStarTel);
        pnlAdd.add(lblAddress);
        pnlAdd.add(txtAddress);
        pnlAdd.add(lblWorkplace);
        pnlAdd.add(txtWorkplace);
        pnlAdd.add(lblStartTime);
        pnlAdd.add(txtStartTime);
        pnlAdd.add(txtRemark);
        pnlAdd.add(lblRemark);
        pnlAdd.add(txtScore);
        pnlAdd.add(lblScore);
        pnlAdd.add(btnCancel);
        pnlAdd.add(btnYes);
        pnlAdd.add(btnBack);
        pnlAdd.add(lblId);
        pnlAdd.add(txtId);
        pnlPerfect.add(txaRemark);
        pnlPerfect.add(lbllTelphone);
        pnlPerfect.add(textName);
        pnlPerfect.add(combSex);
        pnlPerfect.add(textAge);
        pnlPerfect.add(textTelphone);
        pnlPerfect.add(textWorkplace);
        pnlPerfect.add(textAddress);
        pnlPerfect.add(lbllName);
        pnlPerfect.add(textSex);
        pnlPerfect.add(lbllAge);
        pnlPerfect.add(lbllWorkplace);
        pnlPerfect.add(lbllAddress);
        pnlPerfect.add(lbllRemark);
        pnlPerfect.add(bttnYes);
        pnlPerfect.add(bttnCancel);
        pnlQuery.add(btnQueryOnly);
        pnlQuery.add(btndQuery);
        pnlQuery.add(lblQueryOnly);
        pnlQuery.add(lbldQuery);
        pnlQuery.add(txtQuery);
        pnlQuery.add(pnlBtn);
        pnlBtn.add(btnRefurbish);
        pnlBtn.add(btnDelete);
        pnlBtn.add(btnPerfect);
        pnlBtn.add(btnQuery);
        pnlBtn.add(btnAdd);
        pnlQuery.add(lblCheckSex);
        pnlQuery.add(combxSex);
        pnlQuery.add(lblCheckScore);
        pnlQuery.add(combScore);
        pnlQuery.add(lblCheckAge);
        pnlQuery.add(combAge);
        pnlQuery.add(jspQuery);
        jspQuery.getViewport().add(jg_table);
        pnlQuery.add(pnlPerfect);
        this.add(pnlQuery);
        cmbSex.addItem("男");
        cmbSex.addItem("女");
        combSex.addItem("男");
        combSex.addItem("女");
        combxSex.addItem("--请选择--");
        combxSex.addItem("男");
        combxSex.addItem("女");
        combAge.addItem("--请选择--");
        combAge.addItem("18岁以下");
        combAge.addItem("18－25岁");
        combAge.addItem("26－35岁");
        combAge.addItem("36－45岁");
        combAge.addItem("46－55岁");
        combAge.addItem("55岁以上");
        combScore.addItem("--请选择--");
        combScore.addItem("1000分以下");
        combScore.addItem("1000－4999分");
        combScore.addItem("5000－7999分");
        combScore.addItem("8000－9999分");
        combScore.addItem("10000分以上");
        txtStartTime.setEnabled(false);
        txtStartTime.setVisible(false);
        txtScore.setEnabled(false);
        txtScore.setVisible(false);
        lblStartTime.setVisible(false);
        lblScore.setVisible(false);
        lblId.setVisible(false);
        txtId.setVisible(false);
        this.pnlQuery.setVisible(true);
        this.pnlPerfect.setVisible(true);
        this.pnlAdd.setVisible(false);
    }

    public void Setting() {
        txtName.setText(null);
        txtAge.setText(null);
        txtAddress.setText(null);
        txtWorkplace.setText(null);
        txtTelphone.setText(null);
        txtRemark.setText(null);
        txtStartTime.setText(null);
    }

//判断是否为数字
    public int isNum(String num) {
        char ch[] = num.toCharArray();
        int i;
        for (i = 0; i < ch.length; i++) {
            if (Character.isDigit(ch[i])) {
                continue;
            } else {
                break;
            }
        }
        return i;
    }

//查询所有会员
    public void jbtQuery_actionPerformed(ActionEvent e) {
        try {
            this.pnlQuery.setVisible(true);
            this.pnlAdd.setVisible(false);
            this.pnlPerfect.setVisible(false);
            vc.clear();
            rs = ctsql.GetRs("select * from MemberInfo order by Score");
            while (rs.next()) {
                Vector rec_vector = new Vector();
                rec_vector.addElement(rs.getString(1));
                rec_vector.addElement(rs.getString(2));
                rec_vector.addElement(rs.getString(3));
                rec_vector.addElement(rs.getString(4));
                rec_vector.addElement(rs.getString(5));
                rec_vector.addElement(rs.getString(6));
                rec_vector.addElement(rs.getString(7));
                rec_vector.addElement(rs.getString(8));
                rec_vector.addElement(rs.getString(9));
                rec_vector.addElement(rs.getString(10));
                vc.addElement(rec_vector);
            }
            tm.fireTableStructureChanged();
        } catch (Exception ex) {
        } finally {
            ctsql.closed();
        }
    }

//显示注册面板
    public void jbtAdd_actionPerformed(ActionEvent e) {
        this.pnlAdd.setVisible(true);
        this.pnlQuery.setVisible(false);
        this.pnlPerfect.setVisible(false);
    }

//判断注册内容是否符合条件
    public void jbtnYes_actionPerformed(ActionEvent e) {
        ResultSet rr;
        try {
            if (txtName.getText().equals("") || txtAge.getText().equals("") ||
                txtTelphone.getText().equals("") ||
                cmbSex.getSelectedItem().equals("")) {
                JOptionPane.showMessageDialog(this, "带*内容不能为空!", "错误",
                                              JOptionPane.ERROR_MESSAGE);
            } else if (isNum(txtAge.getText().toString()) <
                       txtAge.getText().length()) {
                JOptionPane.showConfirmDialog(this, "年龄必须为数字!请重新输入!",
                                              "温馨提示",
                                              JOptionPane.OK_CANCEL_OPTION,
                                              JOptionPane.WARNING_MESSAGE);
                txtAge.setText(null);
            } else {
                sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm");
                txtStartTime.setText(sdf.format(new java.util.Date()));
                String strsql = "insert into MemberInfo (CardId,Name,Sex,Age,Adress,Workplace,Tel,Score,Remark,StartTime) values ('XMY01'+right(rand(datepart(ms,getdate())*1000),5),'" +
                                txtName.getText() + "','" +
                                cmbSex.getSelectedItem() + "','" +
                                txtAge.getText() + "','" +
                                txtAddress.getText() + "','" +
                                txtWorkplace.getText() + "','" +
                                txtTelphone.getText() + "','" +
                                txtScore.getText() + "','" +
                                txtRemark.getTabSize() + "','" +
                                txtStartTime.getText() + "')";
                ctsql.ResultSql(strsql);
                JOptionPane.showMessageDialog(this, "注册成功！", "温馨提示",
                                          JOptionPane.INFORMATION_MESSAGE);
                pnlAdd.setVisible(false);
                pnlQuery.setVisible(true);
            }
        } catch (Exception ex) {
        } finally {
            ctsql.closed();
        }
    }

//删除会员
    public void jbtDelete_actionPerformed(ActionEvent e) {
        int i = 0;
        pnlPerfect.setVisible(false);
        try {
            rs = ctsql.GetRs("select * from MemberInfo");
            while (rs.next()) {
                if (txtQuery.getText().toString().equals(rs.getString(1).
                        toString())) {
                    i++;
                    break;
                }
            }
        } catch (Exception ex) {
        } finally {
            ctsql.closed();
        }
        try {
            if (i != 0) {
                int n = JOptionPane.showConfirmDialog(this, "您确定要删除此会员吗？",
                        "删除会员", JOptionPane.WARNING_MESSAGE);
                if (n == 0) {
                    String strsql = "delete from MemberInfo where CardId='" +
                                    txtQuery.getText() + "'";
                    ctsql.ResultSql(strsql);
                    JOptionPane.showMessageDialog(this, "您已成功删除！", "温馨提示",
                                                  JOptionPane.
                                                  INFORMATION_MESSAGE);
                }
            } else
                JOptionPane.showMessageDialog(this, "没有这个会员!请检查输入是否正确", "错误",
                                              JOptionPane.ERROR_MESSAGE);
        } catch (Exception ex) {
        } finally {
            ctsql.closed();
        }
    }

    public void jbtnCancel_actionPerformed(ActionEvent e) {
        Setting();
    }

//显示修改资料面板
    public void jbtPerfect_actionPerformed(ActionEvent e) {
        this.pnlAdd.setVisible(false);
        this.pnlQuery.setVisible(true);
        this.pnlPerfect.setVisible(true);
    }