JSP连接Access数据库备忘

以前做过用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());
    }