/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package servlets;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.RequestDispatcher;
import java.sql.*;
import UTH.BaseDatos;
/**
*
* @author familia
*/
@WebServlet(name = "BuscarRutaServlet", urlPatterns = {"/XFlight/BuscarRutaServlet"})public class BuscarRutaServlet extends HttpServlet {
/**
* 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"); try (PrintWriter out = response.getWriter()) { /* TODO output your page here. You may use following sample code. */
Statement Sentencia;
ResultSet rsDatos;
String pAerolinea = request.getParameter("txtAerolinea"); String pOrigen = request.getParameter("txtOrigen"); String pDestino = request.getParameter("txtDestino"); String vSQL;
vSQL="SELECT * FROM UTH.VUELOS " + " WHERE ORIGEN = '" + pOrigen + "'" + " AND DESTINO = '" + pDestino + "'";
out.println("<!DOCTYPE html>"); out.println("<html>"); out.println("<head>"); out.println("<meta charset=\"utf-8\">"); out.println("<meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge,chrome=1\">"); out.println("<title>XFlight Vuela Facil</title>"); out.println("<meta name=\"description\" content=\"\">"); out.println("<meta name=\"viewport\" content=\"width=device-width\">"); out.println("<link rel=\"stylesheet\" href=\"css/normalize.min.css\">"); out.println("<link rel=\"stylesheet\" href=\"css/main.css\">"); out.println("<script src=\"js/vendor/modernizr-2.6.2-respond-1.1.0.min.js\"></script>"); out.println("<link rel=\"stylesheet\" type=\"text/css\" media=\"all\" href=\"js/jsDatePick_ltr.min.css\" />"); out.println("<script type=\"text/javascript\" src=\"js/jsDatePick.min.1.3.js\"></script>"); out.println("<link rel=\"stylesheet\" href=\"css/table.css\" type=\"text/css\"/>"); out.println(""); out.println("</head>"); out.println("<body>"); out.println("<div class=\"header-container\">"); out.println("<header class=\"wrapper clearfix\">"); out.println("<h1 class=\"title\">XFlight, Viaje Rapido y Economico</h1>"); out.println("<nav>"); out.println("<ul>"); out.println("<li><a href=\"#\">Inicio</a></li>"); out.println(" <li><a href=\"#\">Destinos</a></li>"); out.println("<li><a href=\"#\">Contactato</a></li>"); out.println("</ul>"); out.println("</nav>"); out.println("</header>"); out.println("</div>"); out.println("<div class=\"main-container\" align=\"center\">"); //out.println("<div class=\"main wrapper clearfix\">");
out.println(" <article>"); out.println("<header>"); out.println("<h3>Puedes elegir cualquiera de los siguienes vuelos</h3>"); out.println("</header>"); out.println(""); out.println(""); out.println(""); out.println(""); try{ BaseDatos.AbrirConexionDB();
Sentencia =BaseDatos.Conexion.createStatement();
rsDatos =Sentencia.executeQuery(vSQL);
out.println("<div class=\"CSSTableGenerator\" style=\"width:700px;\">"); out.println("<table align=\"center\"><tr><td>Coorelativo </td><td>Vuelo </td><td>Origen </td><td>Destino </td><td>Precio</td><td>Cupos </td><td>Salida </td><td>LLegada </td><td>Aerolinea </td></tr>"); int vuelo = 1;
String InfoVuelo []= new String [20];
String coorelativo;
while(rsDatos.next()){
out.println("<tr><td>"+ vuelo+"</td>"); out.println("<td>"+ rsDatos.getString("NUMVUELO")+"</td>"); out.println("<td>"+ rsDatos.getString("ORIGEN")+"</td>"); out.println("<td>"+ rsDatos.getString("DESTINO")+"</td>"); out.println("<td>"+ rsDatos.getString("VALOR")+"</td>"); out.println("<td>"+ rsDatos.getString("ASIENTOSVENDIDOS")+"</td>"); out.println("<td>"+ rsDatos.getString("HSALIDA")+"</td>"); out.println("<td>"+ rsDatos.getString("HLLEGADA")+"</td>"); out.println("<td>"+ rsDatos.getString("AEROLINEA")+"</td></tr>"); coorelativo= rsDatos.getString("NUMVUELO"); InfoVuelo [vuelo]= coorelativo;
vuelo++;
}//end while
out.println("</table>"); out.println("</div>"); // out.println("<br><br>");
out.println("<form action=\"/XFlight/CompraServlet\" class=\"input-form\" id=\"registro\" method=\"post\">"); out.println("<h3>Ingrese El Numero De Vuelo que decea Comprar</h3>"); //out.println("<br>");
out.println("<input type=\"text\" name=\"txtcoorrelativo\" id=\"txtcoorrelativo\" />");
//out.println("<br><br>");
out.println("<input type='submit' id=\"comprar\" value='Comprar Boleto' />");
rsDatos.close();
}//end try
catch (SQLException SQLe){ out.println("<h1>error en conuslta</1h>"); }//end cath
out.println("</div>"); out.println("</div>"); out.println("<br><br><br>"); out.println("<div class=\"footer-container\">"); out.println("<footer class=\"wrapper\">"); out.println("<h3>Universidad Tecnologica de Honduras</h3>"); out.println("</footer>"); out.println(" </div>"); out.println(""); out.println(""); out.println(""); out.println("</body>"); out.println("</html>");
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() { return "Short description";
}// </editor-fold>
}
Crear cuenta
