JSTL <sql:update>SQL UPDATE Tag Example

JSTL Update Tag provides capability to write insert, update or delete statements directly from JSP.

The <sql:update> tag executes the provided SQL query through its body or through its sql attribute. Execution SQL queries using <sql:update> tag does not return any data. This tag can execute INSERT, UPDATE and DELETE statements.

Syntax-
<sql:update var=”<string>” scope=”<string>” sql=”<string>” dataSource=”<string>”/>

JSTL <sql:Update> Tag has following attributes.

1. datasource Attribute: Specifies the datasource. Make sure that you already created datasource using serDataSource tag before writing query.

2. sql Attribute: Specifies the SQL statement to run on database.

3. var Attribute: Store the result of SQL statement.

JSTL SQL UPDATE Tag Example:
Now let us write a JSP which will make use of <sql:update> to execute a SQL INSERT statement to create one record in the table as follows:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
    "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>JSTL SQL Tags - setDataSource Example</title>
</head>
<body>

 <sql:setDataSource driver="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/database_name"
            var="localSource" 
            user="database_user"  
            password="database_password"/>
<sql:update dataSource="${snapshot}" var="count">
   INSERT INTO Employees VALUES (333, 27, 'Anamika', 'Rajput');
</sql:update>
 <sql:query dataSource="${localSource}" var="result">
SELECT * from Employees;
</sql:query>
 
<table border="1" width="100%">
<tr>
<th>Emp ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
</tr>
<c:forEach var="row" items="${result.rows}">
<tr>
<td><c:out value="${row.id}"/></td>
<td><c:out value="${row.first}"/></td>
<td><c:out value="${row.last}"/></td>
<td><c:out value="${row.age}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>

Now try to access above JSP, which should display the following result:

Emp ID First Name Last Name Age
1111 Dinesh Rajput 27
2222 Sweety Rajput 23
3333 Anamika Rajput 23
<<Previous <<   || Index ||   >>Next >>

Previous
Next