while(rs.next()) { System.out.println( "A = " + rs.getInt("a")); System.out.println( "B = " + rs.getString("b")); }}catch(Exception e) { e.printStackTrace(); } } public static void main(String[] args){ new AccessDb(); } }
我建好的数据库 ,然后执行程序时 出现: Access 驱动: ok java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未 知的)'。 at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2488) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3 17) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:160) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at AccessDb.init(AccessDb.java:22) at AccessDb.<init>(AccessDb.java:11) at AccessDb.main(AccessDb.java:45) Press any key to continue... 怎么个情况?!
Statement sta;
ResultSet rs; public AccessDb()
{
init();
} public void init() { try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("Access 驱动: ok");
con = DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb","","");
System.out.println("Access 连接: ok");
System.out.println("---------------------------");
sta = con.createStatement();
rs = sta.executeQuery("select * from test");
while(rs.next()) {
System.out.println( "A = " + rs.getInt("a"));
System.out.println( "B = " + rs.getString("b"));
}}catch(Exception e) { e.printStackTrace();
} } public static void main(String[] args){ new AccessDb(); } }
出现:
Access 驱动: ok
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] 找不到文件 '(未
知的)'。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2488)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
17)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:160)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at AccessDb.init(AccessDb.java:22)
at AccessDb.<init>(AccessDb.java:11)
at AccessDb.main(AccessDb.java:45)
Press any key to continue...
怎么个情况?!
强烈介意不用Access
NCpiro()给的代码中的test.mdb应该改成自己的数据库名,也就是建立的数据源名。