예제 #1
0
  public void _jspService(
      javax.servlet.http.HttpServletRequest request,
      javax.servlet.http.HttpServletResponse response)
      throws java.io.IOException, javax.servlet.ServletException {
    javax.servlet.http.HttpSession session = request.getSession(true);
    com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
    javax.servlet.ServletContext application = _jsp_application;
    com.caucho.jsp.PageContextImpl pageContext =
        com.caucho.jsp.QJspFactory.allocatePageContext(
            this, _jsp_application, request, response, "/error.jsp", session, 8192, true);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    response.setContentType("text/html");
    try {
      out.write(_jsp_string0, 0, _jsp_string0.length);
      out.print(((String) session.getAttribute("user")));
      out.write(_jsp_string1, 0, _jsp_string1.length);
      out.print(((String) session.getAttribute("db")));
      out.write(_jsp_string2, 0, _jsp_string2.length);

      // get all tables in the database
      ConDB dbcon = (ConDB) session.getAttribute("dbcon");
      Connection conn = dbcon.get();
      int total_rec = 0;
      int total_table = 0;
      String sql = "show tables";
      PreparedStatement pstm = null;
      ResultSet rs = null;
      try {
        pstm = conn.prepareStatement(sql);
        rs = pstm.executeQuery();
      } catch (SQLException e) {
        out.println(e);
      }

      // count the records of each table
      while (rs.next()) {
        String curr_tb = rs.getString(1);
        int curr_rec = 0;
        PreparedStatement pstm_rec = null;
        ResultSet rs_rec = null;
        sql = "select count(*) from " + curr_tb;

        try {
          pstm_rec = conn.prepareStatement(sql);
          rs_rec = pstm_rec.executeQuery();
        } catch (SQLException e) {
          out.println(e);
        }

        try {
          if (rs_rec.next()) {
            curr_rec = rs_rec.getInt(1);
            total_rec += curr_rec;
          }
        } catch (SQLException e) {
          out.println(e.getErrorCode() + "---" + e.getSQLState());
        }

        total_table++;

        out.write(_jsp_string3, 0, _jsp_string3.length);
        out.print((total_table & 1));
        out.write(_jsp_string4, 0, _jsp_string4.length);
        out.print((curr_tb));
        out.write(_jsp_string5, 0, _jsp_string5.length);
        out.print((curr_tb));
        out.write(_jsp_string6, 0, _jsp_string6.length);
        out.print((curr_tb));
        out.write(_jsp_string7, 0, _jsp_string7.length);
        out.print((curr_tb));
        out.write(_jsp_string8, 0, _jsp_string8.length);
        out.print((curr_tb));
        out.write(_jsp_string9, 0, _jsp_string9.length);
        out.print((curr_rec));
        out.write(_jsp_string10, 0, _jsp_string10.length);
      }

      out.write(_jsp_string11, 0, _jsp_string11.length);
      out.print((total_table));
      out.write(_jsp_string12, 0, _jsp_string12.length);
      out.print((total_rec));
      out.write(_jsp_string13, 0, _jsp_string13.length);
      out.print((session.getAttribute("db")));
      out.write(_jsp_string14, 0, _jsp_string14.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }
  public void _jspService(
      javax.servlet.http.HttpServletRequest request,
      javax.servlet.http.HttpServletResponse response)
      throws java.io.IOException, javax.servlet.ServletException {
    javax.servlet.http.HttpSession session = request.getSession(true);
    com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
    javax.servlet.ServletContext application = _jsp_application;
    com.caucho.jsp.PageContextImpl pageContext =
        com.caucho.jsp.QJspFactory.allocatePageContext(
            this, _jsp_application, request, response, null, session, 8192, true, false);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    response.setContentType("text/html");
    try {
      uk.ac.dundee.computing.stewarttaylor.UserBean userBean;
      synchronized (session) {
        userBean = (uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
        if (userBean == null) {
          userBean = new uk.ac.dundee.computing.stewarttaylor.UserBean();
          session.setAttribute("userBean", userBean);
        }
      }
      out.write(_jsp_string0, 0, _jsp_string0.length);
      uk.ac.dundee.computing.stewarttaylor.UserBean userBean2;
      synchronized (session) {
        userBean2 =
            (uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean2");
        if (userBean2 == null) {
          userBean2 = new uk.ac.dundee.computing.stewarttaylor.UserBean();
          session.setAttribute("userBean2", userBean2);
        }
      }
      out.write(_jsp_string1, 0, _jsp_string1.length);

      uk.ac.dundee.computing.stewarttaylor.UserBean uBean2 =
          (uk.ac.dundee.computing.stewarttaylor.UserBean) session.getAttribute("userBean");
      String sName = uBean2.getUsername();

      out.write(_jsp_string2, 0, _jsp_string2.length);
      out.print(sName);
      out.write(_jsp_string3, 0, _jsp_string3.length);
      out.print(sName);
      out.write(_jsp_string4, 0, _jsp_string4.length);
      uk.ac.dundee.computing.stewarttaylor.MessageBean msgBean;
      synchronized (session) {
        msgBean =
            (uk.ac.dundee.computing.stewarttaylor.MessageBean) session.getAttribute("msgBean");
        if (msgBean == null) {
          msgBean = new uk.ac.dundee.computing.stewarttaylor.MessageBean();
          session.setAttribute("msgBean", msgBean);
        }
      }
      out.write(_jsp_string5, 0, _jsp_string5.length);

      try {

        String[] names = msgBean.getUsername();
        String[] dates = msgBean.getDate();
        String[] messages = msgBean.getMessage();
        String[] images = msgBean.getImage();
        boolean[] canDelete = msgBean.getCanDelete();
        int[] id = msgBean.getID();

        for (int i = 0; i < names.length; i++) {

          out.write(_jsp_string6, 0, _jsp_string6.length);
          out.println(names[i]);
          out.write(_jsp_string3, 0, _jsp_string3.length);
          out.println(names[i]);
          out.write(_jsp_string7, 0, _jsp_string7.length);

          if (canDelete[i] == true) {

            out.write(_jsp_string8, 0, _jsp_string8.length);
            out.println(id[i]);
            out.write(_jsp_string9, 0, _jsp_string9.length);
          }

          out.write(_jsp_string10, 0, _jsp_string10.length);
          out.println(images[i]);
          out.write(_jsp_string11, 0, _jsp_string11.length);
          out.println(dates[i]);
          out.write(_jsp_string12, 0, _jsp_string12.length);
          out.println(messages[i]);
          out.write(_jsp_string13, 0, _jsp_string13.length);
        }
      } catch (Exception E) {
        out.println("<h3> No Posts Retrieved</h3>");
      }

      out.write(_jsp_string14, 0, _jsp_string14.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }