public static void main(String args[]){
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=//192.162.0.123/E/DD.mdb";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");// 加载JDBC-ODBC驱动
} catch (ClassNotFoundException e) {
System.out.println("Error connected!");
}
try {
System.out.println("@@@@@@@@@@");
Connection con = DriverManager.getConnection(url, "", "");
System.out.println("*******");
Statement sql = con.createStatement();
sql=con.createStatement();
ResultSet rs = sql.executeQuery("Select * FROM student");
while(rs.next()){
String name=rs.getString(1); //获得数据库第一列
String sex=rs.getString(2);
System.out.println("姓名:"+name); //输出信息
System.out.println("性别:"+sex);
}
con.close();
System.out.println("===========连接成功");
} catch (SQLException e) {
System.out.println("连接失败."+e.getMessage());
}// 获得连接
}怎么不可以远程连接呀?????????
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=//192.162.0.123/E/DD.mdb";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");// 加载JDBC-ODBC驱动
} catch (ClassNotFoundException e) {
System.out.println("Error connected!");
}
try {
System.out.println("@@@@@@@@@@");
Connection con = DriverManager.getConnection(url, "", "");
System.out.println("*******");
Statement sql = con.createStatement();
sql=con.createStatement();
ResultSet rs = sql.executeQuery("Select * FROM student");
while(rs.next()){
String name=rs.getString(1); //获得数据库第一列
String sex=rs.getString(2);
System.out.println("姓名:"+name); //输出信息
System.out.println("性别:"+sex);
}
con.close();
System.out.println("===========连接成功");
} catch (SQLException e) {
System.out.println("连接失败."+e.getMessage());
}// 获得连接
}怎么不可以远程连接呀?????????
楼主【liyanqing_01】截止到2008-06-24 16:02:58的历史汇总数据(不包括此帖):
发帖数:4 发帖分:70
结贴数:2 结贴分:40
未结数:2 未结分:30
结贴率:50.00 % 结分率:57.14 %
楼主加油
你这种写法好像有问题的。正确的应该是
比如建立名字为accesstest的odbc连接,在odbc的设置里面指定到192.162.0.123的E盘下面的DD.mdb然后在上面的程序中只要引用accesstest这个名字就可以了
2,然后控制面板-〉管理工具-〉ODBC-〉System DSN->Add->Microsoft Access Driver
database名:test
dataBase: e:\db1.mdb3,然后用下面的java代码
String url = "jdbc:odbc:test";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
} catch (ClassNotFoundException e) {
System.out.println("Error connected!");
}
try {
Connection con = DriverManager.getConnection(url, "", "");
System.out.println("*******");
控制面板-〉管理工具-〉ODBC-〉System DSN->Add->Microsoft Access Driver
中设置就可以了