public static List<Article> selectArticleByLibelle(String libelle) throws SQLException {

        String query = null;
        List<Article> listearticle = new Vector<Article>();
        ResultSet resultat;

        query = "SELECT  * from ARTICLE where ARTLIBELLE like ?";
        PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
        pStatement.setString(1, libelle.toUpperCase() + "%");
        resultat = pStatement.executeQuery();

        while (resultat.next()) {
            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);
        }

        return listearticle;
    }