@Override
    public ArrayList<Question> chargeLesQuestions() {
        ArrayList<Question> l = new ArrayList<Question>();
        Connection conn = this.daoFactory.getConnexion();
        
        
        String sql = "select id_question, question, palier from question";
        
        try {
            Statement st = conn.createStatement();
            ResultSet res = st.executeQuery(sql);
            
            while (res.next()) {
                int id = res.getInt("id_question");
                String sql2 = "select * from reponse where id_question = "+id;
                try {
                    Statement st2 = conn.createStatement();
                    ResultSet res2 = st2.executeQuery(sql2);
                    ArrayList<Reponse> r = new ArrayList<Reponse>();
                    while (res2.next()){
                        Reponse rep = new Reponse(res2.getInt("id_reponse"),res2.getInt("id_question"), res2.getString("reponse"), res2.getBoolean("reponse_juste"));
                        r.add(rep);
                    }
                    Question e = new Question(res.getInt("id_question"), res.getString("question"), res.getInt("palier"), r);
                    l.add(e);
                }
                catch (SQLException se) {
            System.out.println("Erreur rq sql : " + se.getMessage());
        }
                
                   
            }
        } catch (SQLException se) {
            System.out.println("Erreur rq sql : " + se.getMessage());
        } finally {
            this.daoFactory.fermeConnexion();
        }
        
        return l;
    }