<%@ 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" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%-- query --%> select * from items Date Format Example

There are ${result.rowCount} items in the store.

Name Price Quantity Date Added Formatted Date Formatted Time
${row[0]} ${row[1]} ${row[2]} ${row[3]}