JSTL SQL Tags List



The JSTL SQL tags provide SQL support. The URL for the SQL tags is http://java.sun.com/jsp/jstl/sql and the prefix is sql.
All JSP Examples at JSP Source Code Examples
The SQL tag library allows the tag to interact with RDBMSs (Relational Databases) such as Microsoft SQL Server, MySQL, or Oracle. 
The syntax used for including JSTL SQL tags library in your JSP is:
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>  

JSTL SQL Tags List

  • sql:setDataSource - It is used for creating a simple data source suitable only for prototyping.
  • sql:query - It is used for executing the SQL query defined in its sql attribute or the body.
  • sql:update - It is used for executing the SQL update defined in its sql attribute or in the tag body.
  • sql:param - It is used for sets the parameter in an SQL statement to the specified value.
  • sql:dateParam - It is used for sets the parameter in an SQL statement to a specified java.util.Date value.
  • sql:transaction - It is used to provide the nested database action with a common connection.

All JSP Examples at JSP Source Code Examples

Comments