{
String suplybianhao=text.getText();
String str1=\+suplybianhao+ \;
rs=stmt.executeQuery(str1); rs.beforeFirst(); while(rs.next())
{
item=new TableItem(table,SWT.LEFT); String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\lephone\),rs.getString(\)};
item.setText(s);
} }
//根据供应商的联系人姓名查找 else
{
String lianxiren=text_1.getText();
String str1=\+lianxiren+ \;
rs=stmt.executeQuery(str1); rs.beforeFirst(); while(rs.next())
{
item=new TableItem(table,SWT.LEFT); String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\lephone\),rs.getString(\)};
item.setText(s);
} } }
catch(Exception e) {
System.err.println(\异常：\+e.getMessage());
}
<2> 查找全部供应商信息的代码：
button_5.addSelectionListener(new SelectionAdapter() {
public void widgetSelected(SelectionEvent event) { try
{
String str1=\;
rs=stmt.executeQuery(str1); rs.beforeFirst(); while(rs.next())
- 20 -
{
item=new TableItem(table,SWT.LEFT); String[ ]
s={rs.getString(\),rs.getString(\),rs.getString(\),rs.getString(\lephone\),rs.getString(\)}; item.setText(s); }
} catch(Exception e)
{ } }
System.err.println(\异常：\+e.getMessage());
});
<3>实现供应商信息添加功能的代码：
button_1.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) { try
{//添加当前表记录
String bianhao= text_2.getText(); String name=text_3.getText(); String lianxiren=text_4.getText(); String telephone=text_5.getText();
String adress=text_6.getText(); String str_sql=\
gongyingshang(Gbianhao,Name,Lianxiren,Telephone,Adress)
values('\+bianhao+\+\+name+\+\+lianxiren+\+\+telephone+\+\+adress+\+\)\;
stmt.executeUpdate (str_sql);
rs=stmt.executeQuery(\); System.out.println(\添加成功\); }
catch(Exception e) {
}
System.err.println(\异常：\+e.getMessage());
} // end method JButtonActionPerformed
<4>供应商信息修改的代码：
button_4.addMouseListener(new MouseAdapter() { public void mouseDown(MouseEvent event) {
try {
- 21 -
//获得输入的信息 String bianhao= text_2.getText();
String name=text_3.getText();
String lianxiren=text_4.getText(); String telephone=text_5.getText(); String adress=text_6.getText();
String str_sql=\+name+\+lianxiren+\Telephone='\+telephone+\+adress+\+bianhao+\; stmt.executeUpdate(str_sql); System.out.println(\修改成功\); }
catch(Exception e) { } }
System.err.println(\异常：\+e.getMessage());
<5>实现供应商信息的删除的代码：
button_3.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event)
{ try {
String bianhao= text_2.getText();
String str_sql=\+bianhao+\; stmt.executeUpdate(str_sql);
String str=\+bianhao+\; stmt.executeUpdate(str);
System.out.println(\删除成功\);
}
catch(Exception e) { System.err.println(\异常：\+e.getMessage()); } }
6.2.7、用户管理模块：实现用户的添加，修改，删除，查找以及用户的全部查找。
截图如下：
- 22 -
代码如下：
<1>实现用户添加的代码：
button.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) {
try { String yonghuming=text.getText(); String mima=text_1.getText();
String str_sql=\
values('\+yonghuming+\+\+mima+\+\;
stmt.executeUpdate (str_sql);
rs=stmt.executeQuery(\); System.out.println(\添加成功\);
}
catch(Exception e) }
{ }
System.err.println(\异常：\+e.getMessage());
});
- 23 -
<2>实现用户信息修改的代码：
button_1.addMouseListener(new MouseAdapter() {
public void mouseDown(MouseEvent event) {
try { String yonghuming=text.getText(); String mima=text_1.getText();
String str_sql=\+mima+\+yonghuming+\;
stmt.executeUpdate(str_sql);
}
System.out.println(\修改成功\); }
catch(Exception e) { }
System.err.println(\异常：\+e.getMessage());
});
<3>实现用户信息删除的代码：
button_2.addMouseListener(new MouseAdapter() { }
public void mouseDown(MouseEvent event) { try
{
String yonghuming=text.getText();
String str=\+yonghuming+\; stmt.executeUpdate(str); System.out.println(\删除成功\); }
catch(Exception e) { }
System.err.println(\异常：\+e.getMessage());
});
<4>根据用户名进行用户信息查找的代码：
button_4.addMouseListener(new MouseAdapter() {
{
public void mouseDown(MouseEvent event)
try {
String yonghuming=text_2.getText();
String str1=\+yonghuming+ \;
rs=stmt.executeQuery(str1);
- 24 -