public static void insertArticle(int idCouleur, int idtva, String libelle, String reference, float prixht, int photo) throws SQLException {

        String query;
        try {
            query = "INSERT INTO ARTICLE (ID_COULEUR,ID_TVA,ARTLIBELLE,ARTREF,ARTPRXHT,ARTPHOTO) VALUES (?,?,?,?,?,?) ";

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            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);

        }
    }