Overview of JSTL SQL and Core Tags

The JSTL SQL tag library provides various tags for accessing a database, creating a database table, updating, deleting, and querying a database. The SQL tag library URI is: http://java.sun.com/jsp/jstl/sql. The syntax for including the JSTL SQL tag library in a JSP page is the taglib directive shown below. The URI is used to define a namespace for the tag library, which avoids conflicts that could occur if another tag library with similar names for their tags is used on the same JSP page.

<%@ taglib prefix="sql" uri=" http://java.sun.com/jsp/jstl/sql" %>

The different tags in the JSTL SQL tag library are discussed in the following table. All the tag attributes in the table are of java.lang.String type, unless specified to be of another type. Attributes are not required, unless specified to be required.

We will also be using some of the JSTL Core 1.1 tag library tags. JSTL Core 1.1 tag library provides tags for expression evaluation, loops, conditional evaluation, import of URL based resources, and output of the results of expression evaluation. Some familiarity with expression language (EL- http://www.oracle.com/technology/sample_code/tutorials/jsp20/simpleel.html) is required to use the JSTL Core 1.1 tags. The JSTL Core 1.1 tag library tags are discussed in the following table. Attributes are not required, unless specified to be required.