JSTL SQL <sql:update> Tag
The <sql:update> tag is used for executing the SQL DML query defined in its sql attribute or in the tag body. It may be SQL UPDATE, INSERT or DELETE statements.
Example:
JSTL SQL <sql:update> 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:update> tag is:
This will produce the following result:
