presenttimeoffdata_jsp.java
来自「100多M的J2EE培训内容」· Java 代码 · 共 120 行
JAVA
120 行
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
import java.sql.*;
import humanresource.EmployeeInfoBean;
public class PresentTimeOffData_jsp extends HttpJspBase {
int employeeID;
private static java.util.Vector _jspx_includes;
public java.util.List getIncludes() {
return _jspx_includes;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
javax.servlet.jsp.PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("<HTML>\r\n");
out.write("<HEAD>");
out.write("<TITLE>Your Time Off Data");
out.write("</TITLE>");
out.write("</HEAD>\r\n");
out.write("<BODY>\r\n\r\n");
out.write("\r\n");
out.write("\r\n\r\n");
out.write("\r\n\r\n");
out.write("<H1 ALIGN=\"center\">Your Current Time Off Status");
out.write("</H1>\r\n\r\n");
out.write("<TABLE WIDTH=\"100%\" BORDER=\"1\">\r\n");
/*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 beanObj2=new EmployeeInfoBean();
employeeID = Integer.valueOf(request.getParameter("id")).intValue();
ResultSet rs=beanObj2.queryPenPolicy(employeeID);
rs.next();
out.write("\r\n ");
out.write("<TR>");
out.write("<TD ALIGN=\"right\" WIDTH=\"50%\">Employee Name:");
out.write("</TD>\r\n ");
out.write("<TD WIDTH=\"50%\">");
out.print( rs.getString("NAME") );
out.write("</TD>\r\n ");
out.write("</TR>\r\n ");
out.write("<TR>");
out.write("<TD ALIGN=\"right\">Total Sick Days:");
out.write("</TD>\r\n ");
out.write("<TD> ");
out.print( rs.getString("TOTALSICKDAYS") );
out.write("</TD>\r\n ");
out.write("</TR>\r\n ");
out.write("<TR>");
out.write("<TD ALIGN=\"right\">Taken Sick Days: ");
out.write("</TD>\r\n ");
out.write("<TD>");
out.print( rs.getString("TAKENSICKDAYS") );
out.write("</TD>\r\n ");
out.write("</TR>\r\n ");
out.write("<TR>");
out.write("<TD ALIGN=\"right\">Total Personal Time (in hours): ");
out.write("</TD>\r\n ");
out.write("<TD>");
out.print( rs.getString("TOTALPERSONALTIME") );
out.write("</TD>\r\n ");
out.write("</TR>\r\n ");
out.write("<TR>");
out.write("<TD ALIGN=\"right\">Taken Personal Time (in hours): ");
out.write("</TD>\r\n ");
out.write("<TD>");
out.print( rs.getString("TAKENPERSONALTIME") );
out.write("</TD>\r\n ");
out.write("</TR>\r\n");
out.write("</TABLE>\r\n");
out.write("<BR>\r\n");
out.write("</BODY>\r\n");
out.write("</HTML>");
} catch (Throwable t) {
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?