<%@ 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