package bluec.base;import java.sql.Connection;
import java.sql.DriverManager;public class CConnect { public static Connection getConnection() {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ = F:/ydtvip.mdb";
String user = "";
String pwd = "";
try {
Class.forName(driver);
return DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
System.err.println("异常:"+e.getMessage());
return null;
}
}
}
异常:[Microsoft][ODBC Microsoft Access Driver] 文件名无效。
import java.sql.DriverManager;public class CConnect { public static Connection getConnection() {
String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ = F:/ydtvip.mdb";
String user = "";
String pwd = "";
try {
Class.forName(driver);
return DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
System.err.println("异常:"+e.getMessage());
return null;
}
}
}
异常:[Microsoft][ODBC Microsoft Access Driver] 文件名无效。
试试
String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="+application.getRealPath("/ydtvip.mdb");最好把路径写到配置文件里 然后取相对路径
这是JAVA文件,不是JSP文件里面,用不了application
当前的路径可以获取到吧