JSTL SQL Tags Library

The JSTL SQL tags help us interact with the relational databases such as Oracle, MySql and more.

Syntax for JSTL SQL Tag

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

The JSTL SQL Tags

  • <sql:setDataSource >: It is used for creating data source that is to be accessed by executing a query.
  • <sql:query >: It is used to execute a query specified in a jsp page.
  • <sql:update>: It is used to update SQL statements defined in its body or by the sql attribute.
  • <sql:param >: It sets parameter to the sql statement to the given value.
  • <sql:dateParam >: It is used to add parameter to sql statement to the given java.util.Date value.
  • <sql: transaction >: It provides connection to all data base operations and executes all statements in one transaction.

Previous Tutorial : JSTL XML x:param Tag :: Next Tutorial : JSTL SQL sql:query Tag

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>