[1].[代码] [Java]代码
02 | Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); |
03 | String url = "jdbc:odbc:Driver={Microsoft Access Driver " + |
04 | "(*.mdb, *.accdb)};DBQ=C:\\Database\\Northwind 2007.accdb" ; |
05 | Connection con = DriverManager.getConnection(url); |
06 | System.out.println( "Connected!" ); |
08 | } catch (SQLException e) { |
09 | System.out.println( "SQL Exception: " + e.toString()); |
10 | } catch (ClassNotFoundException cE) { |
11 | System.out.println( "Class Not Found Exception: " + cE.toString()); |
[2].[代码] 带密码的访问
01 | static class MyConnention{ |
02 | public static Connection getConnection() throws Exception{ |
08 | String url1= "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=f:/data/db1.accdb;pwd=qing" ; |
09 | Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance(); |
10 | Connection c=DriverManager.getConnection(url1); |
[3].[代码] 使用相对路径
01 | static class MyConnention{ |
02 | public static Connection getConnection() throws Exception{ |
05 | Class theClass=MyConnention. class ; |
06 | java.net.URL u= theClass.getResource( "db/db1.accdb" ); |
07 | String url=u.getPath().substring( 1 ,u.getPath().length()).replaceAll( "%20" , " " ); |
08 | String url1= "jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" +url+ ";pwd=qing" ; |
09 | Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ).newInstance(); |
10 | Connection c=DriverManager.getConnection(url1); |
[4].[图片] 代码截图
转载于:https://www.cnblogs.com/tfgzs/articles/3480927.html