package donnee;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.sun.media.jfxmedia.logging.Logger;

import modele.Etudiant;

public class EtudiantDAO {
	
	public List<Etudiant> listerEtudiants()
	{
		Logger.logMsg(Logger.INFO, "EtudiantDAO.listerEtudiants()");
		List<Etudiant> etudiants = new ArrayList<Etudiant>();
		
		Connection connection = BaseDeDonnees.getInstance().getConnection();
		try {
			Statement requeteListeEtudiants = connection.createStatement();
			ResultSet curseurEtudiants = requeteListeEtudiants.executeQuery("SELECT * FROM etudiant");
			
			while(curseurEtudiants.next())
			{
				int id = curseurEtudiants.getInt("id");
				String prenom = curseurEtudiants.getString("prenom");
				String nom = curseurEtudiants.getString("nom");
				
				Etudiant etudiant = new Etudiant(id, prenom, nom);
				etudiants.add(etudiant);
				//System.out.println("Etudiant : " + prenom);
			}
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		return etudiants;
	}

}