private void rapatrierFormations() {
        ArrayList<Formation> formations = new ArrayList<Formation>();
        String req = "";
        req = "select * from Formation";
        ResultSet res = null;
        try {
            res = gestionUniversite.Connexion.getInstance().getStatement().executeQuery(req);
            while (res.next()) {
                String code = res.getString("code");
                String nom = res.getString("nom");
                
                String nomSalleCM = res.getString("nomSalleCM");
                String nomSalleTD = res.getString("nomSalleTD");
                
                Salle salleCM = universite.getSalle(nomSalleCM);
                Salle salleTD = universite.getSalle(nomSalleTD);
                
                Formation formation = new Formation(nom, code, salleCM, salleTD);
                formations.add(formation);        
            }

            //res = gestionUniversite.Connexion.getInstance().getStatement().executeQuery(req);
        } catch (SQLException ex) {
            Logger.getLogger(ModeleApplication.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            if (res != null) {
                try {
                    res.close();
                } catch (SQLException ex) {
                    Logger.getLogger(ModeleApplication.class.getName()).log(Level.SEVERE, null, ex);
                }
            }
        }
        
        this.universite.setLesFormations(formations);
        for (Formation formation : formations) {
                formation.setModules(this.reconstruireModules(formation.getCode()));
                formation.setSuccessor(this.universite);
            }
    }