How do i display database results in a JSP?

I have a control servlet that forward the request to the mode开发者_JAVA技巧l servlet.The model servlet retrieves results from a database and forward the display to the jsp.how do i display the result set in the jsp?Do i need to write the sql statement again in the jsp?

---

No, you use the request attributes map to pass data from the controlling Servlet to the JSP page.

Example. Controller Side:

void doGet(HttpServletRequest request, HttpServletResponse response)
{
    List<String> names = Model.getNamesFromDB();
    request.setAttribute("names", names);
    // forward to JSP follows
    ...
}

Example. JSP page:

<%
    List<String> names = (List<String>)request.getAttribute("names");
    // do whatever you want with names
%>