Java Reference
In-Depth Information
Just as we did in previous examples, we will drag the DB Report item from the
NetBeans palette into our page, so that we can see the effect the DELETE statement
had in the database. After doing so, the body of our page now looks like this:
<h2>Hello World!</h2>
<sql:update var="deletedRows" dataSource="jdbc/sample">
DELETE FROM customer
WHERE name like ?
<sql:param value="Ensode%"/>
<sql:query var="result" dataSource="jdbc/sample">
SELECT customer_id, name, discount_code, zip FROM customer
where name like ?
<sql:param value="Ensode%" />
<table border="1">
<!-- column headers -->
<c:forEach var="columnName" items="${result.columnNames}">
<th><c:out value="${columnName}"/></th>
<!-- column data -->
<c:forEach var="row" items="${result.rowsByIndex}">
<c:forEach var="column" items="${row}">
<td><c:out value="${column}"/></td>
After executing our page by right-clicking on it and selecting Run File from the pop
up menu, we can see the results of our DELETE statement.
Search WWH ::

Custom Search