presenttimeoffdata.jsp~4~
来自「100多M的J2EE培训内容」· JSP~4~ 代码 · 共 45 行
JSP~4~
45 行
<%@ 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>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?