Java远程连接access

配置access

打开C:\Windows\SysWOW64下odbcad32.exe 文件（如果从别的地方打开，有可能会找不到access驱动）

然后一直点确定，ODBC的access就创建好了

配置rmi_jdbc监听的端口

如果想关闭监听，就把窗口关闭了

测试远程连接

记得把rmi_jdbc的jar包放入项目

public class Test {

    public static void main(String[] args) throws Exception {
         Class.forName("org.objectweb.rmijdbc.Driver").newInstance();
         String url = "jdbc:rmi://192.168.0.26:9000/jdbc:odbc:DS";
         String sql = "SELECT * FROM IP_INFO";
         Connection c = DriverManager.getConnection(url);
         Statement st = c.createStatement();
         ResultSet rs = st.executeQuery(sql);
         ResultSetMetaData md = rs.getMetaData();
         while(rs.next()){
             for(int i=1;i<=md.getColumnCount();i++){
                 System.out.println(rs.getString(i));

             }
         }
    }
}

参考博客
http://blog.csdn.net/f562867448/article/details/39499793
http://blog.csdn.net/rongyongfeikai2/article/details/7620711
http://blog.csdn.net/zrzlj/article/details/2234236