Home » JSTL sql:query Tag

JSTL sql:query Tag

by Online Tutorials Library

JSTL SQL <sql:query> Tag

The <sql:query> tag is used for executing the SQL query defined in its sql attribute or the body. It is used to execute an SQL SELECT statement and saves the result in scoped variable.

Example:

JSTL SQL <sql:query> 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 Tag1

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

It will look like this:

JSTL SQL Tag2

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

It will look like this:

JSTL SQL Tag3

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 Tag4

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

This will produce the following result:

JSTL SQL Tag5

You may also like