public List<Deal> ListerDeals() {

        PrestataireDeServiceDAO psdao = new PrestataireDeServiceDAO();
        try {
            String sql = "SELECT * FROM Deal ";
            ResultSet rs = crud.exeRead(sql);
            List<Deal> liste = new ArrayList<Deal>();
            while (rs.next()) {
                
                Deal d = new Deal();
                d.setIdDeal(rs.getInt("idDeal"));
                d.setLibelle(rs.getString("libelle"));
                d.setCategorie(rs.getString("categorie"));
                d.setTypeDeal(rs.getString("typeDeal"));
                d.setDateDebut(rs.getString("dateDebut"));
                d.setDateFin(rs.getString("dateFin"));
                d.setImage(rs.getString("image"));
                d.setPrixInitial(rs.getDouble("prixInitial"));
                d.setPrixPromotionnel(rs.getDouble("prixPromotionnel"));
                d.setQuantite(rs.getInt("quantite"));
                d.setStatut(rs.getInt("statut"));
                d.setPrestataireDeService(psdao.ChercherPrestataireDeService(rs.getInt("idUser")));
                liste.add(d);
            }
            return liste;
        } catch (SQLException ex) {
            Logger.getLogger(DealDAO.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }