In this section, a database table row will be updated. Create a JSP catalogUpdate.jsp in the JSTLSQL project. As in the previous section, set the data source for the JSP page with the setDataSource tag. The UPDATE SQL statement is run with the sql:update tag. Add an Update tag to the JSP page from the Component Palette. The SQL statement has placeholders for specifying IN parameters for the UPDATE statement. Add the UPDATE SQL statement in the sql attribute of the sql:update tag.

<sql:update sql="UPDATE OE.CATALOG SET TITLE=?, AUTHOR=?
WHERE CATALOGID=?">
</sql:update>

The values for the IN parameters are specified with the sql:param tags. Position the cursor in the sql:update statement, and select the Param tag in the JSTL 1.1 SQL Component Palette.

The param value is set with the value attribute in the sql:param tag. To add the value attribute, press the space bar in the sql:param tag and double-click on the value attribute.

Specify the param value...