1 2 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();
} |