📄 membermanagepanel.java
字号:
//清空修改面板的内容
public void jbttnCancel_actionPerformed(ActionEvent e) {
textName.setText(null);
textAge.setText(null);
textTelphone.setText(null);
textWorkplace.setText(null);
txaRemark.setText(null);
textAddress.setText(null);
txtQuery.setText(null);
}
//判断修改内容是否符合条件
public void jbttnYes_actionPerformed(ActionEvent e) {
try {
if (txtQuery.getText().equals("")) {
JOptionPane.showMessageDialog(this, "卡号不能为空！", "温馨提示",
JOptionPane.WARNING_MESSAGE);
} else if (textName.getText().equals("")) {
JOptionPane.showMessageDialog(this, "姓名不能为空！", "温馨提示",
JOptionPane.WARNING_MESSAGE);
} else if (textAge.getText().equals("")) {
JOptionPane.showMessageDialog(this, "年龄不能为空！", "温馨提示",
JOptionPane.WARNING_MESSAGE);
} else if (isNum(textAge.getText().toString()) <
textAge.getText().length()) {
JOptionPane.showConfirmDialog(this, "年龄必须为数字!请重新输入!",
"温馨提示",
JOptionPane.OK_CANCEL_OPTION,
JOptionPane.WARNING_MESSAGE);
textAge.setText(null);
} else if (textTelphone.getText().equals("")) {
JOptionPane.showMessageDialog(this, "联系方式不能为空！", "温馨提示",
JOptionPane.WARNING_MESSAGE);
} else {
int m = JOptionPane.showConfirmDialog(this, "您确定要修改吗？", "修改资料",
JOptionPane.WARNING_MESSAGE);
if (m == 0) {
int i = 0;
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();
}
if (i != 0) {
String strsql =
"Update MemberInfo set Name='" +
textName.getText() +
"',Sex='" + combSex.getSelectedItem() +
"',Age='" +
textAge.getText() + "',Tel='" +
textTelphone.getText() +
"',WorkPlace='" +
textWorkplace.getText() +
"',Adress='" + textAddress.getText() +
"',Remark='" + txaRemark.getText() +
"' where CardId='" +
txtQuery.getText() + "'";
ctsql.ResultSql(strsql);
JOptionPane.showMessageDialog(this, "您已成功修改！", "温馨提示",
JOptionPane.WARNING_MESSAGE);
pnlPerfect.setVisible(false);
} else {
JOptionPane.showMessageDialog(this, "您的卡号错误！请重新输入",
"错误", JOptionPane.ERROR_MESSAGE);
}
}
}
} catch (Exception ex) {
} finally {
ctsql.closed();
}
}
//查询单个会员
public void btnQueryOnly_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) {
vc.clear();
rs = ctsql.GetRs("select * from MemberInfo where cardId='" +
txtQuery.getText().toString() + "'");
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();
} else {
JOptionPane.showMessageDialog(this, "没有这个会员！请检查卡号是否正确", "温馨提示",
JOptionPane.WARNING_MESSAGE);
}
} catch (Exception ex) {
} finally {
ctsql.closed();
}
}
//对每一次的操作进行刷新
public void btnRefurbish_actionPerformed(ActionEvent e) {
try {
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();
txtQuery.setText(null);
} catch (Exception ex) {
} finally {
ctsql.closed();
}
}
//根据可选条件进行模糊查询
public void btndQuery_actionPerformed(ActionEvent e) {
try {
pnlPerfect.setVisible(false);
vc.clear();
if (combxSex.getSelectedIndex() == 0) {
if (combAge.getSelectedIndex() == 0) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 1) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18'and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18' and Score>='8000' and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age<'18' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 2) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>='18' and Age<='25' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>='18' and Age<='25' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Age>='18' and Age<='25' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Age>='18' and Age<='25' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Age>='18' and Age<='25' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>='18' and Age<='25' and Score>=10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 3) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'25' and Age<='35' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'25' and Age<='35' and Score<1000 order by Score");
} else if (combScore.getSelectedIndex() == 2) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'25' and Age<='35' and Score>=1000 and Score<5000 order by Score");
} else if (combScore.getSelectedIndex() == 3) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'25' and Age<='35' and Score>=5000 and Score<8000 order by Score");
} else if (combScore.getSelectedIndex() == 4) {
rs = ctsql.GetRs("select * from MemberInfo where Age>'25' and Age<='35' and Score>=8000 and Score<10000 order by Score");
} else {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'25' and Age<='35' and Score>10000 order by Score");
}
} else if (combAge.getSelectedIndex() == 4) {
if (combScore.getSelectedIndex() == 0) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'35' and Age<='45' order by Score");
} else if (combScore.getSelectedIndex() == 1) {
rs = ctsql.GetRs(
"select * from MemberInfo where Age>'35' and Age<='45' and Score<1000 order by Score");
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -