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
| <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%@include file="connexion.jsp"%>
<%
String statut=" ";
//recuperation des données
String Pseudo=request.getParameter("Pseudo");
String Motpass=request.getParameter("Motpass");
String Type=request.getParameter("Type");
//Recherche du connecté
PreparedStatement pst=null;
ResultSet rs=null;
pst=con.prepareStatement("select Pseudo, MotPass, Type from utilisateur where Pseudo=? and Motpass=? and Type=?" );
pst.setString(1, Pseudo);
pst.setString(2, Motpass);
pst.setString(3, Type);
rs=pst.executeQuery();
while(rs.next()){
statut=rs.getString(3);
if(statut =="admin")
{
this.getServletContext().getRequestDispatcher("/frais.jsp").forward(request,response); }
else if(statut =="professeur")
{
this.getServletContext().getRequestDispatcher("/accueil.jsp").forward(request,response);
}
else
{
this.getServletContext().getRequestDispatcher("/listeetudiant.jsp").forward(request,response);
}
}
con.close();
%>
</body>
</html> |
Partager