public static Article selectArticleByRef(String ref)  throws SQLException {
        String query;
        Article article = new Article();
        ResultSet resultat;
        
        query = "SELECT * from ARTICLE where ARTREF =? ";

        PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
        pStatement.setString(1, ref);
        resultat = pStatement.executeQuery();

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