/**
* 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;
}
}
/**
* 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;
}
}
/**
* 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 /> ");
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 \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);
}
}
/**
* 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;
}
}
/**
* 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);
}
}