presenttimeoffdata.jsp~10~

来自「100多M的J2EE培训内容」· JSP~10~ 代码 · 共 47 行

JSP~10~
47
字号
<%@ 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();
//  employeeID = request.getParameter("id");
  ResultSet rs=beanObj.queryPenPolicy(employeeID);
  System.out.println(rs);
   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>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?