Javatpoint Logo
Javatpoint Logo

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:

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:

It will look like this:

JSTL SQL Tag16

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

It will look like this:

JSTL SQL Tag17

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

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:

It will look like this:

JSTL SQL Tag19

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

Output:

JSTL SQL Tag20



Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA