JSTL: Transaction with a JSP : Database « JSTL « 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.JSTL SQL Query
2.JSTL SQL Update
3.Updating a database using the sql:update tag
4.Presenting database content using tags
5.SQL Tag Out Examples