This week's book giveaway is in the Testing forum. We're giving away four copies of The Way of the Web Tester: A Beginner's Guide to Automating Tests and have Jonathan Rasmusson on-line! See this thread for details.
In Java, you should read the data from the result set and put it the request with request.setAttribute. Usually it goes in an arraylist of some custom object. Then in the JSP, you use JSTL to loop through the list and display the relevant data.