<HTML>
<HEAD>
<TITLE>Add and View Employee Records</TITLE>
</HEAD>
<BODY>
<H1><CENTER>Add and View Employee Records</CENTER></H1>

<!-- Get a connection to the Sample DB2 database using parameters from Login.jsp -->
<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>

<FORM NAME="EmployeeForm" ACTION="employeeRepeatResults.jsp" 
METHOD="post" ENCODE="application/x-www-form-urlencoded">
<h2>Add Employee Record</h2>
<P>To add a new employee record to the database, submit the following data:</P>

<TABLE>
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Employee Number:
<br>
(1 to 6 characters)</I></B></TD>
<TD> 
<INPUT TYPE="text" NAME="EMPNO"> 
</TD>
</TR>

<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>First name:</I></B></TD>
<TD>
<INPUT TYPE="text" NAME="FIRSTNME" VALUE="First Name"><BR></TD>
</TR>

<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Middle Initial:</I></B></TD>
<TD><INPUT TYPE="text" NAME="MIDINIT" VALUE="M"><BR></TD>
</TR>
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Last Name: </I></B></TD>
<TD><INPUT TYPE="text" NAME="LASTNAME" VALUE="Last Name"><BR></TD>
</TR>

<TR VALIGN=TOP ALIGN=LEFT>
<TD>
<!-- Query the database to get the list of departments -->
<dbquery id="qs" connection="conn" >
   select * from DEPARTMENT  
</dbquery>

<B><I>Department:</I></B></TD>
<TD>
<SELECT NAME="WORKDEPT" >
<repeat> 
<OPTION VALUE= "<INSERT bean="qs" property="DEPTNO"></INSERT>" >
<INSERT bean="qs" property="DEPTNAME"></INSERT>
</repeat>
</SELECT>
</TD>
</TR>

<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Education:</I></B></TD>
<TD>
<SELECT NAME="EDLEVEL">
<OPTION VALUE="1" SELECTED>BS
<OPTION VALUE="2">MS
<OPTION VALUE="3">PhD
</SELECT>
</TD>
</TR>
</TABLE>

<INPUT TYPE="submit" NAME="Submit" VALUE="Update">
<INPUT TYPE="hidden" NAME="USERID" VALUE="<INSERT requestparm="USERID"></INSERT>">
<INPUT TYPE="hidden" NAME="PASSWD" VALUE="<INSERT requestparm="PASSWD"></INSERT>">
</FORM>
<HR>

<FORM NAME="EmployeeForm" ACTION="employeeRepeatResults.jsp" 
METHOD="post" ENCODE="application/x-www-form-urlencoded">
<h2>View Employees by Department</h2>
<P>To view records for employees by department, select the department
and submit the query:</P>

<TABLE>
<TR VALIGN=TOP ALIGN=LEFT>
<TD><B><I>Department:</I></B></TD>
<TD>
<!-- Use the bean generated by earlier QUERY tag -->
<SELECT NAME="WORKDEPT" >
<repeat> 
<OPTION VALUE= "<INSERT bean="qs" property="DEPTNO"></INSERT>" >
<INSERT bean="qs" property="DEPTNAME"></INSERT>
</repeat>
</SELECT>
</TD>
</TR>
</TABLE>

<INPUT TYPE="submit" NAME="Submit" VALUE="Query">
<INPUT TYPE="hidden" NAME="USERID" VALUE="<INSERT requestparm="USERID"></INSERT>">
<INPUT TYPE="hidden" NAME="PASSWD" VALUE="<INSERT requestparm="PASSWD"></INSERT>">
</FORM>

<HR>
</BODY>
</HTML>