@Override
    public List<Article> findAll() {
        List<Article> listJ = new ArrayList<Article>();
        Statement st = null;
        ResultSet rs = null;
        try {
            st = this.connect().createStatement();
            rs = st.executeQuery("select * from Article");
            System.out.println("recherche général effectuée");
            
            
            while (rs.next()) {
              
                
                Article ar = new Article(rs.getInt("id"), rs.getString("titre"),rs.getString("resume"),rs.getDate("date"));
                
                
               
                               listJ.add(ar);
            }
            
            
        } catch (SQLException ex) {
            Logger.getLogger(ArticleDao.class.getName()).log(Level.SEVERE, "recherche general echoué", ex);
        }finally{
            try {
                if(rs != null)
                rs.close();
                if(st != null)
                st.close();
                
            } catch (SQLException ex) {
                Logger.getLogger(ArticleDao.class.getName()).log(Level.SEVERE, "liberation statement || resultset echoué", ex);
            }
        }
        
        
        return listJ;
    }