ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzamy_5.4.0.1/50/program/jspexam.htm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=utf-8">
<LINK rel="stylesheet" type="text/css" href="../../../rzahg/ic.css">

<title>&lt;tsx:dbquery&gt;</title>
</head>

<BODY>
<!-- Java sync-link -->
<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>

<h5><a name="jspexam"></a>JSP10employeeRepeatResults.jsp example</h5>
<p>See the <a href="codex.htm">Code example disclaimer</a> for legal information about this code examples.</p>
<pre>
&lt;!-- JSP10employeeRepeatResults.jsp --&gt;

&lt;HTML&gt;
&lt;HEAD&gt;
&lt;TITLE&gt;JSP 1.0 Employee Results&lt;/TITLE&gt;
&lt;/HEAD&gt;
&lt;H1&gt;&lt;CENTER&gt;EMPLOYEE RESULTS&lt;/CENTER&gt;&lt;/H1&gt;
&lt;BODY&gt;

&lt;% String   userID = request.getParameter(&quot;USERID&quot;); %&gt;
&lt;% String   passWord = request.getParameter(&quot;PASSWD&quot;); %&gt;

&lt;% String   empno    = request.getParameter(&quot;EMPNO&quot;); %&gt;
&lt;% String   firstnme = request.getParameter(&quot;FIRSTNME&quot;); %&gt;
&lt;% String   midinit  = request.getParameter(&quot;MIDINIT&quot;); %&gt;
&lt;% String   lastname = request.getParameter(&quot;LASTNAME&quot;); %&gt;
&lt;% String   workdept = request.getParameter(&quot;WORKDEPT&quot;); %&gt;
&lt;% String   edlevel  = request.getParameter(&quot;EDLEVEL&quot;); %&gt;

&lt;!-- Get a connection to the local DB2 database using parameters from Login.jsp --&gt;
&lt;tsx:dbconnect id=&quot;conn&quot; url=&quot;jdbc:db2:*local&quot; driver=&quot;com.ibm.db2.jdbc.app.DB2Driver&quot;&gt;
&lt;tsx:userid&gt;&lt;%=userID%&gt;&lt;/tsx:userid&gt;
&lt;tsx:passwd&gt;&lt;%=passWord%&gt;&lt;/tsx:passwd&gt;
&lt;/tsx:dbconnect&gt;

&lt;% if  ( ( request.getParameter(&quot;Submit&quot;)).equals(&quot;Update&quot;) ) { %&gt;
&lt;tsx:dbmodify connection=&quot;conn&quot; &gt;
   INSERT INTO  WSDEMO.EMPLOYEE 
   (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,EDLEVEL)
   VALUES
    ( '&lt;%=empno%&gt;',
    '&lt;%=firstnme%&gt;',
     '&lt;%=midinit%&gt;',
     '&lt;%=lastname%&gt;',
    '&lt;%=workdept%&gt;',
    &lt;%=edlevel%&gt;)
    &lt;/tsx:dbmodify&gt;
 &lt;B&gt;&lt;UL&gt;UPDATE SUCCESSFUL&lt;/UL&gt;&lt;/B&gt;
 &lt;BR&gt;&lt;BR&gt;
&lt;tsx:dbquery id=&quot;qs&quot; connection=&quot;conn&quot; &gt;
   select * from WSDEMO.EMPLOYEE  where  WORKDEPT= '&lt;%=workdept%&gt;'
&lt;/tsx:dbquery&gt;


&lt;B&gt;&lt;CENTER&gt;&lt;U&gt;EMPLOYEE LIST&lt;/U&gt;&lt;/CENTER&gt;&lt;/B&gt;&lt;BR&gt;&lt;BR&gt;
&lt;HR&gt;
&lt;TABLE&gt;
&lt;TR VALIGN=BOTTOM&gt;
&lt;TD&gt;&lt;B&gt;EMPLOYEE
&lt;BR&gt;
&lt;U&gt;NUMBER&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;U&gt;NAME&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;U&gt;DEPARTMENT&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt; 
&lt;TD&gt;&lt;B&gt;&lt;U&gt;EDUCATION&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;/TR&gt;

&lt;tsx:repeat&gt;
&lt;TR&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs&quot; property=&quot;EMPNO&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs&quot; property=&quot;FIRSTNME&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs&quot; property=&quot;WORKDEPT&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs&quot; property=&quot;EDLEVEL&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/tsx:repeat&gt; 

&lt;/TABLE&gt;


&lt;HR&gt;
&lt;BR&gt;
&lt;% } %&gt;

&lt;% if  ( ( request.getParameter(&quot;Submit&quot;)).equals(&quot;Query&quot;) ) { %&gt;

&lt;tsx:dbquery id=&quot;qs2&quot; connection=&quot;conn&quot; &gt;
   select * from WSDEMO.EMPLOYEE  where  WORKDEPT= '&lt;%=workdept%&gt;'
&lt;/tsx:dbquery&gt;


&lt;B&gt;&lt;CENTER&gt;&lt;U&gt;EMPLOYEE LIST&lt;/U&gt;&lt;/CENTER&gt;&lt;/B&gt;&lt;BR&gt;&lt;BR&gt;
&lt;HR&gt;
&lt;TABLE&gt;
&lt;TR&gt;
&lt;TR VALIGN=BOTTOM&gt;
&lt;TD&gt;&lt;B&gt;EMPLOYEE
&lt;BR&gt;
&lt;U&gt;NUMBER&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;U&gt;NAME&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;U&gt;DEPARTMENT&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;U&gt;EDUCATION&lt;/U&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;/TR&gt;

&lt;tsx:repeat&gt;
&lt;TR&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs2&quot; property=&quot;EMPNO&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs2&quot; property=&quot;FIRSTNME&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs2&quot; property=&quot;WORKDEPT&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;TD&gt;&lt;B&gt;&lt;I&gt;&lt;tsx:getProperty name=&quot;qs2&quot; property=&quot;EDLEVEL&quot; /&gt;&lt;/I&gt;&lt;/B&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/tsx:repeat&gt; 
&lt;/TABLE&gt;
&lt;HR&gt;
&lt;BR&gt;
&lt;% } %&gt;

&lt;/BODY&gt;
&lt;/HTML&gt;

</pre>

</body>
</html>
Add readme and dist folders 2024-04-02 14:02:31 +00:00			`<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">`
			`<html>`
			`<head>`
			`<META http-equiv="Content-Type" content="text/html; charset=utf-8">`
			`<LINK rel="stylesheet" type="text/css" href="../../../rzahg/ic.css">`

			`<title><tsx:dbquery></title>`
			`</head>`

			`<BODY>`
			`<!-- Java sync-link -->`
			`<SCRIPT LANGUAGE="Javascript" SRC="../../../rzahg/synch.js" TYPE="text/javascript"></SCRIPT>`

			`<h5><a name="jspexam"></a>JSP10employeeRepeatResults.jsp example</h5>`
			`<p>See the <a href="codex.htm">Code example disclaimer</a> for legal information about this code examples.</p>`
			`<pre>`
			`<!-- JSP10employeeRepeatResults.jsp -->`

			`<HTML>`
			`<HEAD>`
			`<TITLE>JSP 1.0 Employee Results</TITLE>`
			`</HEAD>`
			`<H1><CENTER>EMPLOYEE RESULTS</CENTER></H1>`
			`<BODY>`

			`<% String userID = request.getParameter("USERID"); %>`
			`<% String passWord = request.getParameter("PASSWD"); %>`

			`<% String empno = request.getParameter("EMPNO"); %>`
			`<% String firstnme = request.getParameter("FIRSTNME"); %>`
			`<% String midinit = request.getParameter("MIDINIT"); %>`
			`<% String lastname = request.getParameter("LASTNAME"); %>`
			`<% String workdept = request.getParameter("WORKDEPT"); %>`
			`<% String edlevel = request.getParameter("EDLEVEL"); %>`

			`<!-- Get a connection to the local DB2 database using parameters from Login.jsp -->`
			`<tsx:dbconnect id="conn" url="jdbc:db2:*local" driver="com.ibm.db2.jdbc.app.DB2Driver">`
			`<tsx:userid><%=userID%></tsx:userid>`
			`<tsx:passwd><%=passWord%></tsx:passwd>`
			`</tsx:dbconnect>`

			`<% if ( ( request.getParameter("Submit")).equals("Update") ) { %>`
			`<tsx:dbmodify connection="conn" >`
			`INSERT INTO WSDEMO.EMPLOYEE`
			`(EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,EDLEVEL)`
			`VALUES`
			`( '<%=empno%>',`
			`'<%=firstnme%>',`
			`'<%=midinit%>',`
			`'<%=lastname%>',`
			`'<%=workdept%>',`
			`<%=edlevel%>)`
			`</tsx:dbmodify>`
			`<B><UL>UPDATE SUCCESSFUL</UL></B>`
			`<BR><BR>`
			`<tsx:dbquery id="qs" connection="conn" >`
			`select * from WSDEMO.EMPLOYEE where WORKDEPT= '<%=workdept%>'`
			`</tsx:dbquery>`


			`<B><CENTER><U>EMPLOYEE LIST</U></CENTER></B><BR><BR>`
			`<HR>`
			`<TABLE>`
			`<TR VALIGN=BOTTOM>`
			`<TD><B>EMPLOYEE`
			`<BR>`
			`<U>NUMBER</U></B></TD>`
			`<TD><B><U>NAME</U></B></TD>`
			`<TD><B><U>DEPARTMENT</U></B></TD>`
			`<TD><B><U>EDUCATION</U></B></TD>`
			`</TR>`

			`<tsx:repeat>`
			`<TR>`
			`<TD><B><I><tsx:getProperty name="qs" property="EMPNO" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs" property="FIRSTNME" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs" property="WORKDEPT" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs" property="EDLEVEL" /></I></B></TD>`
			`</TR>`
			`</tsx:repeat>`

			`</TABLE>`


			`<HR>`
			`<BR>`
			`<% } %>`

			`<% if ( ( request.getParameter("Submit")).equals("Query") ) { %>`

			`<tsx:dbquery id="qs2" connection="conn" >`
			`select * from WSDEMO.EMPLOYEE where WORKDEPT= '<%=workdept%>'`
			`</tsx:dbquery>`


			`<B><CENTER><U>EMPLOYEE LIST</U></CENTER></B><BR><BR>`
			`<HR>`
			`<TABLE>`
			`<TR>`
			`<TR VALIGN=BOTTOM>`
			`<TD><B>EMPLOYEE`
			`<BR>`
			`<U>NUMBER</U></B></TD>`
			`<TD><B><U>NAME</U></B></TD>`
			`<TD><B><U>DEPARTMENT</U></B></TD>`
			`<TD><B><U>EDUCATION</U></B></TD>`
			`</TR>`

			`<tsx:repeat>`
			`<TR>`
			`<TD><B><I><tsx:getProperty name="qs2" property="EMPNO" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs2" property="FIRSTNME" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs2" property="WORKDEPT" /></I></B></TD>`
			`<TD><B><I><tsx:getProperty name="qs2" property="EDLEVEL" /></I></B></TD>`
			`</TR>`
			`</tsx:repeat>`
			`</TABLE>`
			`<HR>`
			`<BR>`
			`<% } %>`

			`</BODY>`
			`</HTML>`

			`</pre>`

			`</body>`
			`</html>`