Java编程

开发平台：

Java

PresentChangeOfEmployeeData.jsp：源码内容

							<%@ page contentType="text/html; charset=GBK" %>
<HTML>
<HEAD><TITLE></TITLE></HEAD>
<BODY>
<%@ include file="CompanyBanner.html" %>
<%@ page import="java.sql.*" %>
<%@ page import="humanresource.EmployeeInfoBean" %>
<jsp:useBean id="empInfo" class="humanresource.EmployeeInfoBean" scope="request"/>
<CENTER>
  <FONT SIZE="5" COLOR="navy">
    Your New Information
  </FONT>
</CENTER>
<TABLE WIDTH="100%" BORDER="1">
<%
   int employeeID = empInfo.getId();
   try {
  /* Class.forName("COM.cloudscape.core.JDBCDriver").newInstance();
   Connection conn =
     DriverManager.getConnection("jdbc:cloudscape:c:\HumanResourcesDB");
   Statement statement = conn.createStatement();
   String sql = "SELECT * FROM EMPLOYEEINFO WHERE ID = " + employeeID;*/
   EmployeeInfoBean beanObj1=new EmployeeInfoBean();
   ResultSet rs = beanObj1.queryPenPolicy(employeeID);
   while(rs.next()){
%>
     <TR><TD ALIGN="right" WIDTH="50%">Name:</TD>
         <TD WIDTH="50%"><%= rs.getString("NAME") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Address:</TD>
         <TD WIDTH="50%"><%= rs.getString("ADDRESS") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Phone Number:</TD>
         <TD WIDTH="50%"><%= rs.getString("PHONE") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Work Status:</TD>
         <TD WIDTH="50%"><%= rs.getString("WORKSTATUS") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Total Sick Days:</TD>
         <TD> <%= rs.getString("TOTALSICKDAYS") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Taken Sick Days: </TD>
         <TD><%= rs.getString("TAKENSICKDAYS") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Total Personal Time(in hours): </TD>
         <TD><%= rs.getString("TOTALPERSONALTIME") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Taken Personal Time(in hours): </TD>
         <TD><%= rs.getString("TAKENPERSONALTIME") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Health Care Plan:</TD>
         <TD WIDTH="50%"><%= rs.getString("HEALTHCAREPLAN") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Dental Plan:</TD>
         <TD WIDTH="50%"><%= rs.getString("DENTALPLAN") %></TD>
     </TR>
     <TR><TD ALIGN="right" WIDTH="50%">Vision Plan:</TD>
         <TD WIDTH="50%"><%= rs.getString("VISIONPLAN") %></TD>
     </TR>
<% }//end while loop
  } // end try block
  catch (Exception e) {};
%>
</TABLE>
<%@ include file="SiteNavigator.html" %>
</BODY>
</HTML>

						