JSTL Tutorials

The <x: forEach> tag is used for looping a list of elements in an xml document. Syntax of <x: forEach> Tag Attributes of <x: forEach> Tag Example Details of the Code <c:set var=”fruitss”> tag is used to set the variable name which we want to display in the output. <x:parse xml=”${fruitss}” var=”output”/> tag is used …

Transaction means handling set of tasks into single execution unit. It provides connection to all data base operations and executes all statements in one transaction. This tag combines both and tags into transactions. We can add and statements into to make single transaction. Attributes of <sql:transaction> Tag dataSource: It specifies datasource for the connection. isolation:It …

The <sql: dateParam> tag is used to add parameter to sql statement to the given java.util.Date value. This tag uses action of both <sql: query> and <sql: update> to provide data and time value for value placeholder. Attributes of <sql: dateParam> Tag value: It is used to add value of the parameter for DATE or …

<sql: param> tag is used to set parameter values for SQL statement. This tag uses action of both <sql: query> and <sql: update> to provide value for value placeholder. Attribute of <sql: param> tag value: It is used to specify value to the parameter. Example of <sql: param> tag Details of the Code <sql: setDataSource …

The <sql: update> tag executes SQL statement specified in the sql attribute or in the tag body, for example SQL INSERT, UPDATE or DELETE statements. Attributes of <sql: setupdate>Tag sql: It specifies SQL command that has to be executed. var: It is used to specify variable name used to store result of query. scope: It …

The <sql:query> tag is used to execute a query specified in sql attribute or in the body. It executes SQL statement and saves in the scoped variable. It executes sql query and stores result in specified variable. Attributes of <sql: query>Tag sql: It specifies SQL command that has to be executed. var: It is used …

The JSTL SQL tags help us interact with the relational databases such as Oracle, MySql and more. Syntax for JSTL SQL Tag 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 …

The <x: out> tag is used to display the result of xml path expression and writes result to the jsp writer object. Syntax Of <x: out> Tag Attributes Of <x: out> Tag select: To evaluate the particular object it specifies xml Xpath expression. escapeXML: Accepts special character an convert it to their corresponding character entity …