Home » JSTL sql:update Tag

JSTL sql:update Tag

by Online Tutorials Library

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:

JSTL SQL Tag6

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

It will look like this:

JSTL SQL Tag7

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

It will look like this:

JSTL SQL Tag8

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 Tag9

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

This will produce the following result:

JSTL SQL Tag10

You may also like