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