Using a Result object : Database « JSP « Java






Using a Result object

<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
<html>
<HEAD>
      <TITLE>Using a Result object</TITLE>
     </HEAD>
<body bgcolor="white">
<h2>View Database Data</h2>
<c:set var="resultObj" value="${sessionScope[\"javax.servlet.jsp.jstl.sql.Result\"]}" />

<table border="1" cellspacing="2">
<c:forEach items="${resultObj.rows}" var="row">
  <c:forEach items="${row}" var="column">
    <tr>
     <td align="right">
       <b><c:out value="${column.key}" /></b>
       </td>
       <td>
         <c:out value="${column.value}" />
         </td></tr>
       </c:forEach>
         </c:forEach>
         </table>
</body>
</html>


           
       








Related examples in the same category

1.JSP Database Demo
2.JSP Database Query
3.A First JSP Database
4.Navigating in a Database Table
5.Joining Tables
6.Filling a Table
7.Display table in Database
8.Selecting records with condition From a Database
9.Navigating in a Database Table 2
10.Using Table Metadata
11.Creating a Table
12.Accessing the table field in Database
13.Fetching Data From a Database
14.JSTL: Transaction with a JSP
15.Calling a Stored procedure within a JSP
16.Presenting database content using tags
17.Obtaining a Connection in JSP
18.Presenting database content
19.Using a DataSource
20.Using Transactions
21.Updating a database using the sql:update tag
22.Using a Preconfigured DataSource
23.Using the SortedMap
24.New Address Creation using executeUpdate
25.Obtaining a database Connection
26.JSP Access to Databases