JSTL: Transaction with a JSP : Database « JSP « Java

JSTL: Transaction with a JSP

<%@ taglib uri="http://java.sun.com/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jstl/sql" prefix="sql" %>
      <TITLE>Using a Transaction with a JSP</TITLE>
<body bgcolor="white">
          <h2>View table Data</h2>
  insert into atable values(2, 'Joe','Id','Feb-24-1996','F')
    <sql:query var="resultObj">
    select * from atable

<c:forEach items="${resultObj.rows}" var="row">
  <c:forEach items="${row}" var="column">
   <td align="right">
     <b><c:out value="${column.key}" /></b>
       <c:out value="${column.value}" />


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.Using a Result object
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