《JAVA2实用教程》(第四版)课后答案 第九章第十三章.doc

《《JAVA2实用教程》(第四版)课后答案 第九章第十三章.doc》由会员分享，可在线阅读，更多相关《《JAVA2实用教程》(第四版)课后答案 第九章第十三章.doc（30页珍藏版）》请在三一办公上搜索。

1、 Java作业4（第九章-第十三章）第九章3.1.1程序代码import java.awt.*;import javax.swing.event.*;import javax.swing.*;import java.awt.event.*;public class kehou31 public static void main(String args) Computer fr=new Computer(); class Computer extends JFrame implements DocumentListener JTextArea text1,text2; int count=1;

2、double sum=0,aver=0; Computer() setLayout(new FlowLayout(); text1=new JTextArea(6,20); text2=new JTextArea(6,20); add(new JScrollPane(text1); add(new JScrollPane(text2); text2.setEditable(false); (text1.getDocument().addDocumentListener(this); setSize(300,320); setVisible(true); validate(); setDefau

3、ltCloseOperation(JFrame.DISPOSE_ON_CLOSE); public void changedUpdate(DocumentEvent e) String s=text1.getText(); String a =s.split(0123456789.+); sum=0; aver=0; for(int i=0;i=0) m=m-1; random.seek(m); int c=random.readByte(); if(c=0) System.out.print(char)c); else m=m-1; random.seek(m); byte cc=new b

4、yte2; random.readFully(cc); System.out.print(new String(cc); catch(Exception exp) 4.1.2运行界面4.2.1程序代码 import java.io.*;public class E public static void main(String args ) File file=new File(E.java); File tempFile=new File(temp.txt); try FileReader inOne=new FileReader(file); BufferedReader inTwo= ne

5、w BufferedReader(inOne); FileWriter tofile=new FileWriter(tempFile); BufferedWriter out= new BufferedWriter(tofile); String s=null; int i=0; s=inTwo.readLine(); while(s!=null) i+; out.write(i+ +s); out.newLine(); s=inTwo.readLine(); inOne.close(); inTwo.close(); out.flush(); out.close(); tofile.clos

6、e(); catch(IOException e) 4.3.1程序代码import java.io.*;import java.util.*;public class kehou1043 public static void main(String args) File file = new File(a.txt); Scanner sc = null; double sum=0; int count = 0; try sc = new Scanner(file); sc.useDelimiter(0123456789.+); while(sc.hasNext() try double pri

7、ce = sc.nextDouble(); count+; sum = sum+price; System.out.println(price); catch(InputMismatchException exp) String t = sc.next(); System.out.println(平均价格:+sum/count); catch(Exception exp) System.out.println(exp); 4.3.2运行界面第十一章2.1.1程序代码import java.sql.*;import java.util.*;public class kehou1121 publi

8、c static void main(String args) Query query=new Query(); String dataSource=myData; String tableName=goods; Scanner read=new Scanner(System.in); System.out.print(输入数据源名:); dataSource = read.nextLine(); System.out.print(输入表名:); tableName = read.nextLine(); query.setDatasourceName(dataSource); query.se

9、tTableName(tableName); query.setSQL(SELECT * FROM +tableName); query.inputQueryResult(); class Query String datasourceName=; /数据源名 String tableName=; /表名 String SQL; /SQL语句 public Query() try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) System.out.print(e); public voi

10、d setDatasourceName(String s) datasourceName = s.trim(); public void setTableName(String s) tableName = s.trim(); public void setSQL(String SQL) this.SQL = SQL.trim(); public void inputQueryResult() Connection con; Statement sql; ResultSet rs; try String uri = jdbc:odbc:+datasourceName; String id =

11、; String password = ; con = DriverManager.getConnection(uri,id,password); DatabaseMetaData metadata = con.getMetaData(); ResultSet rs1 = metadata.getColumns(null,null,tableName,null); int 字段个数 = 0; while(rs1.next() 字段个数+; sql = con.createStatement();/创建SQL语句 rs = sql.executeQuery(SQL);/执行SQL语句 while

12、(rs.next() for(int k=1;k=字段个数;k+) System.out.print( +rs.getString(k)+ ); System.out.println(); con.close(); catch(SQLException e) System.out.println(请输入正确的表名+e); 2.1.2运行界面2.2.1程序代码import java.sql.*;import java.util.*;public class kehou1122 public static void main(String args) Q query = new Q(); Stri

13、ng dataSource = myData; String tableName = goods; query.setDatasourceName(dataSource); query.setTableName(tableName); String name = ; Scanner read=new Scanner(System.in); System.out.print(商品名:); name = read.nextLine(); String str=%+name+%; String SQL = SELECT * FROM +tableName+ WHERE name LIKE +str;

14、 query.setSQL(SQL); System.out.println(tableName+表中商品名是+name+的记录); query.inputQueryResult(); class Q String datasourceName=; /数据源名 String tableName=; /表名 String SQL; /SQL语句 public Q() try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) System.out.print(e); public void se

15、tDatasourceName(String s) datasourceName = s.trim(); public void setTableName(String s) tableName = s.trim(); public void setSQL(String SQL) this.SQL = SQL.trim(); public void inputQueryResult() Connection con; Statement sql; ResultSet rs; try String uri = jdbc:odbc:+datasourceName; String id = ; St

16、ring password = ; con = DriverManager.getConnection(uri,id,password); DatabaseMetaData metadata = con.getMetaData(); ResultSet rs1 = metadata.getColumns(null,null,tableName,null); int 字段个数 = 0; while(rs1.next() 字段个数+; sql = con.createStatement(); rs = sql.executeQuery(SQL); while(rs.next() for(int k

17、=1;k=字段个数;k+) System.out.print( +rs.getString(k)+ ); System.out.println(); con.close(); catch(SQLException e) System.out.println(请输入正确的表名+e); 2.2.2运行界面2.3.1程序代码import java.sql.*;import java.util.*;public class kehou1123 public static void main(String args) Q1 query = new Q1(); String dataSource = my

18、Data; String tableName = goods; query.setDatasourceName(dataSource); query.setTableName(tableName); String SQL = SELECT * FROM +tableName+ ORDER BY madeTime; query.setSQL(SQL); System.out.println(tableName+表记录按商品生产日期前后排序是: ); query.inputQueryResult(); class Q1 String datasourceName=; /数据源名 String ta

19、bleName=; /表名 String SQL; /SQL语句 public Q1() try Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); catch(ClassNotFoundException e) System.out.print(e); public void setDatasourceName(String s) datasourceName = s.trim(); public void setTableName(String s) tableName = s.trim(); public void setSQL(String SQL

20、) this.SQL = SQL.trim(); public void inputQueryResult() Connection con; Statement sql; ResultSet rs; try String uri = jdbc:odbc:+datasourceName; String id = ; String password = ; con = DriverManager.getConnection(uri,id,password); DatabaseMetaData metadata = con.getMetaData(); ResultSet rs1 = metadata.getColumns(null,null,tableName,null); int 字段个数 = 0; while(rs1.next() 字段个数+; sql = con.createStatement(); rs = sql.executeQuery(SQL); while(rs.next()