public void deleteCommentaire(Commentaire c){
        String requete = "delete from commentaire where id_coms_pk=?";
        try {
            PreparedStatement ps = (PreparedStatement) MyConnection.getInstance().prepareStatement(requete);
           
            ps.setInt(1, c.getIdcommentaire());
            ps.executeUpdate();
            System.out.println(" supprimée");
        } catch (SQLException ex) {
           //Logger.getLogger(PersonneDao.class.getName()).log(Level.SEVERE, null, ex);
            System.out.println("erreur lors de la suppression "+ex.getMessage());
        }
    }