| 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
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 
 | Cookie[] cookies = request.getCookies();
 
		        if (cookies == null) {
		        	System.out.println("No cookies found");
		        } else {
		        	System.out.println("Number of cookies: " + cookies.length);
 
		            for (Cookie cookie1 : cookies) {
		                 name = cookie1.getName();
		                 value = cookie1.getValue();
		                 System.out.println(value);
		                 if (name.equals("cookieGerminal")) {break;}
 
		            }
 
		            String email = value;
 
		            PreparedStatement preparedStatement = null;
 
					preparedStatement = connection.prepareStatement("SELECT * FROM membre WHERE email= ?");
					preparedStatement.setString(1,email);
 
					resultat = preparedStatement.executeQuery();
 
					if (resultat.next()) {
						request.getServletContext().getRequestDispatcher("/bienvenue.jsp").forward(request, response);
					}
 
		        }
 
//				connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/germinal?serverTimezone=UTC","root","codepasse");
 
				String email = request.getParameter("email");
				String motpasse = request.getParameter("password");
				String rememberme = request.getParameter("rememberme");
 
				motpasse = Cryptage.crypter(motpasse,"valeur");
				email = Cryptage.crypter(email,"valeur");
 
 
			PreparedStatement preparedStatement = null;
 
			preparedStatement = connection.prepareStatement("SELECT * FROM membre WHERE email= ? and motpasse= ?");
			preparedStatement.setString(1,email);
			preparedStatement.setString(2,motpasse);
 
			resultat = preparedStatement.executeQuery();
 
				if ( resultat.next()) {
 
					System.out.println("email et mot de passe correct");
 
					if (rememberme != null) {
 
						name = "cookieGerminal";
				        value = Cryptage.decrypter(email, "valeur");
				        System.out.println(value);
				        cookie = new Cookie(name, value);    
						cookie.setMaxAge(60 * 60 * 24 * 30);
				        response.addCookie(cookie);
 
						String pseudo= resultat.getObject("pseudo").toString();
 
				        message = pseudo + " = " + value;
						request.setAttribute("text", message);
						request.getServletContext().getRequestDispatcher("/bienvenue.jsp").forward(request, response);	
 
					}
 
					else {
//						Cookie[] cookies = request.getCookies();
 
 
					 String message2 = "bienvenue " + Cryptage.decrypter(email,"valeur");
					 message = message2 + "   " + name + " = " + " VALEUR COOKIE " + value;
					request.setAttribute("text", message);
					request.getServletContext().getRequestDispatcher("/bienvenue.jsp").forward(request, response);
 
				}
				}
 
			 else  {
				    System.out.println("echec de connection avec mot de passe et email");    
 
					  message = "EMAIL OU MOT DE PASSE INCONNUS";
					 request.setAttribute("text", message);
      request.getServletContext().getRequestDispatcher("/index.jsp").forward(request, response);
					}
 
 
		        } catch (SQLException | ServletException | IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
 
}
 
} | 
Partager