public static void updateLigneCommandeClient(int idlignecommandeclient, int idarticle,int idcommande,int quantite, Float prixht,Float prixttc,Float remise ) throws SQLException {

          String query="";        

        try {
            query = " UPDATE  LIGNE_COMMANDE_CLIENT SET ID_ARTICLE=?,ID_COMMANDE=?,LIGQTE=?,LIGPXHT=?,LIGPXTTC=?,LIGREMISE=? where ID_LIGNE=? ; " ;

            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(7,idlignecommandeclient);
            pStatement.setInt(1,idarticle);
            pStatement.setInt(2, idcommande);
            pStatement.setInt(3, quantite);
            pStatement.setFloat(4,prixht);
            pStatement.setFloat(5,prixttc);
            pStatement.setFloat(6,remise);
            pStatement.executeUpdate();

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

        }
      }