JSTL sql:dateparam Tag

by Online Tutorials Library July 22, 2022

JSTL SQL <sql:dateParam> Tag

The <sql:dateParam> is used to set the specified date for SQL query parameter.

It is used as nested tag for <sql:update> and <sql:query> to provide the date and time value for SQL query parameter. If null value is provided, the value is set at SQL NULL.

Example:

<% Date DoB = new Date(“2000/10/16”); int studentId = 151; %>     UPDATE Student SET dob = ? WHERE Id = ?        <param value="<%=studentId%>">  

JSTL SQL <sql:dateParam> Complete Example

Consider the below information about your MySQL database setup:

We are using the JDBC MySQL driver
We are using the test database on local machine
We are using the “root” as username and “1234” as password to access the test database.

To understand the basic concept, let us create a simple table Student in the test database and creates the few records in that table using command prompts as follows:

Step-1: Open the command prompt and change to the installation directory as follows:

 C:Userstutoraspire> C:Userstutoraspire>cd C:Program FilesMySQLMySQL Server 5.7bin C:Program FilesMySQLMySQL Server 5.7bin> 

It will look like this:

JSTL SQL Tag16

Step-2: Login to the database using command prompt as shown below:

 C:Program FilesMySQLMySQL Server 5.7bin>mysql -u root -p Enter password: **** mysql> 

It will look like this:

JSTL SQL Tag17

Step-3: Create the table Students in test database as shown below:

 mysql> use test; mysql> create table Student     (      id int not null,      First_Name varchar (255),      Last_Name varchar (255),      dob date     ); Query OK, 0 rows affected (0.08 sec) mysql> 

It will look like this:

JSTL SQL Tag18

Step 4: In final step you need to create few data records in Students table as shown below:

 mysql> INSERT INTO student VALUES (150, ‘Nakul’, ‘Jain’, ‘1994/07/19’ ); Query OK, 1 row affected (0.05 sec)   mysql>  INSERT INTO Student VALUES (151, ‘Ramesh’, ‘Kumar’, ‘1992/03/9’); Query OK, 1 row affected (0.00 sec)   mysql>  INSERT INTO Student VALUES (152, ‘Ajeet’, ‘Singhal’, ‘1992/01/23’ ); Query OK, 1 row affected (0.00 sec)   mysql> INSERT INTO Student VALUES (153, ‘Hamza’, ‘Hussain’, ‘1992/01/9’); Query OK, 1 row affected (0.00 sec)   mysql> 

It will look like this:

JSTL SQL Tag19

Let’s see the simple JSP example to understand the use of <sql:dateParam> tag:

<%@ page import=”java.io.*,java.util.*,java.sql.*”%> <%@ page import=”javax.servlet.http.*,javax.servlet.*” %> <%@ page import=”java.util.Date,java.text.*” %> <%@ taglib uri=”http://java.sun.com/jsp/jstl/core” prefix=”c”%> <%@ taglib uri=”http://java.sun.com/jsp/jstl/sql” prefix=”sql”%>     <title>sql:dateParam Tag</title>       <% Date DoB = new Date(“2000/10/16”); int studentId = 151; %>       UPDATE Student SET dob = ? WHERE Id = ?        <param value="<%=studentId%>">        SELECT * from Student;    
<table border="2" width="100%">
<tr>
<th>Emp ID</th>
<th>First Name</th>
<th>Last Name</th>
<th>DoB</th>
</tr>
<tr>                     </tr>
</table>
<p>     </p>

Output:

JSTL SQL Tag20

Next TopicJSTL SQL <sql:transaction> Tag

beginners c core example fmt fn formatting function introduction jsp jstl miscellaneous professionals servlet sql tags tutorial

JSTL sql:dateparam Tag

JSTL SQL <sql:dateParam> Tag

JSTL SQL <sql:dateParam> Complete Example

Scatter | Gather | Vectored IO

C# Implicitly Typed Local Variable

You may also like