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 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108
| package packag.form.login;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Verif extends HttpServlet
{
/**
*
*/
private static final long serialVersionUID = 1L;
//Constructeur doGet
public void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
page(req, res);
}
//Constructeur doPost
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
page(req, res);
}
//Méthode qui crée la page d'accueil
public void page(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try
{
//Ouverture de la base de donnée "projet"
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url="jdbc:mysql://localhost:1444/phpmyadmin/teste";
//la variable "pseudo"
String pseudo=req.getParameter("pseudo");
//La variable "pass"
String pass=req.getParameter("passe");
Connection con=DriverManager.getConnection(url,"","");
Statement stmt=con.createStatement();
//Selection des tuples dans lesquelles LOGIN="pseudo"
ResultSet rs=stmt.executeQuery("select * from compte where identifiant = '" + pseudo + "'");
//Verification du "pseudo" et du "pass"
int a=0;
int b=0;
String prenom="";
while(rs.next())
{
//la variable "passe" correspond au mot de passe correspondant au login dans la base de données
String passe=rs.getString("password");
//Si "passe"="pass" alors le participant existe
if(passe.equals(pass))
{
a=1;
prenom=rs.getString("prenom");
break;
}
b++;
}
//Si le participant existe
if(a==1)
{
//Création de la page
out.println("<HTML>");
out.println("<HEAD>");
out.println("<title>BIENVENUE</title>");
out.println("<SCRIPt Language= Javascript>");
out.println("alert("+'"'+"Bienvenue "+prenom+" !!!"+'"'+")");
out.println("</SCRIPT>");
out.println("</HEAD>");
out.println("</HTML> ");
}
else
{
out.println("<CENTER>Compte inexistant.</CENTER>");
}
stmt.close();
con.close();
out.close();
}
catch(Exception e)
{}
}
} |
Partager