Displaying Multiple values Returned from a Stored Procedure using JSTL

[LaTeef Lusk]

I have a stored procedure that can return up to 10 values. Is there a way to use jstl to go through the values to see if there is a match to a predefined variable.

As an example. The SP returns 3 types of fruit
Orange
Banana
Apple

I have a variable defined as FruitA = 'Apple'. I want to take the value of the stored procedure and assign it to variable defined as FruitB. Then I want to compare the 2 and if they match then display some text.

Here is my code but it only returns the first value that the stored procedure returns:

<c:set var="fruitA" value="Apple"/>
<c:forEach items="${resultSet.rows}" var="rowData">  
    <c:set var="fruitB" value="${resultSet.rowData['FRUIT']}"/>    
    <c:if test="${fruitA == fruitB}" >
    <p>We have this fruit in stock!</p>
</c:forEach>

[Bear Bibeault]

That's because resultsets are not suitable for use in a JSP. In your Java code, collect the resultset values into a Java collection for passing to the JSP.