%@ taglib prefix="sql" uri="http://java.sun.com/jstl/ea/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/ea/core" %>
JSTL: SQL action examples
SQL Update Execution
create table mytable (
nameid int primary key,
name varchar(80)
)
Inserting three rows into table
INSERT INTO mytable VALUES (1,'Paul Oakenfold')
INSERT INTO mytable VALUES (2,'Timo Maas')
INSERT INTO mytable VALUES (3,'Paul van Dyk')
DONE: Inserting three rows into table
SELECT * FROM mytable
Deleting second row from table
DELETE FROM mytable WHERE nameid=2
DONE: Deleting second row from table
SELECT * FROM mytable
drop table mytable