| 12
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 
 |  
package servlets;
 
import java.awt.Window;
import java.awt.event.WindowStateListener;
import java.io.*;
import java.net.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
 
/**
 *
 * @author Lecomte
 * @version
 */
public class FormServlet extends HttpServlet {
 
    public void init(ServletConfig config) throws ServletException
    {
        super.init(config);
    }
 
 
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {       
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        out.close();
    }
 
 
    protected void doGet(HttpServletRequest req, HttpServletResponse resp)
    throws ServletException, IOException {
        //processRequest(req, resp);
 
    }
 
 
    protected void doPost(HttpServletRequest req, HttpServletResponse resp)
    throws ServletException, IOException {
        //processRequest(req, resp);
        resp.setContentType("Text/html");
        PrintWriter sortie = resp.getWriter();
 
        sortie.println("<HTML><HEAD><TITLE>");
        sortie.println("Caddie Virtuel");
        sortie.println("</TITLE></HEAD><BODY>");
 
        Connection con;
        Statement instruc;
        ResultSet rs;
 
        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
        catch(ClassNotFoundException e){sortie.println("Driver JDBC-ODBC non chargé!");}
 
        try{
            con = DriverManager.getConnection("jdbc:odbc:CaddieBD","","");
            instruc = con.createStatement();
            rs = instruc.executeQuery("SELECT Password FROM Personnes WHERE Pseudo LIKE '" + req.getParameter("pseudo") + "'");
            while(rs.next()){
            if(rs.getString("Password").equals(req.getParameter("mdp")))
            {
                //Mettre en session l'utilisateur
                HttpSession session = req.getSession(true);
                String loginSaisi = req.getParameter("pseudo");
                session.setAttribute("session.login", loginSaisi);
 
                sortie.println("<H2>Bonjour " + req.getParameter("pseudo") + ".</H2>");
                sortie.println("<p>Voici les différents liens auxquelles vous avez accès:</p>");
                sortie.println("<a href=\"http://localhost:8087/ServletControl?action=Authentification&pseudo=" + req.getParameter("pseudo") + "> Brochures disponibles</a><br>");
            }   
            else
                //sortie.println("Snif...");
                resp.sendRedirect("http://localhost:8087/Test/Login.html");
            }
        }catch(SQLException e){sortie.println("<p>Erreur JDBC-ODBC: " + e.getMessage() + " --- " + e.getSQLState() + "</p>");}
 
        sortie.println("</BODY></HTML>");
        sortie.close();
    } |