<div dir="ltr" style="text-align: left;" trbidi="on">
<div dir="ltr" style="text-align: left;" trbidi="on">JSTL Param Tag provides the value of the parameter. In SQL update statement, paramters are sent using JSTL Param tag. The <;sql:param>; tag is used to set the parameters to the SQL query. We use this tag to set the placeholders and data to match the placeholder position to insert the data into the database or to update the database records. This tag is used as a nested tag inside the <;sql:query>; to provide the parameters to the query.</p>
<p> <b>Syntax</b><br />
<i><;sql:param value=&#8221;<;string>;&#8221;/>;</i></p>
<p> <b>JSTL Param Tag has following attribute.</b></p>
<p> <b>1. value Attribute: </b>Specifies the value of the parameter.</p>
<p> <b>JSTL <i><;sql:param</i>>; Tag Example:-</b><br />
The following example takes input from the employee and inserts the entered citizen information into the database using the combination of <;sql:query>; and <;sql:param>; tags. The list of records are displayed in tabular manner once the new record has been inserted.</p>
<p> Now let us write a JSP which will make use of <;sql:update>; to execute a SQL DELETE statement to delete one record with id = 103 from the table as follows: </p>
<pre class="highlight" name="code"><;%@ page import="java.io.*,java.util.*,java.sql.*"%>;
<;%@ page import="javax.servlet.http.*,javax.servlet.*" %>;
<;%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>;
<;%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>;

<;html>;
<;head>;
<;title>;JSTL sql:param Tag<;/title>;
<;/head>;
<;body>;
 
<;sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
 url="jdbc:mysql://localhost:3306/DAVDB"
 user="root" password="root"/>;

<;c:set var="empId" value="3333"/>;

<;sql:update dataSource="${snapshot}" var="count">;
 DELETE FROM Employees WHERE Id = ?
 <;sql:param value="${empId}" />;
<;/sql:update>;

<;sql:query dataSource="${snapshot}" 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>;
</pre>
</div>
<p>
<b>Now try to access above JSP, which should display the following result:</b></p>
<table border="1" style="width: 100%px;">
<tbody>
<tr>
<th>Emp ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
</tr>
<tr>
<td>1111</td>
<td>Dinesh</td>
<td>Rajput</td>
<td>27</td>
</tr>
<tr>
<td>2222</td>
<td>Sweety</td>
<td>Rajput</td>
<td>23</td>
</tr>
</tbody>
</table>
<div style="background-color: pink; border-width: thin; text-align: center;"><b><;<;<a href="https://dineshonjava.com/2013/10/jstl-update-tag-example.html">Previous</a> <;<; ; ; || <a href="https://dineshonjava.com/2013/10/jsp-standard-tag-library-jstl-tutorial.html">Index </a>||  ; >;>;<a href="https://dineshonjava.com/2013/10/jstl-sql-dateparam-tag-example.html">Next</a> >;>;</b></div>
<p>
</div>
<div class="wp-post-navigation"> 
									 <div class="wp-post-navigation-pre"> 
									 <a href="https://dineshonjava.com/jstl-update-tag-example/">Previous</a> 
									 </div> 
									 <div class="wp-post-navigation-next"> 
									 <a href="https://dineshonjava.com/jstl-sql-dateparam-tag-example/">Next</a> 
									 </div> 
									</div>
<script type="text/javascript">
jQuery(document).ready(function($) {
 $.post('https://dineshonjava.com/wp-admin/admin-ajax.php', {action: 'mts_view_count', id: '295'});
});
</script>
Strategy Design Patterns We can easily create a strategy design pattern using lambda. To implement…
Decorator Pattern A decorator pattern allows a user to add new functionality to an existing…
Delegating pattern In software engineering, the delegation pattern is an object-oriented design pattern that allows…
Technology has emerged a lot in the last decade, and now we have artificial intelligence;…
Managing a database is becoming increasingly complex now due to the vast amount of data…
Overview In this article, we will explore Spring Scheduler how we could use it by…