以前做过用jsp连接Access,但时间久了都忘了。这次发出来,作个备忘。
Connection conn; //连接对象
Statement stmt; //语句对象
PreparedStatement pStatement = null;
ResultSet rs; //结果集对象
String accessdriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //保存Access驱动程序字符串
String accessURL =
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; //保存Access连接字符串
String realPath = request.getRealPath("\\WEB-INF\\db\\rsc.mdb");//Access数据库绝对路径
……
try {
//数据库连接
Class.forName(accessdriver);
conn = DriverManager.getConnection(accessURL + realPath);
//数据库查询
pStatement = conn.prepareStatement(sql01);
pStatement.setString(1, myid);
rs = pStatement.executeQuery();
while (rs.next()){……
}
rs.close();
pStatement.close(); //第一次查询完毕,关闭rs和pStatement
}
catch (Exception e) {
System.out.println(e.getMessage());
}