public static void updateArticle(int id,int idCouleur,int idtva,String libelle,String reference,float prixht, int photo) throws SQLException {
       
        String query;
        try {
            query = "UPDATE ARTICLE set ID_COULEUR=?,ID_TVA=?,ARTLIBELLE=?,ARTREF=?,ARTPRXHT=?,ARTPHOTO=?  WHERE ID_ARTICLE=? ";
            
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(7, id);
            pStatement.setInt(1, idCouleur);
            pStatement.setInt(2, idtva);
            pStatement.setString(3, libelle.toUpperCase());
            pStatement.setString(4, reference);
            pStatement.setFloat(5, prixht);
            pStatement.setInt(6, photo);

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