<%@ 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 --%> <%-- query --%> select code, color from colors where start_time <= now() and end_time > now() <%-- set color and color code --%> So the color is ${color}, and the color code is ${ccode}.