JAVA Gurus,
Can some one help me ?
I am using JSWDK-1.0 (downloaded from Sun Website) to play with JSP and Servlet. I generated a ResultSet (rs) in a servlet and I would like to pass this resultset rs to a JSP. The code I wrote as:
public void doGet(HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException
...
Class.forName(strDrivername);
Connection conn = DriverManager.getConnection(strUrl, strUserid, strPassword );
Statement strStatement;
strStatement = conn.createStatement();
strSql = "select * from " + request.getParameter("TableName");
rs = strStatement.executeQuery(strSql);
/*
out.println("Successfully generated ResultSet! <BR>");
while (rs.next())
{
out.println(rs.getString(1));
}
*/
// The following lines can not be compiled
// compiler said method not found
request.setAttribute("rs", rs);
RequestDispatcher rd = getServletContext().getRequestDispatcher("../jsp/format_RS.jsp");
rd.forward(request, response);
many thanks in advance
Jeff