首先安装office2003,就有了Access2003,启动Access,建立新数据库finance.mdb,建表user,包含两个文本型字段username和password&＃xff0c;输入测试数据&＃xff0c;保存在任意目录下&＃xff0c;比如说D盘下。然后打开控制面板 -> 管理工具 -> 数据源 (ODBC),选择"系统DSN",单击“添加”,“完成”,弹出的对话框里将"数据源名"自定义,比如finance。点"选择"&＃xff0c;找到"D:\finance.mdb"文件&＃xff0c;如此一个ODBC数据源就配置好了。
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 &＃61; DriverManager.getConnection("jdbc:odbc:finance", "", "");
20 stmt &＃61; conn.createStatement();
21 rs &＃61; stmt.executeQuery("select * from user");
22 while (rs.next()) {
23 String username &＃61; rs.getString(1);
24 String password &＃61; rs.getString(2);
25 System.out.println("帐号:" &＃43; username);
26 System.out.println("密码:" &＃43; password);
27 }
28 conn.close();
29 } catch (SQLException el) {
30 el.printStackTrace();
31 }
32 }
33
34
}
35
import java.sql.Connection;2
import java.sql.DriverManager;3
import java.sql.ResultSet;4
import java.sql.SQLException;5
import 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 &＃61; DriverManager.getConnection("jdbc:odbc:finance", "", "");20
stmt &＃61; conn.createStatement();21
rs &＃61; stmt.executeQuery("select * from user");22
while (rs.next()) {23
String username &＃61; rs.getString(1); 24
String password &＃61; rs.getString(2);25
System.out.println("帐号:" &＃43; username);26
System.out.println("密码:" &＃43; password);27
}28
conn.close();29
} catch (SQLException el) {30
el.printStackTrace();31
}32
}33
34
}35
京公网安备 11010802041100号