从Java向MS Access插入数据

阿祺

我是JDBC新手。我想插入数据。Java的Access中间，但无法获得。它显示了以下错误：
1 V  J# ~0 u& C8 ~! l3 @4 ^& ~* g, GConnection Established Successfully  java.sql.SQLException: General error  Could Not Connect to Database      at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)      at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)      at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)      at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)      at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)      at DBConnect.<i>(DBConnect.java:22)       at DBConnect.main(DBConnect.java:32)代码：
" ]4 O1 {) L. W6 dpublic DBConnect()      File f = new File(&quot;DB.accdb&quot;);    try{          Class.forName(&quot;sun.jdbc.odbc.JdbcOdbcDriver&quot;);        System.out.println(&quot;DriverLoaded&quot;);        String url = &quot;jdbcdbcriver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=&quot;   f.getAbsolutePath()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；Connection con = DriverManager.getConnection(url);        System.out.println(&quot;Connection Established Successfully&quot;);        Statement st=con.createStatement()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；String productId=&quot;1&quot;;        String desc=&quot;Jambu&quot;;        int quantity=10.        double price = 2.0,disc=1.0；           st.executeUpdate(&quot;INSERT into Product(productID,description,quantity,price,discount) VALUES('&quot; productId &quot;','&quot; desc &quot;','&quot; quantity &quot;','&quot; price &quot;','&quot; disc &quot;')&quot;);        System.out.println(&quot;Row is added&quot;);    }catch(Exception e)              e.printStackTrace()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；System.out.println(&quot;Could Not Connect to Database&quot;);               
8 p0 b9 H* M0 v3 `/ M1 o    解决方案: