<%@ 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 --%>
<%-- update --%>
update items set price = ? where name = ?
<%-- query --%>
JSTL SQL Example
<%-- display results --%>
The total number of records is ${items.rowCount}.