dbmodify tag JSP syntax (deprecated)

The <tsx:dbmodify> tag establishes a connection to a database and then adds records to a database table.

Support for tsx tags in the JSP (JSP) engine are deprecated in WAS v6.0. Instead of using the tsx tags, you should use equivalent tags from the JSP Standard Tag Library (JSTL).

The <tsx:dbmodify> tag does the following:

1. References a <tsx:dbconnect> tag in the same JSP (JSP) file and uses the information provided by that tag to determine the database URL and driver.

   We can also obtain the user ID and password from the <tsx:dbconnect> tag if those values are provided in the <tsx:dbconnect> tag.

2. Establishes a new connection.

3. Updates a table in the database.

4. Closes the connection and releases the connection resource.

This section describes the syntax of the <tsx:dbmodify> tag.

<%-- Any valid database update commands can be placed within the DBMODIFY tag. -->
<%-- Any other syntax, including HTML comments, are not valid. -->
<tsx:dbmodify connection="connection_id">
</tsx:dbmodify>

where:

• connection

  Represents the identifier of a <tsx:dbconnect> tag in this JSP file. The <tsx:dbconnect> tag provides the database URL, driver name, and (optionally) the user ID and password for the connection.

• Database commands

  Represents valid database commands. Refer to the database documentation for details

In the following example, a new employee record is added to a database. The values of the fields are based on user input from this JSP (JSP) file and referenced in the database commands using the <tsx:getProperty> tag.

<tsx:dbmodify connection="conn" >
insert into EMPLOYEE
    (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,EDLEVEL)
values
('<tsx:getProperty name="request" property=request.getParameter("EMPNO") />', '<tsx:getProperty name="request" property=request.getParameter("FIRSTNME") />', '<tsx:getProperty name="request" property=request.getParameter("MIDINIT") />', '<tsx:getProperty name="request" property=request.getParameter("LASTNAME") />', '<tsx:getProperty name="request" property=request.getParameter("WORKDEPT") />', <tsx:getProperty name="request" property=request.getParameter("EDLEVEL") />)
</tsx:dbmodify>

Related concepts

JSP

Related tasks

Use installed optional packages

Manage shared libraries

Web applications: Resources for learning Reference topic