Home » JSTL sql:param Tag

JSTL sql:param Tag

by Online Tutorials Library

JSTL SQL <sql:param> Tag

The <sql:param> tag sets the parameter value in SQL statement.

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

Example:

JSTL SQL <sql:param> 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 Students 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 Tag11

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

It will look like this:

JSTL SQL Tag12

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

It will look like this:

JSTL SQL Tag13

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 Tag14

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

This will produce the following result:

JSTL SQL Tag15

You may also like