import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?Database3?{
	public?static?void?main（String?args[]）{
		Connection?connect=null;
		Statement?state=null;
		ResultSet?result=null;
		
		try{
			Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
			connect=DriverManager.getConnection（“jdbc:odbc:shopDB“）;
		}
		catch（Exception?e）{
			System.err.println（“OpenConnect:“+e.getMessage（））;
		}
		
		try{
			state=（Statement）connect.createStatement（）;
			String?sql=“select?*?from?sale“;
			result=state.executeQuery（sql）;
			
			while（result.next（））{
				System.out.print（“?編號：“+result.getString（1））;
				System.out.print（“?名稱：“+result.getString（2））;
				System.out.print（“?價格：“+result.getLong（3））;
				System.out.print（“?出版社：“+result.getString（4））;
			}
			result.close（）;
			state.close（）;
			connect.close（）;
		}
		catch（SQLException?e）{
			System.out.print（“SQL?Exception?occur.?Message?is:“）;
			System.out.print（e.getMessage（））;
		}
	}
}

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

????I.A....????517632??2010-08-17?23:10??報告.doc

?????文件???????1094??2009-11-04?12:07??Database3.java

?????文件???????2448??2009-11-04?14:57??Shopping.java

?????文件?????409600??2009-11-05?09:21??shopDB.accdb

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

???????????????930774????????????????????4