String sitePath = request.getRealPath("/");
String dbPath = sitePath+"db1.mdb";
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbPath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement statement=con.createStatement();
String sql="select * from counts where id=1";
ResultSet rs =statement.executeQuery(sql);
String dbPath = sitePath+"db1.mdb";
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbPath;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection(strurl);
Statement statement=con.createStatement();
String sql="select * from counts where id=1";
ResultSet rs =statement.executeQuery(sql);
如果放在项目下 ,那可以用相对路径 request.getRealPath("/[如果放在文件夹下,这里填文件夹名]");
绝对路径:如放在C盘 :c:/文件名