开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > 查看源码
PresentTimeOffData_jsp.java
资源名称：某公司的java培训教材　[点击查看]
上传用户：dinglihq
上传日期：2013-02-04
资源大小：99958k
文件大小：4k
源码类别：

Java编程

开发平台：

Java

PresentTimeOffData_jsp.java：源码内容
  1. package org.apache.jsp;
  3. import javax.servlet.*;
  4. import javax.servlet.http.*;
  5. import javax.servlet.jsp.*;
  6. import org.apache.jasper.runtime.*;
  7. import java.sql.*;
  8. import humanresource.EmployeeInfoBean;
  10. public class PresentTimeOffData_jsp extends HttpJspBase {
  12.  int employeeID; 
  14.   private static java.util.Vector _jspx_includes;
  16.   public java.util.List getIncludes() {
  17.     return _jspx_includes;
  18.   }
  20.   public void _jspService(HttpServletRequest request, HttpServletResponse response)
  21.         throws java.io.IOException, ServletException {
  23.     JspFactory _jspxFactory = null;
  24.     javax.servlet.jsp.PageContext pageContext = null;
  25.     HttpSession session = null;
  26.     ServletContext application = null;
  27.     ServletConfig config = null;
  28.     JspWriter out = null;
  29.     Object page = this;
  30.     JspWriter _jspx_out = null;
  33.     try {
  34.       _jspxFactory = JspFactory.getDefaultFactory();
  35.       response.setContentType("text/html; charset=GBK");
  36.       pageContext = _jspxFactory.getPageContext(this, request, response,
  37.        null, true, 8192, true);
  38.       application = pageContext.getServletContext();
  39.       config = pageContext.getServletConfig();
  40.       session = pageContext.getSession();
  41.       out = pageContext.getOut();
  42.       _jspx_out = out;
  44.       out.write("rn");
  45.       out.write("<HTML>rn");
  46.       out.write("<HEAD>");
  47.       out.write("<TITLE>Your Time Off Data");
  48.       out.write("</TITLE>");
  49.       out.write("</HEAD>rn");
  50.       out.write("<BODY>rnrn");
  51.       out.write("rn");
  52.       out.write("rnrn");
  53.       out.write("rnrn");
  54.       out.write("<H1 ALIGN="center">Your Current Time Off Status");
  55.       out.write("</H1>rnrn");
  56.       out.write("<TABLE WIDTH="100%" BORDER="1">rn");
  58.    /*employeeID = Integer.valueOf(request.getParameter("id")).intValue();
  59.    Class.forName("COM.cloudscape.core.JDBCDriver").newInstance();
  60.    Connection conn =
  61.      DriverManager.getConnection("jdbc:cloudscape:c:\HumanResourcesDB");
  62.    Statement statement = conn.createStatement();
  63.    String sql = "SELECT * FROM EMPLOYEEINFO WHERE ID = " + employeeID;
  64.    ResultSet rs = statement.executeQuery(sql);*/
  65.   EmployeeInfoBean beanObj2=new EmployeeInfoBean();
  66.   employeeID = Integer.valueOf(request.getParameter("id")).intValue();
  67.   ResultSet rs=beanObj2.queryPenPolicy(employeeID);
  68.    rs.next();
  70.       out.write("rn  ");
  71.       out.write("<TR>");
  72.       out.write("<TD ALIGN="right" WIDTH="50%">Employee Name:");
  73.       out.write("</TD>rn      ");
  74.       out.write("<TD WIDTH="50%">");
  75.       out.print( rs.getString("NAME") );
  76.       out.write("</TD>rn  ");
  77.       out.write("</TR>rn  ");
  78.       out.write("<TR>");
  79.       out.write("<TD ALIGN="right">Total Sick Days:");
  80.       out.write("</TD>rn      ");
  81.       out.write("<TD> ");
  82.       out.print( rs.getString("TOTALSICKDAYS") );
  83.       out.write("</TD>rn  ");
  84.       out.write("</TR>rn  ");
  85.       out.write("<TR>");
  86.       out.write("<TD ALIGN="right">Taken Sick Days: ");
  87.       out.write("</TD>rn      ");
  88.       out.write("<TD>");
  89.       out.print( rs.getString("TAKENSICKDAYS") );
  90.       out.write("</TD>rn  ");
  91.       out.write("</TR>rn  ");
  92.       out.write("<TR>");
  93.       out.write("<TD ALIGN="right">Total Personal Time (in hours): ");
  94.       out.write("</TD>rn      ");
  95.       out.write("<TD>");
  96.       out.print( rs.getString("TOTALPERSONALTIME") );
  97.       out.write("</TD>rn  ");
  98.       out.write("</TR>rn  ");
  99.       out.write("<TR>");
  100.       out.write("<TD ALIGN="right">Taken Personal Time (in hours): ");
  101.       out.write("</TD>rn      ");
  102.       out.write("<TD>");
  103.       out.print( rs.getString("TAKENPERSONALTIME") );
  104.       out.write("</TD>rn  ");
  105.       out.write("</TR>rn");
  106.       out.write("</TABLE>rn");
  107.       out.write("<BR>rn");
  108.       out.write("</BODY>rn");
  109.       out.write("</HTML>");
  110.     } catch (Throwable t) {
  111.       out = _jspx_out;
  112.       if (out != null && out.getBufferSize() != 0)
  113.         out.clearBuffer();
  114.       if (pageContext != null) pageContext.handlePageException(t);
  115.     } finally {
  116.       if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
  117.     }
  118.   }
  119. }