Charger et afficher des données de la base et d'un fichier CSV simple en 5 minutes

INSERT INTO `eleve` (`id`, `nom`, `prenom`, `classe`, `date_naissance`, `adresse`, `sexe`) VALUES
(1, 'Durand', 'Marie', 3, '1992-01-02 00:00:00', '15 rue du Lac 75001 Paris', 'FEMME'),
(2, 'Alesi', 'Julie', 3, '1992-01-08 00:00:00', '72 av. Jean Dupont 75003 Paris', 'FEMME'),
(3, 'Martini', 'Carine', 3, '1992-01-17 00:00:00', '2 rue du Moulin 92230 Neullavy', 'FEMME'),
(4, 'Varola', 'Sophie', 3, '1992-01-21 00:00:00', '15 rue du Lac 75001 Paris', 'FEMME'),
...
(48, 'Valegin', 'Jean', 3, '1992-11-28 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME'),
(49, 'Eto', 'Gabin', 3, '1992-11-18 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME'),
(50, 'Fivolini', 'Kevin', 3, '1992-12-06 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME'),
(51, 'Laferme', 'Martin', 3, '1992-12-07 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME'),
(52, 'Dupuis', 'Vincent', 3, '1992-12-15 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME'),
(53, 'Lagrange', 'Alexandre', 3, '1992-12-28 00:00:00', '15 rue du Lac 75001 Paris', 'HOMME');

# Nom;Prénom;Note

Durand;Marie;5
Alesi;Julie;8
Martini;Carine;10,5
Varola;Sophie;12
Labiche;Lelou;12
Dujardin;Anne;13
Laventure;Martine;14
...
Fivolini;Kevin;19
Laferme;Martin;20
Dupuis;Vincent;20

public class NoteService {

    private List<NoteEleve> notes;
    ...

    public synchronized List<NoteEleve> findLastNotes() {

        doBouchon();     // ici le bouchon

        return notes;
    }

    private void doBouchon() {
        if (notes != null) {
            return;
        }

        notes = new ArrayList<NoteEleve>();

        // Filles (nom, prenom, annee, sexe, note)
        addEleveEtNote("Durand", "Marie", 3, FEMME, 5);
        addEleveEtNote("Alesi", "Julie", 3, FEMME, 8);
        addEleveEtNote("Martini", "Carine", 3, FEMME, 10);
        ...
        addEleveEtNote("Baladini", "Mathilde", 3, FEMME, 17);

        // Garcons (nom, prenom, annee, sexe, note)
        addEleveEtNote("Michelet", "Jean", 3, HOMME, 0);
        addEleveEtNote("Dupond", "Pierre", 3, HOMME, 2);
        addEleveEtNote("Timberot", "Martin", 3, HOMME, 4);
        ...
        addEleveEtNote("Fivolini", "Kevin", 3, HOMME, 19);
        addEleveEtNote("Laferme", "Martin", 3, HOMME, 20);
        addEleveEtNote("Dupuis", "Vincent", 3, HOMME, 20);
    }

    private void addEleveEtNote(String nom, String prenom, Integer annee, Sexe sexe, int note) {
        addEleveEtNote(nom, prenom, annee, sexe, new Double(note));
    }

    private void addEleveEtNote(String nom, String prenom, Integer annee, Sexe sexe, Double note) {
        final Eleve eleve = new Eleve(nom, prenom, annee, sexe);
        final NoteEleve noteEleve = new NoteEleve(eleve, note);
        notes.add(noteEleve);
    }

public class Eleve {

    private Integer id;
    private String nom;
    private String prenom;
    private Integer annee;
    private Sexe sexe;
    private Date dateNaissance;
    private String adresse;

    public Eleve(String nom, String prenom, Integer annee, Sexe sexe, Date dateNaissance, String adresse) {
        ...
    }

    public Eleve(Integer id, String nom, String prenom, Integer annee, Sexe sexe, Date dateNaissance, String adresse) {
        ...
    }

    // + getter et setter

}

public enum Sexe {

    HOMME("Garçon"),
    FEMME("Fille");

    private final String label;

    Sexe(String label) {
        this.label = label;
    }

    public String getLabel() {
        return label;
    }
}

public class NoteEleve {

    private Eleve eleve;
    private Double note;

    public NoteEleve(Eleve eleve, Double note) {
        ...
    }

    // + getter et setter

public class NoteService {

    private static NoteService instance;

    private List<NoteEleve> notes;

    private NoteService() {
        ...
    }

    public synchronized List<NoteEleve> findLastNotes() {

        doBouchon();     // ici le bouchon

        return notes;
    }

    private void doBouchon() {
        ...
    }
}

public class NotesModele extends AbstractTableModel {

    private final String[] entetes = { "Nom", "Prénom", "Année", "Sexe", "Note" };

    private NoteService noteService;

    private List<NoteEleve> notes;

    public NotesModele() {
        noteService = NoteService.getInstance();
        notes = noteService.findLastNotes();
    }

    ...

    public List<NoteEleve> getNotes() {
        return notes;
    }
}

public interface EleveDao {

    List<Eleve> findEleves();

    List<Eleve> findElevesByClasse(Integer classe);
}

public interface NoteDao {

     Map<String, Double> findNotesDernierExam();
}

public class NoteService {

    private static NoteService instance;

    private List<NoteEleve> notes;

    private NoteService() {
        ...
    }

    public synchronized List<NoteEleve> findLastNotes() {

        notes = new ArrayList<NoteEleve>();

        return notes;
    }

    // Suppression du bouchon.
    // private void doBouchon() {
    //     ...
    // }
}

public class NoteService {

    ...

    private NoteDao noteDao;
    private EleveDao eleveDao;

    /**
     * Constructeur prive
     */
    private NoteService() {
        super();

        noteDao = new CsvNoteDao();
        eleveDao = new DbEleveDao();
    }

    ...

    public synchronized List<NoteEleve> findLastNotes() {
        notes = new ArrayList<NoteEleve>();

        // 1) Chargement de la liste des eleves en base
        List<Eleve> eleves = eleveDao.findEleves();

        // 2) Chargement des notes depuis le fichier CSV
        Map<String, Double> map = noteDao.findNotesDernierExam();

        return notes;
    }

    ...

    public synchronized List<NoteEleve> findLastNotes() {

        // 1) Chargement de la liste des eleves en base
        List<Eleve> eleves = eleveDao.findEleves();

        // 2) Chargement des notes depuis le fichier CSV
        Map<String, Double> map = noteDao.findNotesDernierExam();

        // 3) Init avec la bonne taille
        notes = new ArrayList<NoteEleve>( eleves.size() );

        return notes;

    ...

    private Map<String, Double> dataToMap(List<String[] > data) {
        //final Map<String, Double> map = new HashMap<String, Double>();
        final Map<String, Double> map = new HashMap<String, Double>( data.size() ); // init avec la bonne taille

    public synchronized List<NoteEleve> findLastNotes() {

        // 1) Chargement de la liste des eleves en base
        List<Eleve> eleves = eleveDao.findEleves();

        // 2) Chargement des notes depuis le fichier CSV
        Map<String, Double> map = noteDao.findNotesDernierExam();

        // 3) Init avec la bonne taille
        notes = new ArrayList<NoteEleve>( eleves.size() );

        // 4) fusion des donnees
        for (Eleve eleve : eleves) {
            final String key = eleve.getNom() + " " + eleve.getPrenom();    // ex. "DUPONT Jean"
            Double valeur = map.get(key);
            if (valeur == null) {
                valeur = 0.0;   // Si eleve absent
            }
            NoteEleve noteEleve = new NoteEleve(eleve, valeur);
            notes.add(noteEleve);
        }

        return notes;

    ...

package com.thi.notes.service;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

import com.thi.notes.dao.CsvNoteDao;
import com.thi.notes.dao.DbEleveDao;
import com.thi.notes.dao.EleveDao;
import com.thi.notes.dao.NoteDao;
import com.thi.notes.domain.Eleve;
import com.thi.notes.domain.NoteEleve;

public class NoteService {

    private static NoteService instance;

    private List<NoteEleve> notes;

    private NoteDao noteDao;
    private EleveDao eleveDao;

    private NoteService() {
        super();

        noteDao = new CsvNoteDao();
        eleveDao = new DbEleveDao();
    }

    public static synchronized NoteService getInstance() {
        if (instance == null) {
            instance = new NoteService();
        }

        return instance;
    }

    public synchronized List<NoteEleve> findLastNotes() {

        // 1) Chargement de la liste des eleves en base
        List<Eleve> eleves = eleveDao.findEleves();

        // 2) Chargement des notes depuis le fichier CSV
        Map<String, Double> map = noteDao.findNotesDernierExam();

        // 3) Init avec la bonne taille
        notes = new ArrayList<NoteEleve>(eleves.size());

        // 4) fusion des donnees
        for (Eleve eleve : eleves) {
            final String key = eleve.getNom() + " " + eleve.getPrenom();
            Double valeur = map.get(key);
            if (valeur == null) {
                valeur = 0.0;
            }
            final NoteEleve noteEleve = new NoteEleve(eleve, valeur);
            notes.add(noteEleve);
        }

        return notes;
    }
}

package com.thi.notes.ihm;

import java.util.List;

import javax.swing.table.AbstractTableModel;

import com.thi.notes.domain.NoteEleve;
import com.thi.notes.domain.Sexe;
import com.thi.notes.service.NoteService;

public class NotesModele extends AbstractTableModel {

    private final String[] entetes = { "Nom", "Prénom", "Année", "Sexe", "Note" };

    private NoteService noteService;

    private List<NoteEleve> notes;

    public NotesModele() {
        super();
        noteService = NoteService.getInstance();
        notes = noteService.findLastNotes();
    }

    @Override
    public int getColumnCount() {
        return entetes.length;
    }

    @Override
    public String getColumnName(int columnIndex) {
        return entetes[columnIndex];
    }

    @Override
    public int getRowCount() {
        return notes.size();
    }

    @Override
    public Object getValueAt(int rowIndex, int columnIndex) {
        switch (columnIndex) {

        case 0:
            // Nom
            return notes.get(rowIndex).getEleve().getNom();

        case 1:
            // Prenom
            return notes.get(rowIndex).getEleve().getPrenom();

        case 2:
            // Annee
            return notes.get(rowIndex).getEleve().getAnnee();

        case 3:
            // Sexe
            return notes.get(rowIndex).getEleve().getSexe();

        case 4:
            // Note au controle
            return notes.get(rowIndex).getNote();

        default:
            throw new IllegalArgumentException();
        }
    }

    @Override
    public Class<?> getColumnClass(int columnIndex) {
        switch (columnIndex) {

        case 0:
        case 1:
            return String.class;

        case 3:
            return Sexe.class;

        case 2:
            return Integer.class;

        case 4:
            return Double.class;

        default:
            return Object.class;
        }
    }

    public List<NoteEleve> getNotes() {
        return notes;
    }
}