Question

java连接access出错

各位大哥大姐，麻烦帮忙解决一下，下面是我的java代码和报的错误：
Connection conn=null;
String spath="dic/EduData.mdb";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+spath;
String result="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
ResultSet rs= stmt.executeQuery("select explain from DicEn where word='"+word+"'");
while(rs.next())
{
result+=rs.getString("explain");
}
System.out.println(result);
}catch(Exception e){
System.out.println(e);
}
---------------------------------------------------------------------------------------------------------
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]常见错误 无法打开注册表项“Temporary (volatile) Ace DSN for process 0x1768 Thread 0x7a4 DBC 0x18f87c3c Jet”。

Answer 1

链接access是要去那个控制面板的数据源里配置的。要指定你说的那个数据库文件的名字和路径。然后在java里的代码我的是这样的。
public String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
public String URL = "jdbc:odbc:shop";//shop是你在数据源里配置的配置项的名字
Class.forName(DRIVER);
Connection con = DriverManager.getConnection(URL);
Statement stmt = con.createStatement();
String sql = "。。。。。。。。。。。";
stmt.executeQuery(sql);