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.
|
Tag Name |
Description |
Attributes |
|---|---|---|
|
transaction |
Creates a transaction in which a group of SQL statements are run. Establishes a transaction context... |