Java Reference
In-Depth Information
The attributes and the body of the generated
<sql:update>
tag get populated from
the data we entered in the
Insert DB Insert
window.
We can add a
DB Report
item from the NetBeans palette, so that we can see the
value we inserted into the database. After doing so, the body of our page looks
like this:
<body>
<h2>Hello World!</h2>
<sql:update var="insertedRows" dataSource="jdbc/sample">
INSERT INTO customer (customer_id, name,
discount_code, zip) values
(((select max(customer_id) from customer) + 1),
'Ensode Technology, LLC', 'H', '22030')
</sql:update>
<sql:query var="result" dataSource="jdbc/sample">
SELECT customer_id, name, discount_code, zip FROM
customer where name like ?
<sql:param value="Ensode%" />
</sql:query>
<table border="1">
<!-- column headers -->
<tr>
<c:forEach var="columnName"
items="${result.columnNames}">
<th><c:out value="${columnName}"/></th>
</c:forEach>
</tr>
<!-- column data -->
<c:forEach var="row" items="${result.rowsByIndex}">
<tr>
<c:forEach var="column" items="${row}">
<td><c:out value="${column}"/></td>
</c:forEach>
</tr>
</c:forEach>
</table>
</body>
