String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\)};
item.setText(s); } System.out.println(\查找成功\);
} catch(Exception e)
{ }
System.err.println(\异常：\+e.getMessage());
} });
<2>实现音乐信息的添加功能的代码如下：
button.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) { try
{//添加当前表记录
String bianhao= text.getText(); String name=text_1.getText();
String geshou=text_9.getText();
float price=Float.parseFloat(text_10.getText()); String position=text_11.getText();
String suplybianhao=text_13.getText();
int kucun=Integer.parseInt(text_14.getText()); int kezushu=Integer.parseInt(text_15.getText()); String time=dateChooserCombo.getText();
String leibie=combo.getText(); String type=combo_4.getText(); String str_sql=\
music(Bianhao,Name,Geshou,Type,Price,Kucun,Kezushu,Time,Position,Gbianhao,Leibie,Leixing) values('\+bianhao+\+\+name+\+\+geshou+\+\+leibie+\+\+price+\+\+kucun+\+\+kezushu+\+\+time+\+\+position+\+\+suplybianhao+\+\音乐','\+type+\+\; stmt.executeUpdate (str_sql);
System.out.println(\添加成功\); }
catch(Exception e) });
{ } }
System.err.println(\异常：\+e.getMessage());
- 10 -
<3>实现音乐信息的修改功能的代码如下：
button_4.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) {
try
{ String bianhao= text.getText(); String name=text_1.getText();
String geshou=text_9.getText();
float price=Float.parseFloat(text_10.getText()); String position=text_11.getText();
String suplybianhao=text_13.getText();
int kucun=Integer.parseInt(text_14.getText()); int kezushu=Integer.parseInt(text_15.getText()); String time=dateChooserCombo.getText(); String leibie=combo.getText(); String type=combo_4.getText();
String str_sql=\+name+\+geshou+\+leibie+\Price='\+price+\+kucun+\+kezushu+\+time+\+position+\+suplybianhao+\音乐' ,Leixing='\+type+\Bianhao='\+bianhao+\; stmt.executeUpdate(str_sql);
}
System.out.println(\修改成功\); }
catch(Exception e) { System.err.println(\异常：\+e.getMessage()); }
});
<4>实现音像（音乐）信息的删除的代码：
button_8.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event){
try{ String bianhao=text_3.getText();
stmt.executeUpdate(\+bianhao+\); stmt.executeUpdate(\+bianhao+\); System.out.println(\删除成功 \);
}
catch(Exception e) }
{ }
System.err.println(\异常：\+e.getMessage());
});
- 11 -
6.2.4、会员管理模块：实现会员信息的添加，修改，删除，查找以及进行全部会员信息的查找.。
截图如下：
代码如下：
<1>根据会员的卡号和姓名进行查找的代码如下： button_3.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try {
String kahao=text_5.getText(); String name=text_6.getText(); //按照会员卡号进行查找 if(text_5.getEnabled())
{
String str1=\+kahao+ \; rs=stmt.executeQuery(str1); rs.last();
String s1=String.valueOf(rs.getRow()); text_7.setText(s1); rs.beforeFirst(); while(rs.next()) {
item=new TableItem(table,SWT.LEFT);
String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\)}; item.setText(s);
} }
//按照会员姓名查找
- 12 -
else {
String str1=\+name+ \;
rs=stmt.executeQuery(str1); rs.last();
String s2=String.valueOf(rs.getRow());
text_7.setText(s2);
rs.beforeFirst(); while(rs.next())
{ item=new TableItem(table,SWT.LEFT);
String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\
),rs.getString(\),rs.getString(\)};
} }
item.setText(s);
} {
}
catch(Exception e)
}
System.err.println(\异常：\+e.getMessage());
});
<2>查找全部会员的代码：
button_8.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try
{ String str1=\; rs=stmt.executeQuery(str1); rs.last(); String s2=String.valueOf(rs.getRow()); text_7.setText(s2);
rs.beforeFirst(); while(rs.next())
{
item=new TableItem(table,SWT.LEFT); String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\)};
item.setText(s); } }
- 13 -
catch(Exception e) {
System.err.println(\异常：\+e.getMessage());
} } });
<3>会员信息的添加的代码：
button.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try
{//获得输入的信息
String type=combo_2.getText(); String kahao=text.getText(); String name=text_1.getText(); String adress=text_2.getText(); String telephone=text_3.getText();
String Email=text_4.getText();
String str_sql=\
values('\+kahao+\+\+name+\+\+telephone+\+\+adress+\+\+Email+\+\+type+\+\;
stmt.executeUpdate (str_sql);
rs=stmt.executeQuery(\); System.out.println(\添加成功\);
}
catch(Exception e) { System.err.println(\异常：\+e.getMessage());
}
} });
<4>会员信息的修改代码：
button_1.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try
{//获得输入的信息
String type= combo_2.getText();
String kahao=text.getText(); String name=text_1.getText(); String adress=text_2.getText(); String telephone=text_3.getText();
String Email=text_4.getText();
String str_sql=\+name+\
Telephone='\+telephone+\+adress+\+Email+\+type+\
- 14 -