示例#1
0
  /**
   * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
   *
   * @param request servlet request
   * @param response servlet response
   * @throws ServletException if a servlet-specific error occurs
   * @throws IOException if an I/O error occurs
   */
  protected void processRequest(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    Statement stmt;
    ResultSet rs;
    Connection con = null;

    try {
      Class.forName("com.mysql.jdbc.Driver");
      String connectionUrl = "jdbc:mysql://localhost/myflickr?" + "user=root&password=123456";
      con = DriverManager.getConnection(connectionUrl);

      if (con != null) {
        System.out.println("connected to mysql");
      }
    } catch (SQLException e) {
      System.out.println("SQL Exception: " + e.toString());
    } catch (ClassNotFoundException cE) {
      System.out.println("Class Not Found Exception: " + cE.toString());
    }

    try {
      stmt = con.createStatement();

      System.out.println("SELECT * FROM flickrusers WHERE name='" + username + "'");
      rs = stmt.executeQuery("SELECT * FROM flickrusers WHERE name='" + username + "'");

      while (rs.next()) {

        if (rs.getObject(1).toString().equals(username)) {

          out.println("<h1>To username pou epileksate uparxei hdh</h1>");
          out.println("<a href=\"project3.html\">parakalw dokimaste kapoio allo.</a>");

          stmt.close();
          rs.close();
          return;
        }
      }
      stmt.close();
      rs.close();

      stmt = con.createStatement();

      if (!stmt.execute("INSERT INTO flickrusers VALUES('" + username + "', '" + password + "')")) {
        out.println("<h1>Your registration is completed  " + username + "</h1>");
        out.println("<a href=\"index.jsp\">go to the login menu</a>");
        registerListener.Register(username);
      } else {
        out.println("<h1>To username pou epileksate uparxei hdh</h1>");
        out.println("<a href=\"project3.html\">Register</a>");
      }
    } catch (SQLException e) {
      throw new ServletException("Servlet Could not display records.", e);
    }
  }
 public void init(ServletConfig sc) throws ServletException {
   super.init(sc);
   try {
     Class.forName("com.mysql.jdbc.Driver");
     System.out.println("driver is loaded");
     con = DriverManager.getConnection(url, un, password);
     System.out.println("connected");
     stmt = con.createStatement();
     System.out.println("wrapper created");
   } catch (ClassNotFoundException cnfe) {
     System.out.println("driver Not Loaded" + cnfe.getMessage());
     return;
   } catch (SQLException sqle) {
     System.out.println("connection problem" + sqle.getMessage());
     return;
   }
 }
示例#3
0
  /**
   * Gets the current scoreboard and prints the users' names and scores in descending order.
   *
   * @return true if the scoreboard is printed successfully
   */
  private boolean getScoreboard() {
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      conn =
          DriverManager.getConnection(
              "jdbc:mysql://localhost:3306/getoffthecouch", "XXXXXX", "XXXXXX");

      Statement getScoresStmt = conn.createStatement();
      String getScoresQuery =
          "SELECT user_id, user_name, total_score FROM user ORDER BY total_score DESC";
      ResultSet getScoresResult = getScoresStmt.executeQuery(getScoresQuery);
      String userId = "";
      String userName = "";
      int totalScore = -1;
      while (getScoresResult.next()) {
        userId = getScoresResult.getString("user_id");
        userName = getScoresResult.getString("user_name");
        totalScore = getScoresResult.getInt("total_score");
        out.println(userId + "|" + userName + "|" + totalScore);
      }
      getScoresStmt.close();
      return true;
    } catch (InstantiationException e) {
      e.printStackTrace(out);
      return false;
    } catch (IllegalAccessException e) {
      e.printStackTrace(out);
      return false;
    } catch (ClassNotFoundException e) {
      e.printStackTrace(out);
      return false;
    } catch (SQLException e) {
      e.printStackTrace(out);
      return false;
    }
  }
示例#4
0
  /**
   * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
   *
   * @param request servlet request
   * @param response servlet response
   * @throws ServletException if a servlet-specific error occurs
   * @throws IOException if an I/O error occurs
   */
  protected void processRequest(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    String username = request.getParameter("username");
    String password = request.getParameter("password");
    Statement stmt;
    ResultSet rs;

    if (username == null || password == null) {
      out.println("<h1>Invalid Register Request</h1>");
      out.println("<a href=\"register.html\">Register</a>");

      return;
    }
    Connection con = null;

    try {
      Class.forName("com.mysql.jdbc.Driver");
      String connectionUrl = "jdbc:mysql://localhost/project3?" + "user=root&password=marouli";
      con = DriverManager.getConnection(connectionUrl);

      if (con != null) {
        System.out.println("Ola ok me mysql");
      }
    } catch (SQLException e) {
      System.out.println("SQL Exception: " + e.toString());
    } catch (ClassNotFoundException cE) {
      System.out.println("Class Not Found Exception: " + cE.toString());
    }

    try {
      stmt = con.createStatement();

      rs = stmt.executeQuery("SELECT * FROM users WHERE username='******'");
      if (rs.next()) {
        out.println("<h1>Username exists</h1>");
        out.println("<a href=\"register.html\">Register</a>");

        stmt.close();
        rs.close();
        con.close();
        return;
      }
      stmt.close();
      rs.close();

      stmt = con.createStatement();

      if (!stmt.execute("INSERT INTO users VALUES('" + username + "', '" + password + "')")) {
        out.println("<h1>You are now registered " + username + "</h1>");
        out.println("<a href=\"index.jsp\">Login</a>");

        int i;
        for (i = 0; i < listeners.size(); i++) listeners.get(i).UserRegistered(username);
      } else {
        out.println("<h1>Could not add your username to the db</h1>");
        out.println("<a href=\"register.html\">Register</a>");
      }

      stmt.close();
      con.close();
    } catch (SQLException e) {
      throw new ServletException("Servlet Could not display records.", e);
    }
  }
  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=utf-8");
      pageContext =
          _jspxFactory.getPageContext(
              this, request, response, "/jsp/GeneralError.jsp", true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\n\n");
      out.write("\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      java.util.Date now = null;
      synchronized (pageContext) {
        now = (java.util.Date) pageContext.getAttribute("now", PageContext.PAGE_SCOPE);
        if (now == null) {
          try {
            now =
                (java.util.Date)
                    java.beans.Beans.instantiate(
                        this.getClass().getClassLoader(), "java.util.Date");
          } catch (ClassNotFoundException exc) {
            throw new InstantiationException(exc.getMessage());
          } catch (Exception exc) {
            throw new ServletException("Cannot create bean of class " + "java.util.Date", exc);
          }
          pageContext.setAttribute("now", now, PageContext.PAGE_SCOPE);
        }
      }
      out.write("\n\n");
      out.write("\n");
      out.write("<script type=\"text/javascript\" src=\"");
      if (_jspx_meth_c_url_0(pageContext)) return;
      out.write("\">");
      out.write("</script>\n\n");
      out.write("\n");
      if (_jspx_meth_html_xhtml_0(pageContext)) return;
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n");
      out.write("\n\n\n\n");
      out.write("<html>\n");
      out.write("<head>\n  ");
      out.write("<title>WebTelemetry - Admin Settings | System Management | License Management");
      out.write("</title>\n  ");
      out.write("<base HREF=\"");
      out.print(org.opennms.web.Util.calculateUrlBase(request));
      out.write("\" />\n  ");
      out.write(
          "<link rel=\"stylesheet\" type=\"text/css\" href=\"/wt-portal/css/default.css\" />\n  ");
      out.write("<script type=\"text/javascript\" src=\"/wt-portal/javascript/WTtools.js\">");
      out.write("</script>\n");
      out.write("</HEAD>\n\n");
      out.write("<SCRIPT LANGUAGE=JAVASCRIPT>\nfunction checkError()\n{\n\t");
      if (request.getSession().getAttribute("thErrorMsg") != null) {
        out.write("\n\talert(\"");
        out.print(request.getSession().getAttribute("thErrorMsg"));
        out.write("\");\n    ");
        request.getSession().removeAttribute("thErrorMsg");
        out.write("\n\t");
      }
      out.write("\n\t");
      if (request.getAttribute("thErrorMsg") != null) {
        out.write("\n\talert(\"");
        out.print(request.getAttribute("thErrorMsg"));
        out.write("\");\n    ");
        request.removeAttribute("thErrorMsg");
        out.write("\n\t");
      }
      out.write("\n}\n");
      out.write("</SCRIPT>\n");
      out.write("<body onload=\"checkError();\">\n");
      /* ----  c:import ---- */
      org.apache.taglibs.standard.tag.el.core.ImportTag _jspx_th_c_import_0 =
          (org.apache.taglibs.standard.tag.el.core.ImportTag)
              _jspx_tagPool_c_import_url_context.get(
                  org.apache.taglibs.standard.tag.el.core.ImportTag.class);
      _jspx_th_c_import_0.setPageContext(pageContext);
      _jspx_th_c_import_0.setParent(null);
      _jspx_th_c_import_0.setContext("/wt-monitor");
      _jspx_th_c_import_0.setUrl("/includes/header.jsp");
      int[] _jspx_push_body_count_c_import_0 = new int[] {0};
      try {
        int _jspx_eval_c_import_0 = _jspx_th_c_import_0.doStartTag();
        if (_jspx_eval_c_import_0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
          if (_jspx_eval_c_import_0 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE) {
            javax.servlet.jsp.tagext.BodyContent _bc = pageContext.pushBody();
            _jspx_push_body_count_c_import_0[0]++;
            out = _bc;
            _jspx_th_c_import_0.setBodyContent(_bc);
            _jspx_th_c_import_0.doInitBody();
          }
          do {
            out.write("\n    ");
            if (_jspx_meth_c_param_0(
                _jspx_th_c_import_0, pageContext, _jspx_push_body_count_c_import_0)) return;
            out.write("\n    ");
            if (_jspx_meth_c_param_1(
                _jspx_th_c_import_0, pageContext, _jspx_push_body_count_c_import_0)) return;
            out.write("\n    ");
            if (_jspx_meth_c_param_2(
                _jspx_th_c_import_0, pageContext, _jspx_push_body_count_c_import_0)) return;
            out.write("\n");
            int evalDoAfterBody = _jspx_th_c_import_0.doAfterBody();
            if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
          } while (true);
          if (_jspx_eval_c_import_0 != javax.servlet.jsp.tagext.Tag.EVAL_BODY_INCLUDE)
            out = pageContext.popBody();
          _jspx_push_body_count_c_import_0[0]--;
        }
        if (_jspx_th_c_import_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) return;
      } catch (Throwable _jspx_exception) {
        while (_jspx_push_body_count_c_import_0[0]-- > 0) out = pageContext.popBody();
        _jspx_th_c_import_0.doCatch(_jspx_exception);
      } finally {
        _jspx_th_c_import_0.doFinally();
        _jspx_tagPool_c_import_url_context.reuse(_jspx_th_c_import_0);
      }
      out.write("\n\n");

      String errorMsg = (String) request.getAttribute("error");
      if (errorMsg != null && !errorMsg.equals("")) {

        out.write("\n\n");
        out.write("<table width=\"98%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n    ");
        out.write("<tr class=\"tableHeader\">\n        ");
        out.write("<td class=\"tableHeader\">Internal Error");
        out.write("</td>\n    ");
        out.write("</tr>\n    ");
        out.write("<tr class=\"error\" >\n        ");
        out.write("<td class=\"error\">");
        out.write("<br>");
        out.print(errorMsg);
        out.write("\n        ");
        out.write("<br />");
        out.write("<br />");
        out.write("<a href=\"mailto:[email protected]\">[email protected]");
        out.write("</a>");
        out.write("<br />&nbsp;");
        out.write("</td>\n    ");
        out.write("</tr>\n");
        out.write("</table>\n");
      }
      out.write("\n\n");
      out.write("<!-- BEGIN FRAMING TABLE:open tags, keep at 100%-->\n");
      out.write("<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n\t");
      out.write("<tr>\n\t\t");
      out.write("<td width=\"10\">");
      out.write(
          "<img src=\"/wt-portal/images/spacers/spacer.gif\" height=\"1\" width=\"10\" border=\"0\" alt=\"WebTelemetry LLC\">");
      out.write("</td>\n\t\t");
      out.write("<td>\n");
      out.write("<!-- END FRAMING TABLE:open tags, keep at 100%-->\n\n");

      LicenseManager lim = (LicenseManager) request.getAttribute("licenseManager");
      boolean valid = false;
      boolean bIsAdmin = ((Boolean) request.getAttribute("bIsAdmin")).booleanValue();
      if (lim == null) {

        out.write("\n        ");
        out.write("<p class=\"error\">License File not found!\n        ");
        if (bIsAdmin) {
          out.write("\n            Please install a license file to run WebTelemetry.\n        ");
        } else {
          out.write(
              "\n            Please contact your System Administrator to rectify this problem.\n        ");
        }
        out.write("\n        ");
        out.write("</p>\n");

      } else {
        if (!lim.isSigValid()) {

          out.write("<p class=\"error\">License File corrupted!\n           ");
          if (bIsAdmin) {
            out.write(
                "\n                Please install a new license file to run WebTelemetry.\n           ");
          } else {
            out.write(
                "\n                Please contact your System Administrator to rectify this problem.\n           ");
          }
          out.write("\n              ");
          out.write("</p>");

        } else if (lim.daysLeft() == 0) {

          out.write("<p class=\"error\">License File expired!\n\t        ");
          if (bIsAdmin) {
            out.write(
                "\n\t            Please install a license file to run WebTelemetry.\n\t        ");
          } else {
            out.write(
                "\n\t            Please contact your System Administrator to rectify this problem.\n\t        ");
          }
          out.write("\n            ");
          out.write("</p>");

        } else {
          valid = true;
        }
      }

      out.write("\n");
      out.write("<table width=\"98%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n");
      if (bIsAdmin) {
        out.write("\n    ");
        out.write("<tr>\n\t\t");
        if (lim != null) {
          out.write("\n\t\t");
          out.write("<td colspan=\"2\" align=\"right\" valign=\"top\">\n\t\t");
        } else {
          out.write("\n\t\t");
          out.write("<td colspan=\"2\" align=\"left\" valign=\"top\">");
          out.write("<br>\n\t\t");
        }
        out.write("\n\t\t");
        out.write("<a href=\"/wt-core/license/manager.do?currentCommand=");
        out.print(WTLicenseForm.LICENSE_UPLOAD);
        out.write("\">");
        out.write(
            "<img src=\"/wt-portal/images/buttons/btn_install_license.gif\" border=\"0\" alt=\"Install a New License\" vspace=\"4\">");
        out.write("</a>\n        ");
        out.write("<a class=\"tt\" href=\"javascript:towerTip(");
        out.print(WTTips.TIP_LICENSE_UPLOAD);
        out.write(");\" title=\"Telemetry Tip\">");
        out.write("<img src=\"/wt-portal/images/icons/tower_tips.gif\" border=\"0\">");
        out.write("</a>\n&nbsp;&nbsp;\n\t\t");
        out.write("\n");
        out.write("</td>");
        out.write("</tr>\n");
      }
      out.write("\n    ");
      out.write("<tr>\n        ");
      out.write("<td colspan=\"2\">");
      out.write(
          "<img src=\"/wt-portal/images/spacers/spacer.gif\" height=\"4\" width=\"10\" border=\"0\" alt=\"WebTelemetry LLC\">");
      out.write("</td>\n    ");
      out.write("</tr>\n\n");

      if (lim != null) {
        String licStatus =
            valid ? "<span class='success'>Valid</span>" : "<span class='error'>Invalid</span>";
        String exp = lim.getFeature(License.WT_EXPIRATION_FIELD_NAME);

        int trCount = -1;

        out.write("\n\t     ");
        out.write("<tr class=\"tableHeader\">\n\t        ");
        out.write("<td class=\"tableHeader\" width=\"70%\">Attribute");
        out.write("<a class=\"tt\" href=\"javascript: towerTip(");
        out.print(WTTips.TIP_LICENSE_ATTRIBUTES);
        out.write(");\" title=\"Telemetry Tip\">");
        out.write("<img src=\"/wt-portal/images/icons/tower_tips.gif\" border=\"0\">");
        out.write("</a>");
        out.write("</td>\n\t        ");
        out.write("<td class=\"tableHeader\" width=\"30%\">Value");
        out.write("</td>\n\t    ");
        out.write("</tr>\n\n        ");
        String trColor = (++trCount % 2 == 0) ? "tableRowLight" : "tableRowDark";
        out.write("\n\t    ");
        out.write("<tr class=\"");
        out.print(trColor);
        out.write("\">\n\t        ");
        out.write("<td class=\"tableText\">Support License");
        out.write("</td>\n\t        ");
        out.write("<td class=\"tableText\">");
        out.print(licStatus);
        out.write("</td>\n\t    ");
        out.write("</tr>\n\n        ");
        trColor = (++trCount % 2 == 0) ? "tableRowLight" : "tableRowDark";
        out.write("\n\t    ");
        out.write("<tr class=\"");
        out.print(trColor);
        out.write("\">\n\t        ");
        out.write("<td class=\"tableText\">Support Licensor");
        out.write("</td>\n");
        out.write("<!-- \n\t        ");
        out.write("<td class=\"tableText\">");
        out.print(lim.getFeature(License.WT_LICENSOR_FIELD_NAME));
        out.write("</td>\n\t\t-->\n\t\t ");
        out.write("<td class=\"tableText\">WebTelemetry LLC");
        out.write("</td>\n\t    ");
        out.write("</tr>\n\n        ");
        trColor = (++trCount % 2 == 0) ? "tableRowLight" : "tableRowDark";
        out.write("\n\t    ");
        out.write("<tr class=\"");
        out.print(trColor);
        out.write("\">\n\t        ");
        out.write("<td class=\"tableText\">Support Licensee");
        out.write("</td>\n\n");
        out.write("<!--\n\t        ");
        out.write("<td class=\"tableText\">");
        out.print(lim.getFeature(License.WT_LICENSEE_FIELD_NAME));
        out.write("</td>\n-->\n\t\t ");
        out.write("<td class=\"tableText\">WebTelemetry LLC");
        out.write("</td>\n\n\t    ");
        out.write("</tr>\n\n\n");
        out.write("\n\n        ");
        trColor = (++trCount % 2 == 0) ? "tableRowLight" : "tableRowDark";
        out.write("\n\t    ");
        out.write("<tr class=\"");
        out.print(trColor);
        out.write("\">\n\t        ");
        out.write("<td class=\"tableText\">Discovery Engine");
        out.write("</td>\n\t    ");

        String safariStatus =
            (Integer.parseInt(lim.getFeature(License.WT_SAFARI_MASTER_ACCOUNT_ID_FIELD_NAME)) > 0
                    && Integer.parseInt(lim.getFeature(License.WT_SAFARI_USER_COUNT_FIELD_NAME))
                        > 0)
                ? "Enabled"
                : "Disabled";
        if (!"Disabled".equals(safariStatus)) {
          int safariDaysLeft = lim.daysLeft(License.WT_SAFARI_EXPIRATION_FIELD_NAME);
          if (safariDaysLeft == 0) safariStatus = "Expired";
        }

        out.write("\n\t        ");
        out.write("<td class=\"tableText\">");
        out.print(safariStatus);
        out.write("</td>\n\t    ");
        out.write("</tr>\n\n\t    ");

        if (!"Disabled".equals(safariStatus)) {

          out.write("\n            ");
          trColor = (++trCount % 2 == 0) ? "tableRowLight" : "tableRowDark";
          out.write("\n\t\t    ");
          out.write("<tr class=\"");
          out.print(trColor);
          out.write("\">\n\t\t        ");
          out.write("<td class=\"tableText\">Smart Discovery Expiration Date");
          out.write("</td>\n\t\t        ");
          out.write("<td class=\"tableText\">");
          out.print(lim.getFeature(License.WT_SAFARI_EXPIRATION_FIELD_NAME));
          out.write("\n\t\t    ");
          out.write("</tr>\n\t    ");
        }

        out.write("    \n");
      }

      out.write("\n");
      out.write("</table>\n\n");
      out.write("<!-- BEGIN FRAMING TABLE:close tags-->\n\t\t");
      out.write("</td>\n\t");
      out.write("</tr>\n");
      out.write("</table>\n");
      out.write("<!-- END FRAMING TABLE:close tags-->\n");
      out.write("<br>\n\n");
      JspRuntimeLibrary.include(
          request,
          response,
          "../includes/footer.jsp"
              + "?"
              + "location="
              + "admin"
              + "&"
              + "help="
              + "WTHelp_License.html",
          out,
          false);
      out.write("\n\n  ");
      out.write("</BODY>\n ");
      out.write("<!-- end list-organiztion.jsp -->\n");
      out.write("</HTML>\n");
    } 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);
    }
  }
  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=utf-8");
      pageContext =
          _jspxFactory.getPageContext(
              this, request, response, "/jsp/GeneralError.jsp", true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      java.util.Date now = null;
      synchronized (pageContext) {
        now = (java.util.Date) pageContext.getAttribute("now", PageContext.PAGE_SCOPE);
        if (now == null) {
          try {
            now =
                (java.util.Date)
                    java.beans.Beans.instantiate(
                        this.getClass().getClassLoader(), "java.util.Date");
          } catch (ClassNotFoundException exc) {
            throw new InstantiationException(exc.getMessage());
          } catch (Exception exc) {
            throw new ServletException("Cannot create bean of class " + "java.util.Date", exc);
          }
          pageContext.setAttribute("now", now, PageContext.PAGE_SCOPE);
        }
      }
      out.write("\n\n");
      out.write("\n");
      out.write("<script type=\"text/javascript\" src=\"");
      if (_jspx_meth_c_url_0(pageContext)) return;
      out.write("\">");
      out.write("</script>\n\n");
      out.write("\n");
      if (_jspx_meth_html_xhtml_0(pageContext)) return;
      out.write("\n");
      out.write("\n\n\n");
      out.write("\n");
      out.write("<!--");
      out.write("<table border=\"1\">\n    ");
      out.write("<tr>\n        ");
      out.write("<td>\n            ");
      out.write("<u>");
      if (_jspx_meth_fmt_message_0(pageContext)) return;
      out.write("</u>");
      out.write("<br/>");
      out.write("<br/>-->\n            ");
      out.write("<span class=\"error\">");
      if (_jspx_meth_fmt_message_1(pageContext)) return;
      out.write("</span>\n            ");
      out.write("<br/>\n        ");
      out.write("<!--");
      out.write("</td>\n    ");
      out.write("</tr>\n");
      out.write("</table>-->\n\n");
      /* ----  c:if ---- */
      org.apache.taglibs.standard.tag.el.core.IfTag _jspx_th_c_if_0 =
          (org.apache.taglibs.standard.tag.el.core.IfTag)
              _jspx_tagPool_c_if_test.get(org.apache.taglibs.standard.tag.el.core.IfTag.class);
      _jspx_th_c_if_0.setPageContext(pageContext);
      _jspx_th_c_if_0.setParent(null);
      _jspx_th_c_if_0.setTest("${not empty querygroupresult}");
      int _jspx_eval_c_if_0 = _jspx_th_c_if_0.doStartTag();
      if (_jspx_eval_c_if_0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
        do {
          out.write("\n");
          out.write("<table>\n\t");
          /* ----  c:forEach ---- */
          org.apache.taglibs.standard.tag.el.core.ForEachTag _jspx_th_c_forEach_0 =
              (org.apache.taglibs.standard.tag.el.core.ForEachTag)
                  _jspx_tagPool_c_forEach_var_items.get(
                      org.apache.taglibs.standard.tag.el.core.ForEachTag.class);
          _jspx_th_c_forEach_0.setPageContext(pageContext);
          _jspx_th_c_forEach_0.setParent(_jspx_th_c_if_0);
          _jspx_th_c_forEach_0.setItems("${querygroupresult.resultItems}");
          _jspx_th_c_forEach_0.setVar("resultitem");
          int[] _jspx_push_body_count_c_forEach_0 = new int[] {0};
          try {
            int _jspx_eval_c_forEach_0 = _jspx_th_c_forEach_0.doStartTag();
            if (_jspx_eval_c_forEach_0 != javax.servlet.jsp.tagext.Tag.SKIP_BODY) {
              do {
                out.write("\n        ");
                out.write("\n            ");
                out.write("\n            ");
                out.write("<tr valign=\"top\">\n                ");
                out.write("<td width=\"60%\">");
                out.write("<b>");
                if (_jspx_meth_fmt_message_2(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write(":");
                out.write("</b>");
                out.write("</td>\n                ");
                out.write("<td width=\"40%\">");
                if (_jspx_meth_c_out_0(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("</td>\n            ");
                out.write("</tr>\n            \n            ");
                out.write("\n            ");
                out.write("<tr valign=\"top\">\n                ");
                out.write("<td width=\"60%\">");
                out.write("<b>");
                if (_jspx_meth_fmt_message_3(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write(":");
                out.write("</b>");
                out.write("</td>\n                ");
                out.write("<td width=\"40%\">");
                if (_jspx_meth_c_out_1(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("</td>\n            ");
                out.write("</tr>\n            \n            ");
                out.write("\n            ");
                out.write("<tr valign=\"top\">\n                ");
                out.write("<td width=\"60%\">");
                out.write("<b>");
                if (_jspx_meth_fmt_message_4(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write(":");
                out.write("</b>");
                out.write("</td>\n                ");
                out.write("<td width=\"40%\">");
                if (_jspx_meth_fmt_formatNumber_0(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("</td>\n            ");
                out.write("</tr>\n            \n            ");
                if (_jspx_meth_c_if_1(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("\n            \n            ");
                out.write("\n            ");
                out.write("<tr valign=\"top\">\n                ");
                out.write("<td width=\"60%\">");
                out.write("<b>");
                if (_jspx_meth_fmt_message_7(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("</b>");
                out.write("</td>\n                ");
                out.write("<td width=\"40%\">\n                \t");
                if (_jspx_meth_c_choose_0(
                    _jspx_th_c_forEach_0, pageContext, _jspx_push_body_count_c_forEach_0)) return;
                out.write("\n\n                ");
                out.write("</td>\n            ");
                out.write("</tr>\n          \n");
                out.write("            \n");
                out.write("\n    ");
                int evalDoAfterBody = _jspx_th_c_forEach_0.doAfterBody();
                if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
              } while (true);
            }
            if (_jspx_th_c_forEach_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) return;
          } catch (Throwable _jspx_exception) {
            while (_jspx_push_body_count_c_forEach_0[0]-- > 0) out = pageContext.popBody();
            _jspx_th_c_forEach_0.doCatch(_jspx_exception);
          } finally {
            _jspx_th_c_forEach_0.doFinally();
            _jspx_tagPool_c_forEach_var_items.reuse(_jspx_th_c_forEach_0);
          }
          out.write("\n");
          out.write("</table>\n");
          int evalDoAfterBody = _jspx_th_c_if_0.doAfterBody();
          if (evalDoAfterBody != javax.servlet.jsp.tagext.BodyTag.EVAL_BODY_AGAIN) break;
        } while (true);
      }
      if (_jspx_th_c_if_0.doEndTag() == javax.servlet.jsp.tagext.Tag.SKIP_PAGE) return;
      _jspx_tagPool_c_if_test.reuse(_jspx_th_c_if_0);
      out.write("\n\n\n");
    } 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);
    }
  }
示例#7
0
  /**
   * Gets the invitations from the database and prints their details.
   *
   * @param facebookId - Facebook id of the user
   * @return true if the list of invitation details are printed successfully
   */
  private boolean getInvitations(String facebookId) {
    try {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      conn =
          DriverManager.getConnection(
              "jdbc:mysql://localhost:3306/getoffthecouch", "XXXXXX", "XXXXXX");

      Statement checkStmt = conn.createStatement();
      String checkQuery =
          "SELECT COUNT(*) FROM invitation WHERE invitee='" + facebookId + "' AND confirmed=0";
      ResultSet checkQueryResult = checkStmt.executeQuery(checkQuery);
      checkQueryResult.next();
      int count = checkQueryResult.getInt(1);

      if (count == 0) {
        return false;
      }

      Statement getInvitationsStmt = conn.createStatement();
      String getInvitationsQuery =
          "SELECT i.inv_id, l.loc_name, e.date, e.time, u.user_name, e.total_score, l.cat_id, i.event_id, l.photo_thumb "
              + "FROM invitation i, location l, event e, user u WHERE i.event_id=e.event_id AND e.loc_id = l.loc_id "
              + "AND i.invitee='"
              + facebookId
              + "' AND u.user_id=i.inviter AND i.confirmed=0";
      ResultSet getInvitationsResult = getInvitationsStmt.executeQuery(getInvitationsQuery);
      int invitationId = -1;
      String locationName = "";
      String dateAndTime = "";
      String userName = "";
      int totalScore = -1;
      int categoryId = -1;
      int eventId = -1;
      String photoThumb = "";

      while (getInvitationsResult.next()) {
        invitationId = getInvitationsResult.getInt("inv_id");
        locationName = getInvitationsResult.getString("loc_name");
        String date = getInvitationsResult.getString("date");
        String time = getInvitationsResult.getString("time");
        SimpleDateFormat sqlFormatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        try {
          Date dateObject = sqlFormatter.parse(date + " " + time);
          SimpleDateFormat outputFormatter = new SimpleDateFormat("d MMM yyyy, HH:mm");
          dateAndTime = outputFormatter.format(dateObject);
        } catch (ParseException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
        }
        userName = getInvitationsResult.getString("user_name");
        totalScore = getInvitationsResult.getInt("total_score");
        categoryId = getInvitationsResult.getInt("cat_id");
        eventId = getInvitationsResult.getInt("event_id");
        photoThumb = getInvitationsResult.getString("photo_thumb");
        String output =
            invitationId
                + "|"
                + locationName
                + "|"
                + dateAndTime
                + "|"
                + userName
                + "|"
                + totalScore
                + "|"
                + categoryId
                + "|"
                + eventId
                + "|"
                + photoThumb;
        out.println(output);
      }
      getInvitationsStmt.close();
      return true;
    } catch (InstantiationException e) {
      e.printStackTrace(out);
      return false;
    } catch (IllegalAccessException e) {
      e.printStackTrace(out);
      return false;
    } catch (ClassNotFoundException e) {
      e.printStackTrace(out);
      return false;
    } catch (SQLException e) {
      e.printStackTrace(out);
      return false;
    }
  }
示例#8
0
  /**
   * Get Query By Form results throught response output stream.
   *
   * @param queryspec Name of XML file containing the Query Specification
   * @param columnlist List of comma separated column names to retrieve
   * @param where SQL WHERE clause to apply
   * @param order by SQL ORDER BY clause to apply
   * @param showas Output format. One of { "CSV" <i>(comma separated)</i>, "TSV" <i>(tabbed
   *     separated)</i>, "XLS" <i>(Excel)</i> }
   * @throws IOException
   * @throws FileNotFoundException
   * @throws ServletException
   */
  public void doGet(HttpServletRequest request, HttpServletResponse response)
      throws IOException, FileNotFoundException, ServletException {
    Class oDriver;
    Connection oConn = null;
    ServletOutputStream oOut = response.getOutputStream();
    QueryByForm oQBF;
    String sQuerySpec;
    String sColumnList;
    String sWhere;
    String sOrderBy;
    String sShowAs;
    String sStorage;

    if (DebugFile.trace) {
      DebugFile.writeln("Begin HttpQueryServlet.doGet(...)");
      DebugFile.incIdent();
    }

    sStorage = Environment.getProfileVar("hipergate", "storage");

    if (DebugFile.trace) DebugFile.writeln("storage=" + sStorage);

    try {
      oDriver = Class.forName(jdbcDriverClassName);
    } catch (ClassNotFoundException ignore) {
      oDriver = null;
      if (DebugFile.trace)
        DebugFile.writeln("Class.forName(" + jdbcDriverClassName + ") : " + ignore.getMessage());
      response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, "Database driver not found");
    }

    if (null == oDriver) return;

    try {

      sQuerySpec = request.getParameter("queryspec");
      sColumnList = request.getParameter("columnlist");
      if (null == sColumnList) sColumnList = "*";
      sWhere = request.getParameter("where");
      if (null == sWhere) sWhere = "1=1";
      sOrderBy = request.getParameter("orderby");
      if (null == sOrderBy) sOrderBy = "";
      sShowAs = request.getParameter("showas");
      if (null == sShowAs) sShowAs = "CSV";

      if (DebugFile.trace)
        DebugFile.writeln("queryspec=" + sQuerySpec != null ? sQuerySpec : "null");
      if (DebugFile.trace) DebugFile.writeln("where=" + sWhere);
      if (DebugFile.trace) DebugFile.writeln("orderby=" + sOrderBy);

      if (hasSqlSignature(sColumnList)) {
        response.sendError(HttpServletResponse.SC_BAD_REQUEST, "Invalid Column List Syntax");
        return;
      }

      oQBF = new QueryByForm("file://" + sStorage + "/qbf/" + sQuerySpec + ".xml");

      if (DebugFile.trace) DebugFile.writeln("DriverManager.getConnection(" + jdbcURL + ",...)");
      oConn = DriverManager.getConnection(jdbcURL, dbUserName, dbUserPassword);

      // Send some basic http headers to support binary d/l.
      if (sShowAs.equalsIgnoreCase("XLS")) {
        response.setContentType("application/x-msexcel");
        response.setHeader(
            "Content-Disposition",
            "inline; filename=\"" + oQBF.getTitle(request.getLocale().getLanguage()) + " 1.csv\"");
      } else if (sShowAs.equalsIgnoreCase("CSV")) {
        response.setContentType("text/plain");
        response.setHeader(
            "Content-Disposition",
            "attachment; filename=\""
                + oQBF.getTitle(request.getLocale().getLanguage())
                + " 1.csv\"");
      } else if (sShowAs.equalsIgnoreCase("TSV")) {
        response.setContentType("text/tab-separated-values");
        response.setHeader(
            "Content-Disposition",
            "attachment; filename=\""
                + oQBF.getTitle(request.getLocale().getLanguage())
                + " 1.tsv\"");
      } else {
        response.setContentType("text/plain");
        response.setHeader(
            "Content-Disposition",
            "inline; filename=\"" + oQBF.getTitle(request.getLocale().getLanguage()) + " 1.txt\"");
      }

      if (0 == sOrderBy.length())
        oQBF.queryToStream(
            oConn, sColumnList, oQBF.getBaseFilter(request) + " " + sWhere, oOut, sShowAs);
      else
        oQBF.queryToStream(
            oConn,
            sColumnList,
            oQBF.getBaseFilter(request) + " " + sWhere + " ORDER BY " + sOrderBy,
            oOut,
            sShowAs);

      oConn.close();
      oConn = null;

      oOut.flush();
    } catch (SQLException e) {
      if (DebugFile.trace) DebugFile.writeln("SQLException " + e.getMessage());
      response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, e.getMessage());
    } catch (ClassNotFoundException e) {
      if (DebugFile.trace) DebugFile.writeln("ClassNotFoundException " + e.getMessage());
      response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, e.getMessage());
    } catch (IllegalAccessException e) {
      if (DebugFile.trace) DebugFile.writeln("IllegalAccessException " + e.getMessage());
      response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, e.getMessage());
    } catch (Exception e) {
      if (DebugFile.trace) DebugFile.writeln("Exception " + e.getMessage());
      response.sendError(HttpServletResponse.SC_INTERNAL_SERVER_ERROR, e.getMessage());
    } finally {
      try {
        if (null != oConn) if (!oConn.isClosed()) oConn.close();
      } catch (SQLException e) {
        if (DebugFile.trace) DebugFile.writeln("SQLException " + e.getMessage());
      }
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End HttpQueryServlet.doGet()");
    }
  } // doGet()
  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=utf-8");
      pageContext =
          _jspxFactory.getPageContext(
              this, request, response, "/jsp/GeneralError.jsp", true, 8192, true);
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      out.write("\n\n");
      out.write("\n");
      java.util.Date now = null;
      synchronized (pageContext) {
        now = (java.util.Date) pageContext.getAttribute("now", PageContext.PAGE_SCOPE);
        if (now == null) {
          try {
            now =
                (java.util.Date)
                    java.beans.Beans.instantiate(
                        this.getClass().getClassLoader(), "java.util.Date");
          } catch (ClassNotFoundException exc) {
            throw new InstantiationException(exc.getMessage());
          } catch (Exception exc) {
            throw new ServletException("Cannot create bean of class " + "java.util.Date", exc);
          }
          pageContext.setAttribute("now", now, PageContext.PAGE_SCOPE);
        }
      }
      out.write("\n\n");
      out.write("\n");
      out.write("<script type=\"text/javascript\" src=\"");
      if (_jspx_meth_c_url_0(pageContext)) return;
      out.write("\">");
      out.write("</script>\n\n");
      out.write("\n");
      if (_jspx_meth_html_xhtml_0(pageContext)) return;
      out.write("\n");
      out.write("\n\n");
      if (_jspx_meth_html_html_0(pageContext)) return;
    } 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);
    }
  }