Java编程

开发平台：

Java

PresentTimeOffData.jsp~5~：源码内容

							<%@ page contentType="text/html; charset=GBK" %>
<HTML>
<HEAD><TITLE>Your Time Off Data</TITLE></HEAD>
<BODY>
<%@ page import="java.sql.*" %>
<%@ page import="humanresource.EmployeeInfoBean" %>
<%! int employeeID; %>
<H1 ALIGN="center">Your Current Time Off Status</H1>
<TABLE WIDTH="100%">
<%
   /*employeeID = Integer.valueOf(request.getParameter("id")).intValue();
   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;
   ResultSet rs = statement.executeQuery(sql);*/
  EmployeeInfoBean beanObj=new EmployeeInfoBean();
  employeeID = Integer.valueOf(request.getParameter("id")).intValue();
  ResultSet rs=beanObj.queryPenPolicy(employeeID);
   rs.next();
%>
  <TR><TD ALIGN="right" WIDTH="50%">Employee Name:</TD>
      <TD WIDTH="50%"><%= rs.getString("NAME") %></TD>
  </TR>
  <TR><TD ALIGN="right">Total Sick Days:</TD>
      <TD> <%= rs.getString("TOTALSICKDAYS") %></TD>
  </TR>
  <TR><TD ALIGN="right">Taken Sick Days: </TD>
      <TD><%= rs.getString("TAKENSICKDAYS") %></TD>
  </TR>
  <TR><TD ALIGN="right">Total Personal Time (in hours): </TD>
      <TD><%= rs.getString("TOTALPERSONALTIME") %></TD>
  </TR>
  <TR><TD ALIGN="right">Taken Personal Time (in hours): </TD>
      <TD><%= rs.getString("TAKENPERSONALTIME") %></TD>
  </TR>
</TABLE>
<BR>
</BODY>
</HTML>

						