<%@ 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