Javatpoint Logo
Javatpoint Logo

JSTL SQL Tags

The JSTL sql tags provide SQL support. The url for the sql tags is http://java.sun.com/jsp/jstl/sql and prefix is sql.

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:

JSTL SQL Tags List

SQL Tags Descriptions
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.




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA