String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String dbUrl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Tomcat/webapps/webApp/data/data.mdb";you maybe need to use the absolutely path to specify it.
String dbUrl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Tomcat/webapps/webApp/data/data.mdb";you maybe need to use the absolutely path to specify it.
http://61.131.30.58/123/Develop/Java/SC/MySource.htm
通过JDBC访问Access数据库,JSP与JavaBean结合,纯Servlet形式
在JSP中转换虚拟路径到实际路径的方法为:servletContext.getRealPath(dbpath)
package com.wfd.portal.common;import javax.sql.DataSource;
import javax.naming.Context;
import javax.naming.InitialContext;import org.springframework.jdbc.datasource.DriverManagerDataSource;public class DBUtil {
private static DataSource ds = null; public static DataSource getDataSource(){
try {
DriverManagerDataSource ds = new DriverManagerDataSource();
ds.setDriverClassName( "sun.jdbc.odbc.JdbcOdbcDriver");
ds.setUrl( "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\WFD\\web\\meixx.mdb");
ds.setUsername( "");
ds.setPassword( "");
return ds;
}
catch (Exception e) {
e.printStackTrace();
throw new RuntimeException("Get Datasource error!\n " + e.getMessage());
}
}
}