%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/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 over each Row of the result
Iterating over Columns without knowing the index
Putting it all together
<%-- Easiest example showing how to populate a table --%>
<%-- Get the column names for the header of the table --%>
|
<%-- Get the value of each column while iterating over rows --%>
|
drop table mytable