不用桥接器怎样连Access数据库?
如:在win2k os 中,我在E:\test\ 下有一个test.mdb的Access数据库(是office xp下的),我想不用在control panel下设置dns,直接连上E:\test\test.mdb,怎么办啊?
下面的程序运行时老是出exception:
import java.io.*;
import java.sql.*;
public class PortalDb
{
public static void main(String[] args){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sql = "select * from address";
String dbUrl = "jdbc:odbc:Driver={MicroSoft Access Driver
(*.mdb)}; DBQ=f:/database/access/test.mdb";
Connection con = DriverManager.getConnection(dbUrl,"",""); Statement state = con.createStatement
(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = state.executeQuery(sql);
if( rs != null ){
while( rs.next() ){
System.out.println("name.........." + rs.getString
("name"));
}
rs.close();
con.close();
}
}
catch(Exception e){
e.printStackTrace();
}
}
}//End class
请指教啊.