Thursday, March 26, 2009

Generic JSTL Code That Displays Database Results

The following generic JSTL code displays database query results in a table irrespective of how many columns the ResultSet has. The table heading will contain column names.

<table width='90%'>
<tr>
<c:forEach var="columnName" items="${queryResults.columnNames}">
<th><c:out value="${columnName}"/></th>
</c:forEach>
</tr>
<c:forEach var="row" items="${queryResults.rows}">
<tr>
<c:forEach var="columnName" items="${queryResults.columnNames}">
<td><c:out value="${row[columnName]}"/></td>
</c:forEach>
</tr>
</c:forEach>
</table>


The queryResults variable holds the ResultSet.

No comments:

Post a Comment