（3） 开户界面
代码如下：
public void del(){
Sql dbc = new Sql(); dbc.getConn();
int row = jTable.getSelectedRow(); System.out.println(row); if (row < 0) {
javax.swing.JOptionPane.showMessageDialog(null, \您还没有选中要删除的信息!\); return; }
Object value = jTable.getValueAt(row, 0); String id = value.toString(); System.out.println(id); int returnValue;
returnValue = JOptionPane.showConfirmDialog(this, \确实要删除该记录吗？\, \确认删除\, JOptionPane.YES_NO_OPTION);
if (returnValue == JOptionPane.YES_OPTION){
if (dbc.executeUpdateSQL(\ + id+\)) {
javax.swing.JOptionPane.showMessageDialog( this,\卡号为\ + id + \的顾客信息已成功被
11 / 23
删除！请刷新！\); } else {
javax.swing.JOptionPane.showMessageDialog(this, \删除失败！请再试。\); } }else
return ; }
（4） 销户界面
代码如下：
if
(jTextField.getText().equals(\)
||
jTextField1.getText().equals(\)
||
||jTextField2.getText().equals(\)|| jTextField4.getText().equals(\) ) {
javax.swing.JOptionPane.showMessageDialog(null, \各栏不能为空,请重填!\);
} else {
try {
Integer.parseInt(jTextField.getText()); } catch (NumberFormatException ex) {
return;
jTextField3.getText().equals(\)
javax.swing.JOptionPane.showMessageDialog(null,\请确保数量栏及单价栏为数字！\); }
if(Integer.parseInt(jTextField.getText()) < 0 ){ }
Sql dbc = new Sql(); dbc.getConn(); return;
javax.swing.JOptionPane.showMessageDialog(null,\不能有负数！\);
if((dbc.executeUpdateSQL(\ + jTextField.getText() +\ + jTextField1.getText() + \ +jTextField2.getText() + \ +jTextField3.getText()+ \ +jTextField4.getText()+ \)) &&(dbc.executeUpdateSQL(\
cardInfo(cardID,customerID,savingType,curType,openDate,openMoney,pass,balance) VALUES ('\ + jTextField5.getText() +\ + jTextField.getText()+\+ jComboBox1.getSelectedItem() +\+ jComboBox.getSelectedItem() +\ +
jTextField8.getText()+\+Integer.valueOf(jTextField9.getText())+\+String.valueOf(jPasswordField.getPassword())+\+Integer.valueOf(jTextField6.getText())+\))){javax.swing.JOptionPane
12 / 23
.showMessageDialog(null, \记录插入成功！\);
jTextField.setText(\);jTextField1.setText(\);jTextField2.setText(\); jTextField3.setText(\);jTextField4.setText(\);jTextField5.setText(\); jTextField8.setText(\);jTextField9.setText(\);jTextField6.setText(\); jPasswordField.setText(\); } else {
javax.swing.JOptionPane.showMessageDialog(null, \该记录插入失败！请您重试。\); } }
（5）.改密界面
代码如下：
public void quer(){
if (jPasswordField.getPassword().equals(\) || jPasswordField1.getPassword().equals(\) ||jTextField.getText().equals(\)) {
avax.swing.JOptionPane.showMessageDialog(this, \任何一栏不能为空！\); } else {
Sql dbc = new Sql();dbc.getConn();boolean success = false; ResultSet rs = dbc.executeQuery(\); try {
while (rs.next()) {
if (jTextField.getText().equals(rs.getString(\)) || jPasswordField.getPassword().equals(rs.getString(\))) { success = true; } }
if (success) {
if (dbc.executeUpdateSQL(\
+String.valueOf(jPasswordField1.getPassword())+ \+UserFrm.user+\)) { javax.swing.JOptionPane.showMessageDialog(this,\密码修改成功。\); } else {
javax.swing.JOptionPane.showMessageDialog(this, \密码修改失败，请重试。\); } } else {
javax.swing.JOptionPane.showMessageDialog(this,\用户名或原始密码错误！请重新确认！\); return; }
} catch (SQLException ex)
13 / 23
{ javax.swing.JOptionPane.showMessageDialog(this,ex.getMessage().toString()); return; }}}
（6） 查询界面
代码如下：
public void select(){
if(jTextField.getText().equals(\)){
javax.swing.JOptionPane.showMessageDialog(this,\请输入查询信息\); return ;
} String sql=\;
if(((String)jComboBox.getSelectedItem()).equals(\顾客编号\)){
sql=\+jTextField.getText()+\; }else if(((String)jComboBox.getSelectedItem()).equals(\顾客姓名\)){ sql=\+jTextField.getText()+\; }else if(((String)jComboBox.getSelectedItem()).equals(\身份证\)){ }
con=dbc.getConn(); int count=0;
ResultSet rs=dbc.executeQuery(sql); try{
while(rs.next()){ }
rs.close();
Object[][] cells=new Object[count][9]; int i=0;
rs=dbc.executeQuery(sql); while(rs.next()){
cells[i]=new Object[]{rs.getString(1),rs.getString(2), }; i++;
14 / 23
sql=\+jTextField.getText()+\;
count++;
rs.getString(3),rs.getString(4), rs.getString(5)
}
}
}
jTable=new JTable(cells,colnames); jScrollPane.setViewportView(jTable);
javax.swing.JOptionPane.showMessageDialog(null, ex.getMessage().toString());
String[] colnames={\顾客编号\,\顾客姓名\,\身份证号\,\联系电话\,\居住地址\};
}catch(SQLException ex){
（7） 修改界面
代码如下：
public void quer(){ db.getConn();
ResultSet rs = db.executeQuery(\);
try {if (db.executeUpdateSQL(\ +
jComboBox1.getSelectedItem()+\+jComboBox.getSelectedItem()+\=\ + flag+ \ + jTextField.getText().trim()+\)) {
javax.swing.JOptionPane.showMessageDialog(this,\信息修改成功。\); } else {
javax.swing.JOptionPane.showMessageDialog(this, \信息修改失败，请重试。\); } } catch (Exception ex) {
javax.swing.JOptionPane.showMessageDialog(this,ex.getMessage().toString()); } }
（8） IP界面
代码如下：import java.net.* InetAddress id public void inet() {
15 / 23