----- Original Message -----
Sent: Tuesday, October 19, 1999 3:40
PM
Subject: Passing a ResultSet from Servlet
to JSP
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
