How to I retrieve records from a db to send to JSP?

[decibel]

Hello, long time php developer here. I'm used to using the following code to retrieve db records and return an array with the results:

$query = "SELECT * FROM users LIMIT 10";
$result = mysql_query($query);
$rows = array();
while($row = mysql_fetch_array($result)){
 array_push($rows, $row);
}
return $rows; 

How can i stuff the results into an array from a Java bean to send an array back to JSP for i can iterate through it in JSP? I'm already connected to the db, i can execute queries, and my bean is accessable from my jsp page... i just need to know how to set up the array and return it.

Thanks again.

[Kuriyama]

I'm not sure if you are using any sort of framework to send queries to your db(ie hibernate), but take a look at result sets.

http://java.sun.com/docs/books/tutor...etrieving.html

[JavaServlet]

Best way to do this is to use a list.
The JSP can get whatever the servlet gives using the request attribute.

Servlet example:

.....
AddressBook addressBook = new AddressBook();
List addressRows = addressBook.getAllAddresses();
request.setAttribute("addressRows", addressRows);
request.getRequestDispatcher("/WEB-INF/webpage/view.jsp").forward(request, response);
...

Fetch in JSP using an iterator inside a Scriptlet:

<&#37;@ page import="com.mypackage.AddressRowBean" %>
<%@ page import="java.util.*" %>
 
<jsp:useBean id="addressRows" type="java.util.List" scope="request"/>
<%
  for(Iterator it = addressRows.iterator(); it.hasNext(); ){
    AddressRowBean row = (AddressRowBean)it.next();
%>
  <%= row.getFirstname() %>
  <%= row.getLastname() %>
<%
  } 
%>

or fetch in JSP using more efficient JSTL:

<c:forEach var="row" items="${addressRows}">     
            ${row.firstname}
            ${row.lastname}
</c:forEach>