%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
JSTL: SQL action examples
SQL Transactions
You can group transactions together using the <sql:transaction> tag.
Creating table using a transaction
create table mytable (
nameid int primary key,
name varchar(80)
)
DONE: Creating table using a transaction
Populating table in one transaction
INSERT INTO mytable VALUES (1,'Paul Oakenfold')
INSERT INTO mytable VALUES (2,'Timo Maas')
INSERT INTO mytable VALUES (3,'Paul van Dyk')
DONE: Populating table in one transaction
drop table mytable