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
| package modele;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
public class Donnees_Login {
private Connection con=null;
private PreparedStatement st=null;
private ResultSet rs=null;
public Donnees_Login() {
try
{
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:8080/banque","","");
}
catch(ClassNotFoundException ex)
{
System.out.println("Probleme de pilote base de donnèes");
System.out.println(ex.getMessage());
}
catch(SQLException ex)
{
System.out.println("Probleme de connexion ou de requetes");
System.out.println(ex.getMessage());
}
}
public ArrayList<Login> RechercheUser(String user, String passe)
{
ArrayList <Login> liste=new ArrayList<Login>();
try
{
st=con.prepareStatement("select * from login where utilisateur=? and mpasse=?");
st.setString(1,user);
st.setString(2, passe);
rs=st.executeQuery();
while(rs.next())
{
Login l=new Login();
l.setNuml(rs.getInt("numl"));
l.setNomprenom(rs.getString("nomprenom"));
l.setUtilisateur(rs.getString("utilisateur"));
l.setMpasse(rs.getString("mpasse"));
l.setNiveau(rs.getInt("niveau"));
liste.add(l);
}
}
catch(SQLException ex)
{
System.out.println(ex.getMessage());
}
return liste;
}
} |
Partager