public SondageReponse insert(SondageReponse obj) {
     PreparedStatement pst = null;
        try {
                            pst = this.connect().prepareStatement("INSERT INTO SondageReponse (id_sondage,choix, nombreChoix,id) VALUES (?,?,?,?);");
                            pst.setInt(1, obj.getId_sondage());
                            pst.setInt(2, obj.getChoix());
                            pst.setInt(3, obj.getNombreChoix());
                            pst.setInt(4, obj.getId());             
                            pst.executeUpdate();
                            System.out.println("insertion SondageReponse terminer");
        } catch (SQLException ex) {
            Logger.getLogger(SondageDao.class.getName()).log(Level.SEVERE, "insertion echouer", ex);
        }finally{
        
            try {
            if(pst != null)
            pst.close();
        } catch (SQLException ex) {
            Logger.getLogger(SondageDao.class.getName()).log(Level.SEVERE, "liberation du preparedstatement echouée", ex);
        }
            
        }
        
        
        
        return obj;
    }