%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
JSTL: SQL action examples
<% request.setAttribute("newName", new String("Paul van Dyk")); %>
SQL Query Execution using parameters
Using parameter marker's to insert values in the SQL statements
create table mytable (
nameid int primary key,
name varchar(80)
)
INSERT INTO mytable VALUES (1,'Paul Oakenfold')
INSERT INTO mytable VALUES (?,'Timo Maas')
INSERT INTO mytable VALUES (?,?)
SELECT * FROM mytable
drop table mytable