public static LigneCommandeClient SelectLigneCommandeClientById(int id) throws SQLException {
        String query = null;
        LigneCommandeClient commande = new LigneCommandeClient();
        ResultSet resultat;

        try {
            query = "SELECT * from LIGNE_COMMANDE_CLIENT  where ID_LIGNE=? ";
            PreparedStatement pStatement = ConnectionBDD.getInstance().getPreparedStatement(query);
            pStatement.setInt(1, id);
            resultat = pStatement.executeQuery();

            while (resultat.next()) {

                commande = new LigneCommandeClient(resultat.getInt("ID_LIGNE"), resultat.getInt("ID_ARTICLE"), resultat.getInt("ID_COMMANDE"), resultat.getInt("LIGQTE"), resultat.getFloat("LIGPXHT"), resultat.getFloat("LIGPXTTC"), resultat.getFloat("LIGREMISE"));
            }

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

        }
        return commande;
    }