<%@ page contentType="text/html" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %> <%-- set data source --%> <%-- do insert first --%> insert into items values (?, ${param.price}, ${param.quantity}) <%-- query --%> select * from items Items
${cn}
${col}