PresentTimeOffData.jsp~7~
资源名称:某公司的java培训教材 [点击查看]
上传用户:dinglihq
上传日期:2013-02-04
资源大小:99958k
文件大小:1k
源码类别:
Java编程
开发平台:
Java
- <%@ 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 = request.getParameter("id");
- 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>