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:
Step-2: Login to the database using command prompt as shown below:
It will look like this:
Step-3: Create the table Students in test database as shown below:
It will look like this:
Step 4: In final step you need to create few data records in Students table as shown below:
It will look like this:
Let’s see the simple JSP example to understand the use of <sql:query> tag is:
This will produce the following result:
