%@ 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
Iterating on each Row using the MetaData
Iterating on each Column getting the MetaData
metaData:
Iterating over each Row of the result
Iterating over Columns without knowing the name or index
Putting it all together
drop table mytable