import?java.sql.*;?
public?class?Example14_1?{
???public?static?void?main（String?args[]）?{
??????Connection?con;
??????Statement?sql;?
??????ResultSet?rs;
??????try{??Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
??????}
??????catch（ClassNotFoundException?e）?{
?????????System.out.print（e）;
??????}
??????try?{?
??????????con=DriverManager.getConnection（“jdbc:odbc:mydata“““““）;
??????????sql=con.createStatement（）;
??????????rs=sql.executeQuery（“SELECT?*?FROM?goods?WHERE?price>300000“）;
??????????while（rs.next（））?{
?????????????String?number=rs.getString（1）;
?????????????String?name=rs.getString（2）;
?????????????Date?date=rs.getDate（“madeTime“）;
?????????????double?price=rs.getDouble（“price“）;
?????????????System.out.printf（“%-4s“number）;
?????????????System.out.printf（“%-6s“name）;
?????????????System.out.printf（“%-15s“date.toString（））;?
?????????????System.out.printf（“%6s\n“price）;
??????????}
??????????con.close（）;
??????}
??????catch（SQLException?e）?{?
?????????System.out.println（e）;
??????}
??}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1854??2011-12-19?14:35??例子1\Example14_1.class

?????文件???????1052??2011-12-19?14:35??例子1\Example14_1.java

?????文件?????143360??2011-12-19?14:35??例子1\shop.mdb

?????目錄??????????0??2011-12-19?15:31??例子1

-----------?---------??----------?-----??----

???????????????146266????????????????????4