| <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> |
| |
| <html> |
| <head> |
| <title>JSTL: SQL action examples</title> |
| </head> |
| <body bgcolor="#FFFFFF"> |
| |
| <h1>SQL Transactions</h1> |
| |
| |
| <!-- NOTE: the sql:setDataSource tag is for prototyping and simple applications. You should really use a DataSource object instead --!> |
| |
| <sql:setDataSource |
| var="example" |
| driver="${sessionScope.myDbDriver}" |
| url="${sessionScope.myDbUrl}" |
| user="${sessionScope.myDbUserName}" |
| password="${sessionScope.myDbPassword}" |
| /> |
| |
| <p>You can group transactions together using the <sql:transaction> tag.</p> |
| |
| <h2>Creating table using a transaction</h2> |
| |
| <sql:transaction dataSource="${example}"> |
| <sql:update var="newTable"> |
| create table mytable ( |
| nameid int primary key, |
| name varchar(80) |
| ) |
| </sql:update> |
| </sql:transaction> |
| |
| <p>DONE: Creating table using a transaction</p> |
| |
| <hr> |
| |
| <h2>Populating table in one transaction</h2> |
| |
| <sql:transaction dataSource="${example}"> |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (1,'Paul Oakenfold') |
| </sql:update> |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (2,'Timo Maas') |
| </sql:update> |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (3,'Paul van Dyk') |
| </sql:update> |
| </sql:transaction> |
| |
| <p>DONE: Populating table in one transaction</p> |
| |
| <sql:update var="newTable" dataSource="${example}"> |
| drop table mytable |
| </sql:update> |
| |
| </body> |
| </html> |