<HTML> <HEAD> <TITLE>Employee Results</TITLE> </HEAD> <H1><CENTER>EMPLOYEE RESULTS</CENTER></H1> <BODY> <dbconnect id="conn" url="jdbc:db2:sample" driver="COM.ibm.db2.jdbc.app.DB2Driver"> <userid><INSERT requestparm="USERID"></INSERT></userid> <passwd><INSERT requestparm="PASSWD"></INSERT></passwd> </dbconnect> <% if ( ( request.getParameter("Submit")).equals("Update") ) { %> <dbmodify connection="conn" > INSERT INTO EMPLOYEE (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,EDLEVEL) VALUES ( '<INSERT requestparm="EMPNO"></INSERT>', '<INSERT requestparm="FIRSTNME"></INSERT>', '<INSERT requestparm="MIDINIT"></INSERT>', '<INSERT requestparm="LASTNAME"></INSERT>', '<INSERT requestparm="WORKDEPT"></INSERT>', <INSERT requestparm="EDLEVEL"></INSERT>) </dbmodify> <B><UL>UPDATE SUCCESSFUL</UL></B> <BR><BR> <dbquery id="qs" connection="conn" > select * from Employee where WORKDEPT= '<INSERT requestparm="WORKDEPT"></INSERT>' </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> <repeat> <TR> <TD><B><I><INSERT bean="qs" property="EMPNO"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs" property="FIRSTNME"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs" property="WORKDEPT"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs" property= "EDLEVEL"></INSERT></I></B></TD> </TR> </repeat> </TABLE> <HR> <BR> <% } %> <% if ( ( request.getParameter("Submit")).equals("Query") ) { %> <dbquery id="qs2" connection="conn" > select * from Employee where WORKDEPT= '<INSERT requestparm="WORKDEPT"></INSERT>' </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> <repeat> <TR> <TD><B><I><INSERT bean="qs2" property="EMPNO"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs2" property="FIRSTNME"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs2" property="WORKDEPT"></INSERT></I></B></TD> <TD><B><I><INSERT bean="qs2" property= "EDLEVEL"></INSERT></I></B></TD> </TR> </repeat> </TABLE> <HR> <BR> <% } %> </BODY> </HTML>