How can I access the ResultSet without ScriptLet mixed in the JSP?

[Wei Geng]

I got a java.sql.ResultSet instance when I executed a query statement in the Servlet. I want to transfer the ResultSet instance to the JSP page to display the query result without ScrpitLet mixed into the JSP page.

It seems that it is a better way to convert the ResultSet instance to a javax.servlet.jsp.jstl.sql.Result object and access the Result object in a <c:forEach>.How can I realize the convertion?

If it cannot be realized, is there any way by which JSP page could access ResultSet object without ScriptLet.

Please introduce the involved methods or patterns.
Thanks!

[Paul Strachan]

you cant use a result set with jstl because ResultSet does not follow java bean convention for getter method - better to populate a collection of java bean from the original result set. this also has advantage so you can close your ResultSet, Statement and Connection to free resources earlier.