音像租赁管理(5)

{

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 -

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库音像租赁管理(5)在线全文阅读。