public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;

    try {
      response.setContentType("text/html");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			null, true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;
      _jspx_resourceInjector = (org.glassfish.jsp.api.ResourceInjector) application.getAttribute("com.sun.appserv.jsp.resource.injector");

      out.write("\n");
      out.write("\n");
      out.write("<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n");
      out.write("<html xmlns=\"http://www.w3.org/1999/xhtml\">\n");
      out.write("<head>\n");
      out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" />\n");
      out.write("<title>Untitled Document</title>\n");
      out.write("<link href=\"css/css1.css\" rel=\"stylesheet\" type=\"text/css\" />\n");
      out.write("<script type=\"text/javascript\" src=\"jquery/jquery-1.7.1.min.js\"></script>\n");
      out.write("\n");
      out.write("<script type=\"text/javascript\">\n");
      out.write("function hideall(){\n");
      out.write("$(\"#a11\").hide();\n");
      out.write("$(\"#a12\").hide();\n");
      out.write("$(\"#a14\").hide();\n");
      out.write("$(\"#a15\").hide();\n");
      out.write("$(\"#a21\").hide();\n");
      out.write("$(\"#a22\").hide();\n");
      out.write("$(\"#a23\").hide();\n");
      out.write("$(\"#a24\").hide();\n");
      out.write("$(\"#a25\").hide();\n");
      out.write("}\n");
      out.write("\n");
      out.write("$(document).ready(function(){\n");
      out.write("hideall();\n");
      out.write("\n");
      out.write("$(\"#q11\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a11\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q12\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a12\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q23\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a23\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q22\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a22\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("\n");
      out.write("$(\"#q14\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a14\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q15\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a15\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q24\").click(function(){hideall();\n");
      out.write("$(\"#a24\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("$(\"#q25\").click(function(){\n");
      out.write("hideall();\n");
      out.write("$(\"#a25\").toggle('slow');\n");
      out.write("}\n");
      out.write(");\n");
      out.write("\n");
      out.write("\n");
      out.write("\n");
      out.write("\n");
      out.write("$(\"#q21\").click(function(){\n");
      out.write("$(\"#ResortRating\").toggle('slow');\n");
      out.write("}\n");
      out.write("\n");
      out.write("\n");
      out.write("\n");
      out.write("\n");
      out.write(");\n");
      out.write("});\n");
      out.write("</script>\n");
      out.write("</head>\n");
      out.write("\n");
      out.write("<body>\n");
      out.write("<h2 align=\"center\"> Agent Information</h2>\n");
      out.write("<div align=\"center\"></div>\n");
      out.write("\n");
      out.write("<div id=\"maindiv\">\n");
      out.write("<table width=\"1012\" height=\"387\" border=\"1\">\n");
      out.write("  <tr class=\"center\"><td width=\"1002\" height=\"73\">\n");
      out.write("<table width=\"1003\" height=\"281\" border=\"1\">\n");
      out.write("  \n");
      out.write("    \n");
      out.write("\n");
      out.write("  <tr>\n");
      out.write("    <td width=\"499\" height=\"272\">&nbsp;\n");
      out.write("        <div >\n");
      out.write("            <strong>Start here from Tables to insert or update or remove predefined list: </strong> \n");
      out.write("        </div>\n");
      out.write("        \n");
      out.write("        <form \n");
      out.write("          <label>Table Lookup:\n");
      out.write("         <A HREF=\"Agent.jsp\"> <li>Agent Table</A> \n");
      out.write("         <A HREF=\"Client.jsp\"> <li>Client Table</A>\n");
      out.write("         <A HREF=\"Resort.jsp\"> <li>Resort Table</A>\n");
      out.write("         <A HREF=\"Rating.jsp\"> <li>Rating Table</A>\n");
      out.write("         <A HREF=\"Amenity.jsp\"> <li>Amenity Table</A>\n");
      out.write("         <A HREF=\"Booking.jsp\"> <li>Booking Table</A>\n");
      out.write("        </form>\n");
      out.write("       \n");
      out.write("        <p  id =\"q06\"><a href=\"JavaScript:void()\">Total revenue from Bookings</a></p>\n");
      out.write("        <p  id=\"q07\"><a href=\"JavaScript:void()\">Resorts offering all amenities</a></p>\n");
      out.write(" <td width=\"487\"><p align=\"center\" id=\"q13\"><a href=\"queryAgent.php?act=a21\"> Agent who booked the most trip</a> </p>\n");
      out.write("        \n");
      out.write("        \n");
      out.write("        <p align=\"center\" id=\"q11\"><a href=\"JavaScript:void()\"> Users who stayed all inclusive</a></p> \n");
      out.write("        <p align=\"center\" id=\"q14a\"><a href=\"JavaScript:void()\"> Clients who book the most</a></p>\n");
      out.write("      <p align=\"center\" id=\"q14b\"><a href=\"JavaScript:void()\">Clients who spent most money</a></p>\n");
      out.write("       <p align=\"center\" id=\"q15\"><a href=\"JavaScript:void()\">List of agents and number of clients who booked with them</a></p>\n");
      out.write("  </tr>\n");
      out.write("  <tr> </tr>\n");
      out.write("</table>\n");
      out.write(" <div id=\"a11\">\n");
      out.write("        <p><strong>Hotel Revenue</strong></p>\n");
      out.write("        \n");
      out.write("        <label></label>\n");
      out.write("          <form id=\"form1\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a11\">\n");
      out.write("            <label>Agent Name or City\n");
      out.write("            <input type=\"text\"  name=\"value\" id=\"value\" />\n");
      out.write("</label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("<label>\n");
      out.write("<input type=\"submit\" name=\"button2\" id=\"button2\" value=\"Search\" />\n");
      out.write("</label>\n");
      out.write("<p>\n");
      out.write("  <label>\n");
      out.write("  <input type=\"radio\" name=\"radio\" id=\"radio1\" value=\"radio1\" />\n");
      out.write("    All agent</label>\n");
      out.write("  <label>\n");
      out.write("  <input type=\"radio\" name=\"radio\" id=\"radio2\" value=\"radio2\" />\n");
      out.write("  City</label>\n");
      out.write("   <label>\n");
      out.write("  <input type=\"radio\" name=\"radio\" id=\"radio3\" value=\"radio3\" />\n");
      out.write("  Agent </label>\n");
      out.write("  <label></label>\n");
      out.write("</p>\n");
      out.write("<label></label>\n");
      out.write("          </form>\n");
      out.write("        </div>      \n");
      out.write("       \n");
      out.write("       \n");
      out.write("      \n");
      out.write("           <div id=\"a12\">\n");
      out.write("        <p><strong>Activities has never been booked</strong></p>\n");
      out.write("         <form id=\"form4\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a12\">\n");
      out.write("            <label>Resort Name\n");
      out.write("            <input type=\"text\"  name=\"value2\" id=\"value2\" />\n");
      out.write("           </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("                    <label>\n");
      out.write("                    <input type=\"submit\" name=\"button\" id=\"button\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("                    <label>\n");
      out.write("                    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Or &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\n");
      out.write("                    <input type=\"radio\" name=\"radio3\" id=\"radio3\" value=\"radio3\" />\n");
      out.write("All resort</label>\n");
      out.write("<p>\n");
      out.write("              <label></label>\n");
      out.write("            </p>\n");
      out.write("         </form>\n");
      out.write("      </div>   \n");
      out.write("      \n");
      out.write("       <div id=\"a14\">\n");
      out.write("        <p><strong>List of client stay all inclusive</strong></p>\n");
      out.write("         <form id=\"form5\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a14\">\n");
      out.write("            <label>Name of Hotel :\n");
      out.write("            <input type=\"text\"  name=\"value\" id=\"value\" />\n");
      out.write("            </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("            <label>\n");
      out.write("            <input type=\"submit\" name=\"button3\" id=\"button3\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("         </form>\n");
      out.write("      </div>  \n");
      out.write("       <div id=\"a25\">\n");
      out.write("        <p><strong>List of female</strong></p>\n");
      out.write("         <form id=\"form6\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a25\">\n");
      out.write("            <label>Country name\n");
      out.write("            <input type=\"text\"  name=\"value2\" id=\"value2\" />\n");
      out.write("           </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("                    <label>\n");
      out.write("                    <input type=\"submit\" name=\"button\" id=\"button\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("        </form>\n");
      out.write("      </div>   \n");
      out.write("      <div id=\"a15\">\n");
      out.write("        <p><strong>Average of activity book</strong></p>\n");
      out.write("         <form id=\"form6\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a15\">\n");
      out.write("            <label>Client name\n");
      out.write("            <input type=\"text\"  name=\"value2\" id=\"value2\" />\n");
      out.write("           </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("                    <label>\n");
      out.write("                    <input type=\"submit\" name=\"button\" id=\"button\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("        </form>\n");
      out.write("      </div>   \n");
      out.write("      \n");
      out.write("      \n");
      out.write("      <div id=\"a22\">\n");
      out.write("        <p><strong> Client who book the most in the period</strong></p>\n");
      out.write("         <form id=\"form6\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a22\">\n");
      out.write("            <label>From: \n");
      out.write("            <input type=\"text\"  name=\"value\" id=\"value\" />\n");
      out.write("           </label>\n");
      out.write("            <label>To: \n");
      out.write("            <input type=\"text\"  name=\"value1\" id=\"value1\" />\n");
      out.write("           </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("                    <laabel>\n");
      out.write("                    <input type=\"submit\" name=\"button\" id=\"button\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("        </form>\n");
      out.write("      </div>\n");
      out.write("      \n");
      out.write("         <div id=\"a23\">\n");
      out.write("        <p><strong> Client who spent the most in the period</strong></p>\n");
      out.write("         <form id=\"form6\" name=\"form1\" method=\"post\" action=\"queryAgent.php?act=a23\">\n");
      out.write("            <label>From:\n");
      out.write("            <input type=\"text\"  name=\"value3\" id=\"value3\" />\n");
      out.write("            </label>\n");
      out.write("            <label>To: \n");
      out.write("            <input type=\"text\"  name=\"value1\" id=\"value1\" />\n");
      out.write("           </label>\n");
      out.write("&nbsp;&nbsp;\n");
      out.write("                    <laabel>\n");
      out.write("                    <input type=\"submit\" name=\"button\" id=\"button\" value=\"Search\" />\n");
      out.write("            </label>\n");
      out.write("        </form>\n");
      out.write("      </div>\n");
      out.write("           </td>\n");
      out.write("  </tr>\n");
      out.write("</table>\n");
      out.write("</div>\n");
      out.write("</body>\n");
      out.write("</html>\n");
      out.write("\n");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
        else throw new ServletException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }