<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>