Java Reference
In-Depth Information
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>
After deploying our application and opening our page in the browser, we can see the
results or our SQL
UPDATE
statement.
As we can see, the zip codes for all rows we inserted earlier were modified by our
SQL
UPDATE
statement.
Deleting Database Data
The
<sql:update>
tag can be used to delete data from the database. This can be
done by placing an SQL
DELETE
statement inside its body. With NetBeans, we can
simply drag the
DB Delete
item from the NetBeans palette into our page.