输入代码:
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();
}