Using the SortedMap


<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<html>
<head>
<title>Using the SortedMap[] </title>
</head>
<body>
<h1>Address List</h1>
<sql:setDataSource dataSource="jdbc/address" var="conn" />

<sql:query dataSource="${conn}" var="addresses">
    SELECT * FROM AddressList
</sql:query>


<table width="90%" border="1">
<!-- add the table rows from the result set -->
<c:forEach var="row" items="${addresses.rows}">
  <tr>
    <c:forEach var="column" items="${row}">
      <td><c:out value="${column}"/></td>
    </c:forEach>
  </tr>
</c:forEach>
</table>

</body>
</html>

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.	Using a Result object
16.	Calling a Stored procedure within a JSP
17.	Presenting database content using tags
18.	Obtaining a Connection in JSP
19.	Presenting database content
20.	Using a DataSource
21.	Using Transactions
22.	Updating a database using the sql:update tag
23.	Using a Preconfigured DataSource
24.	New Address Creation using executeUpdate
25.	Obtaining a database Connection
26.	JSP Access to Databases

Using the SortedMap : Database « JSP « Java

Related examples in the same category