<%@ 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 Query Execution using an iterator

create table mytable ( nameid int primary key, name varchar(80) ) INSERT INTO mytable VALUES (1,'Paul Oakenfold') INSERT INTO mytable VALUES (2,'Timo Maas') INSERT INTO mytable VALUES (3,'Paul van Dyk') SELECT * FROM mytable <%-- TBD by JSR 052 EG

Iterating on each Row using the MetaData

id:

name:

--%>

Iterating on each Column getting the MetaData

metaData:

Iterating over each Row of the result

Iterating over Columns without knowing the name or index

Name:

Value:

Putting it all together

drop table mytable