public List<User> DisplayAllUsers (){


        List<User> listeUsers = new ArrayList<>();

        String requete = "select * from User";
        try {
           Statement statement = MyConnection.getInstance().createStatement();
            ResultSet resultat = statement.executeQuery(requete);

            while(resultat.next()){
                User user =new User();
                user.setId(resultat.getInt(1));
                user.setLogin(resultat.getString(2));
                user.setPassword(resultat.getString(3));
                user.setLastName(resultat.getString(4));
                user.setFirstName(resultat.getString(5));
                user.setSexe(resultat.getString(6));
                user.setAddress(resultat.getString(7));
                user.setEmail(resultat.getString(8));
                user.setDateB(resultat.getDate(9));
                user.setCity(resultat.getString(10));
                user.setImg(resultat.getString(11));
                user.setRank(resultat.getInt(12));
                user.setDateI(resultat.getDate(13));
                user.setBlocked(resultat.getBoolean(14));

                listeUsers.add(user);
            }
            return listeUsers;
        } catch (SQLException ex) {
           //Logger.getLogger(PersonneDao.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("Error : "+ex.getMessage());
            return null;
        }
    }