JSTL SQL Tag sql:dateParam Example

Details
Written by  
Last Updated on 31 August 2019   |   Print  Email


This post helps you understand how to use the <sql:dateParam> tag in the JSTL SQL tags library with code example.

The <sql:dateParam> tag is used to set the date time information as parameter in the SQL queries. The <sql:dateParam> tag is a nested tag for <sql:query> to supply any parameter values which are either date or time or timestamp.

 

JSTL <sql:dateParam> Syntax:

<sql:dateParam value="<string>" type="<string>"/>

 

Attributes:

Name

Required

Description

value

True

Parameter value for DATE or TIME or TIMESTAMP.

type

False

Type of the parameter. Possible values are DATE or TIME or TIMESTAMP.Default is TIMESTAMP.

 

JSTL <sql:dateParam> Example:

The following JSP code example takes input from user’s first name, last name and date of birth and inserts the information into the table.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>  
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
    
<!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>&lt;sql:dateParam&gt; Demo</title>
  </head>
  <body>
    <h1>&lt;sql:dateParam&gt; Demo</h1>
    <form name="citizenDOBForm"
    action="${pageContext.request.contextPath}/tag-types/sql/dateparam.jsp" 
        method="POST">
    <table border="0">            
      <tr>
        <td>* Enter First Name:</td>
        <td><input type="text" name="firstName" />
      </tr>
      <tr>
        <td>* Enter Last Name:</td>
        <td><input type="text" name="lastName" />
      </tr>
      <tr>
        <td>* Enter Date of Birth: (yyyy/MM/dd)</td>
        <td><input type="text" name="dateOfBirth" /></td>
      </tr>            
      <tr>
        <td><input type="submit" value="Submit"/></td>
      </tr>
    </table>        
     </form>
     <br/><br/>
    
    <fmt:parseDate value="${param.dateOfBirth}" var="parsedDateOfBirth" pattern="yyyy/MM/dd" />
    
    <sql:setDataSource var="myDS" driver="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost:3306/test" user="root" password="" />
        
    <c:choose>
    <c:when test="${not empty param.firstName 
                      && not empty param.lastName 
                      && not empty param.dateOfBirth}">        
        <sql:update dataSource="${myDS}" var="citizenDOB">
            INSERT INTO citizens_dob (first_name, last_name, date_of_birth) VALUES (?, ?, ?)            
            <sql:param value="${param.firstName}" />
            <sql:param value="${param.lastName}" />
            <sql:dateParam value="${parsedDateOfBirth}" type="DATE"/>            
        </sql:update>
    </c:when>
    <c:otherwise>
        <font color="#cc0000">Please enter mandatory information.</font>
    </c:otherwise>
    </c:choose>
    
    <br/><br/>
    <sql:query dataSource="${myDS}" var="citizens">
        SELECT * from citizens_dob;
    </sql:query>
    <table border="1">
        <c:forEach var="row" items="${citizens.rows}">
            <tr>                
                <td><c:out value="${row.first_name}" /></td>
                <td><c:out value="${row.last_name}" /></td>
                <td><c:out value="${row.date_of_birth}" /></td>                
            </tr>
        </c:forEach>
    </table>
    </body>
</html>

 

Database (MySQL) Table

The following snippet is the MySQL database sample table used for the above example.

CREATE TABLE IF NOT EXISTS citizens_dob (
    first_name VARCHAR(30),
    last_name VARCHAR(30),
    date_of_birth date
) engine=InnoDB DEFAULT CHARSET=utf8;

 

Output:

sql-dateparam

 

Recommended Usage of JSTL <sql:dateParam> tag:

The <sql:dateParam> tag is used to provide date parameter value for the placeholders in the SQL query. This tag is useful in SQL queries when dealing with date, time or timestamp information.

 

Other JSTL SQL Tags:

param  |  query  |  setDataSource  |  transaction  |  update


About the Author:

is certified Java programmer (SCJP and SCWCD). He started programming with Java in the time of Java 1.4 and has been falling in love with Java since then. Make friend with him on Facebook and watch his Java videos you YouTube.



Add comment