Presenting database content using tags : Database « JSP « Java

Presenting database content using tags

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"

<%@ taglib prefix="sql" uri="" %>
<%@ taglib prefix="c" uri="" %>
<title>Presenting database content using tags</title>

<h1>Address List</h1>
<sql:query dataSource="${conn}" var="addresses">
    SELECT * FROM AddressList
<table width="90%" border="1">
<!-- add the table column headings -->
<c:forEach var="columnName" items="${addresses.columnNames}">
  <th> <c:out value="${columnName}"/> </th>
<!-- add the table rows from the result set -->
<c:forEach var="row" items="${addresses.rowsByIndex}">
    <c:forEach var="column" items="${row}">
      <td><c:out value="${column}"/></td>


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.Using a Result object
16.Calling a Stored procedure within a JSP
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