首先安裝office2003,就有了Access2003,啟動Access,建立新數(shù)據(jù)庫finance.mdb,建表user,包含兩個文本型字段username和password，輸入測試數(shù)據(jù)，保存在任意目錄下，比如說D盤下。然后打開控制面板 -> 管理工具 -> 數(shù)據(jù)源 (ODBC),選擇"系統(tǒng)DSN",單擊“添加”,“完成”,彈出的對話框里將"數(shù)據(jù)源名"自定義,比如finance。點"選擇"，找到"D:\finance.mdb"文件，如此一個ODBC數(shù)據(jù)源就配置好了。
1
import java.sql.Connection;
2import java.sql.DriverManager;
3import java.sql.ResultSet;
4import java.sql.SQLException;
5import java.sql.Statement;
6
7
public class AccessTest 
{
8
9
public static void main(String[] args) {
10 Connection conn;
11 Statement stmt;
12 ResultSet rs;
13 try {
14 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
15 } catch (ClassNotFoundException e) {
16 e.printStackTrace();
17
}
18 try {
19 conn = DriverManager.getConnection("jdbc:odbc:finance", "", "");
20 stmt = conn.createStatement();
21 rs = stmt.executeQuery("select * from user");
22 while (rs.next()) {
23 String username = rs.getString(1);
24 String password = rs.getString(2);
25 System.out.println("帳號:" + username);
26 System.out.println("密碼:" + password);
27 }
28 conn.close();
29 } catch (SQLException el) {
30 el.printStackTrace();
31 }
32 }
33
34
}
35