InfoCenter Home > 4.2.2.3.7.2.4a: Example: JSP syntax: <tsx:dbmodify> tag syntaxIn 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 and referenced in the database commands using <tsx:getProperty>. <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>
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|