| <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> |
| <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> |
| |
| <html> |
| <head> |
| <title>JSTL: SQL action examples</title> |
| </head> |
| <body bgcolor="#FFFFFF"> |
| |
| <% request.setAttribute("newName", new String("Paul van Dyk")); %> |
| |
| <h1>SQL Query Execution using parameters</h1> |
| |
| <p>Using parameter marker's to insert values in the SQL statements</p> |
| |
| |
| <!-- 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}" |
| /> |
| |
| <sql:transaction dataSource="${example}"> |
| |
| <sql:update var="newTable"> |
| create table mytable ( |
| nameid int primary key, |
| name varchar(80) |
| ) |
| </sql:update> |
| |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (1,'Paul Oakenfold') |
| </sql:update> |
| |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (?,'Timo Maas') |
| <sql:param value="2"/> |
| </sql:update> |
| |
| <sql:update var="updateCount"> |
| INSERT INTO mytable VALUES (?,?) |
| <sql:param value="3"/> |
| <sql:param value="${newName}"/> |
| </sql:update> |
| |
| <sql:query var="deejay"> |
| SELECT * FROM mytable |
| </sql:query> |
| |
| </sql:transaction> |
| |
| <table border="1"> |
| <c:forEach var="row" items="${deejay.rows}"> |
| <tr> |
| <td><c:out value="${row.NAMEID}"/></td> |
| <td><c:out value="${row.NAME}"/></td> |
| </tr> |
| </c:forEach> |
| </table> |
| |
| <sql:update var="newTable" dataSource="${example}"> |
| drop table mytable |
| </sql:update> |
| |
| |
| </body> |
| </html> |