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
| String login = JTLogin.getText();
String mdp = JPMdp.getPassword().toString();
maConnexion.ObtenirConnexion();
con = maConnexion.ObtenirConnexion();
try
{
//création de la requete
statement = con.prepareStatement("SELECT password FROM users WHERE login ='"+login+"' ");
resultat = statement.executeQuery();
if(resultat.next())
{
String motDePass = resultat.getString(1);
if(motDePass.equals(mdp))
{
JOptionPane.showMessageDialog(null, "Connexion reussie !", "SUCCESS", JOptionPane.PLAIN_MESSAGE);
RessourcesHumaine rh = new RessourcesHumaine();
rh.setVisible(true);
}
else
{
JOptionPane.showMessageDialog(null, "Mot de passe incorect !","Erreur",(1));
}
}
else
{
JOptionPane.showMessageDialog(null, "Login incorrect !","Erreur",(1));
}
//Recuperation de la requete dans la variable
resultat = statement.executeQuery();
// con.close();
}
catch(SQLException e)
{
System.out.println(e.getMessage());
} |
Partager