Java Reference
In-Depth Information
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
statement.
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.