音像租赁管理(3)

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 -

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