public Deal RechercheParId(int idDeal) {
        PrestataireDeServiceDAO psdao = new PrestataireDeServiceDAO();
        try {
            String sql = "SELECT * FROM deal WHERE idDeal='" + idDeal + "'";
            ResultSet rs = crud.exeRead(sql);
            Deal d = new Deal();
            while (rs.next()) {
               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")));
                
                
                
            }
            return d;

        } catch (SQLException ex) {
            Logger.getLogger(DAO.DealDAO.class.getName()).log(Level.SEVERE, null, ex);
            return null;
        }
    }