public ArrayList<RecipeModel> getAllRecipes() {
        ArrayList<RecipeModel> recipeList = new ArrayList<RecipeModel>();

        // Cr�ation de la requ�te
        java.sql.Statement query;

        try {

            // create connection
            connection = java.sql.DriverManager.getConnection("jdbc:mysql://"
                    + dB_HOST + ":" + dB_PORT + "/" + dB_NAME, dB_USER, dB_PWD);

            // Creation de l'�l�ment de requ�te
            query = connection.createStatement();

            // Executer puis parcourir les r�sultats
            java.sql.ResultSet rs = query
                    .executeQuery("SELECT * FROM Recipe;");
            while (rs.next()) {
                // Cr�ation de  la recette
                RecipeModel recipe = new RecipeModel(
                        rs.getString("title"), rs.getString("description"),
                        rs.getInt("expertise"), rs.getInt("duration"),
                        rs.getInt("nbpeople"), rs.getString("type"));
                System.out.println("Recipe : " + recipe);

                // ajout de la recette r�cup�r�e � la liste
                recipeList.add(recipe);
            }
            rs.close();
            query.close();
            connection.close();

        } catch (SQLException e) {
            e.printStackTrace();
        }

        return recipeList;
    }