access连接数据库问题.docVIP

access连接数据库问题 import java.sql.*; public class ToAccess { public static void main(String args[]) { try { String url = \jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:\\\\bookshop.mdb\; Class.forName(\sun.jdbc.odbc.JdbcOdbcDriver\); Connection conn = DriverManager.getConnection(url); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(\select * from books\); while (rs.next()) { System.out.println(\The book\s name is:\ + rs.getString(\book\)); System.out.println(\The author is: \ + rs.getString(\author\)); } rs.close();