public static List<Article> selectArtcile() {
        String query = null;
        List<Article> listearticle = new ArrayList<Article>();
        ResultSet resultat;
        try {
            query = "SELECT * from ARTICLE  ";
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            resultat = pStatement.executeQuery(query);

            while (resultat.next()) {
                System.out.println(resultat.getString("ARTLIBELLE"));

                Article aa = new Article(resultat.getInt("ID_ARTICLE"), resultat.getInt("ID_COULEUR"), resultat.getInt("ID_TVA"), resultat.getString("ARTLIBELLE"), resultat.getString("ARTREF"), resultat.getFloat("ARTPRXHT"), resultat.getString("ARTPHOTO"));
                listearticle.add(aa);

            }

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

        }

        return listearticle;

    }