Updating database data
As we mentioned earlier, the <sql:update> tag can be used for executing both SQL
INSERT and UPDATE statements in the database. The easiest way to use this tag to
execute an SQL UPDATE statement is to drag the DB Update item from the NetBeans
palette into our page.
In addition to being used to insert rows into a database table, the <sql:update>
tag can be used to modify existing rows in the database table. The main difference
is that an SQL UPDATE statement is used in its body, as opposed to an SQL INSERT
Like most JSTL SQL tags discussed so far, the easiest way to create an <sql:update>
statement that updates existing rows in a database table is to drag the DB Update
item from the NetBeans palette into our page.