KNo='\+kahao+\; stmt.executeUpdate(str_sql);
}
System.out.println(\修改成功\);
}
catch(Exception e) { System.err.println(\异常：\+e.getMessage()); }
});
<5>会员信息的删除代码：
button_2.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) { try
{
String kahao= text.getText();
String str_sql=\+kahao+\; stmt.executeUpdate(str_sql);
String str=\+kahao+\;
stmt.executeUpdate(str);
System.out.println(\删除成功\);
}
catch(Exception e)
}
{ }
System.err.println(\异常：\+e.getMessage());
});
6.2.5、租赁归还模块：实现音像信息的租赁，归还，还可以查找会员的租赁归还记录。
截图如下：
- 15 -
代码如下：
<1>客户租赁信息的查找代码：
button.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) { try
{ String kahao=text_1.getText();
String leixing=combo.getText();
String str1=\
customer.Type as kehuleixing, zulin.Bianhao as yinxiangbianhao,
Zuiduoshuliang,Zulintime,Returntime from customer,Zulin,shoufeibiaozhun where
customer.KNo='\+kahao+\+leixing+\customer.Type=shoufeibiaozhun.Type \; rs=stmt.executeQuery(str1);
rs.last();
- 16 -
String s1=String.valueOf(rs.getRow()); text_3.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(\),rs.getString(\)};
}
});
<2>办理租赁音像业务的代码：
button_4.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) { try {//获得输入的信息
String kahao=text_2.getText(); String bianhao=text.getText();
String renttime=dateChooserCombo_3.getText();
rs=stmt.executeQuery(\ReturnTime=null and KNo=\+kahao+\); rs.first(); int mount=rs.getInt(\);
rs=stmt.executeQuery(\Zuiduoshuliang from customer,shoufeibiaozhun where customer.KNo=\+kahao+\);
rs.first();
int mount1=rs.getInt(\); if(mount<=mount1) {
}
}
catch(Exception e)
System.err.println(\异常：\+e.getMessage());
item.setText(s);
}
System.out.println(\查找成功\);
{
String str_sql=\
values('\+kahao+\+\+bianhao+\+\+renttime+\+\; stmt.executeUpdate (str_sql);
String str1=\+bianhao+\; stmt.executeUpdate(str1);
System.out.println(\租借成功\);
- 17 -
} else
MessageDialog.openInformation(null, \提示\,\超过最大租赁数量不能再租\);
}
catch(Exception e) { System.err.println(\异常：\+e.getMessage()); }
}
});
<3>办理归还音像业务的代码：
button_5.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event){ try
{//获得输入的信息
String kahao=text_2.getText();
String bianhao=text.getText();
String returntime=dateChooserCombo_2.getText();
String str_sql=\+returntime+\
KNo='\+kahao+\+bianhao+\; stmt.executeUpdate (str_sql);
String str1=\+bianhao+\; stmt.executeUpdate(str1);
System.out.println(\归还成功\);
String str_6=\+kahao+\
Bianhao='\+bianhao+\; rs=stmt.executeQuery (str_6);
rs.first();
String a=rs.getString(\); String b=rs.getString(\); String str_7=\KNo='\+kahao+\;
rs=stmt.executeQuery (str_7); rs.first();
float c=rs.getFloat(\); String datestr3 =\ ;
String ymd1 =b;
Date date2 = myFormatter1.parse(ymd1);
SimpleDateFormat myFormatter1 = new SimpleDateFormat(\);
SimpleDateFormat myFormatter = new SimpleDateFormat(\); String ymd =a;
Date date1 = myFormatter.parse(ymd);
datestr3 = String.valueOf((date2 .getTime()-date1.getTime())/(24*60*60*1000));
System.out.println(datestr3);
- 18 -
float d=Float.parseFloat(datestr3); text_4.setText(String.valueOf(d*c)); }
catch(Exception e) { System.err.println(\异常：\+e.getMessage()); } }
});
6.2.6、供应商信息管理界模块：实现供应商信息的添加，修改，删除，查找以及查找全部供应商的功能。
截图如下：
代码如下：
<1>供应商信息查找的代码：
button.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try {//根据供应商的编号进行查找
if(text.getEnabled())
- 19 -