import java.sql.*;
import java.util.ArrayList;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.ServletContext.*;
import javax.servlet.RequestDispatcher.*;

import java.io.*;

public class Connexion extends HttpServlet {

    static Connection link;
    static String myURL = "jdbc:odbc:AirLine";
    
    static final private String CONTENT_TYPE = "text/html";

	/*	***************************	*/
	/*	CONNECTING TO THE DATA BASE	*/
	/*	***************************	*/
    
    public static void connect() {
    	try {
    		DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
    		link = DriverManager.getConnection(myURL);
    	} catch (SQLException e) {
    		System.out.println("Echec de la connexion : " + e.getMessage());
    	}
    }
    
 
    /*	*******************************	*/
	/*	CATCHING THE HTTP POST REQUEST	*/
	/*	*******************************	*/
    
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    	
    	
    	Statement query;
    	String question;
    	ResultSet answer;
    	String nom,pass;
    	
		nom = request.getParameter("log");
		connect();
    	try {query = link.createStatement();
			question = "SELECT password FROM user WHERE Name='"+ nom +"'";
			answer = query.executeQuery(question);
			if (answer.next()!=false){
		    pass = answer.getString("password");}
			
			if  (request.getParameter("pwd").equals("pass")){				
				RequestDispatcher r =getServletContext().getRequestDispatcher("/PageAdmin.jsp");
				r.forward(request,response) ;	
			}
			else {
				RequestDispatcher r = getServletContext().getRequestDispatcher("/ConnectionError.jsp");			
				r.forward(request,response);
			}
    	} catch (SQLException e) {
    		System.out.println("Connection error: " + e.getMessage());
    	}
    }
    
    public void doGet(HttpServletRequest requete, HttpServletResponse reponse) throws ServletException, IOException {
    	doPost(requete,reponse);
    }

	/*	*******************	*/
	/*	SERVLET DESTRUCTOR	*/
	/*	*******************	*/
    
    public void destroy() {
		super.destroy();
		try { link.close();
		} catch (Exception e) {
			System.err.println(e.getMessage());
		}
    }
    
}