1、首先下载驱动包：Access_JDBC30.jar,网上有很多资源下载，可以自行百度
2、建立一个Access数据库文件：a1.mdb,文件放在d盘根目录。新建student表，增加字段
3、输入代码：
public void connectionAccess() throws Exception {
Class.forName("com.hxtt.sql.access.AccessDriver")
Connection conn = DriverManager.getConnection("jdbc:Access:///d:/a1.mdb");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from student");
while (rs.next()) {
System.out.print(rs.getString(1) + " ");
System.out.print(rs.getString(2) + " ");
System.out.print(rs.getString(3) + " ");
System.out.print(rs.getString("class") + " ");
System.out.print(rs.getString("stuNumber") + " ");
System.out.println(rs.getString("time"));
}
rs.close();
stmt.close();
conn.close();
}
4、运行测试
