import java.io.IOException;
import java.io.Writer;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class GetDirections
 */
public class GetDirections extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private double startX, startY, destX, destY;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public GetDirections() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		/**
		 * startX = Double.parseDouble(request.getParameter("startx")); startY =
		 * Double.parseDouble(request.getParameter("starty")); destX =
		 * Double.parseDouble(request.getParameter("destx")); destY =
		 * Double.parseDouble(request.getParameter("desty"));
		 */
		// récupèration des parmaterexs, controle de validité

		// connect a la bdd//
		/*
		 * Connection conn = null; Statement stmt = null; ResultSet rs = null;
		 * String pilote = ""; String url = new
		 * String("jdbc:mysql:https://phpmyadmin.ovh.net/ceremhmob");
		 * 
		 * try { Class.forName("org.gjt.mm.mysql.Driver"); conn =
		 * DriverManager.getConnection(url,"ceremhmob","platramob11"); stmt =
		 * conn.createStatement(); rs =
		 * stmt.executeQuery("select * from anomalie");
		 * 
		 * while (rs.next()) { String nom = rs.getString("WEB_USER_NAME");
		 * System.out.println(nom + "\n"); }
		 * 
		 * 
		 * 
		 * }
		 * 
		 * catch ( SQLException E) { System.out.println("SQLException: " +
		 * E.getMessage()); System.out.println("SQLState: " + E.getSQLState());
		 * System.out.println("VendorError: " + E.getErrorCode()); } catch (
		 * ClassNotFoundException E) { E.printStackTrace(); } finally { try {
		 * rs.close(); stmt.close(); conn.close(); } catch (SQLException e) { //
		 * TODO Auto-generated catch block e.printStackTrace(); }
		 * 
		 * }
		 */

		Connection maConnexion = null; // on initialise la variable maConnexion
										// de la classe Connection
		Statement st = null; // on initialise la variable st de la classe
								// Statement
		ResultSet monResultat = null; // on initialise la variable monResultat
										// de la classe ResultSet
		// chargement du pilote JDBC
		try {
			Class.forName("com.mysql.jdbc.Driver");
			//System.out.println("chargement réussi"); // affichage
		} catch (ClassNotFoundException moade) {
			System.err.println("classe non trouvée " + moade.getMessage());
		}

		// defintion de l'URL de connexion
		// la connexion
		try {
			String monUrl = "jdbc:mysql://213.186.33.28:80/ceremhmob";
			maConnexion = DriverManager.getConnection(monUrl, "ceremhmob",
					"platramob11");
			
	

			// création d'une instruction

			st = maConnexion.createStatement();

			String maRequete = "select * from anomalie";
			monResultat = st.executeQuery(maRequete);
			System.out.println("traitement réussi");

			maRequete = "select * from favoris";
			monResultat = st.executeQuery(maRequete);

			System.out.println("traitement réussi");

			while (monResultat.next()) {
				System.out.println(monResultat.getString("Commentaire"));
			}

		} catch (SQLException moade) {
			moade.printStackTrace();
		} finally {

			// fermeture de la connexion
			try {
				maConnexion.close();
			} catch (SQLException moade) {
				System.out.println("connect fe'rmee");
			}
		}
		// récupère leparcours sour forme de list de coordonnées

		// formate ta réponse

		// type de réponse

		// ecriture de la réponse.

		System.out.println(startX + " : " + startY + " : " + destX + " : "
				+ destY);

		response.setContentType("text/xml");
		Writer output = response.getWriter();

		// output.write(startX+" : "+startY+" : "+ destX+" : "+ destY);

	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doPost(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}

}