public List<PrestataireDeService> ListerPrestatairesDeService() {
        try {
            String sql = "SELECT * FROM User WHERE role='PrestataireDeService'";
            ResultSet rs = crud.exeRead(sql);
            List<PrestataireDeService> liste = new ArrayList<PrestataireDeService>();
            while (rs.next()) {
                PrestataireDeService p = new PrestataireDeService();
                p.setLogin(rs.getString("login"));
                p.setAdresse(rs.getString("adresse"));
                p.setDescriptif(rs.getString("descriptif"));
                p.setTelephone(rs.getInt("telephone"));
                p.setSociete(rs.getString("societe"));
                p.setLogo(rs.getString("logo"));
                liste.add(p);
            }
            return liste;
        } catch (SQLException ex) {
            Logger.getLogger(PrestataireDeServiceDAO.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }