public static List<LigneCommandeClient> selectLigneCommandeClient() throws SQLException {

        String query = null;
        List<LigneCommandeClient> commandes = new ArrayList<LigneCommandeClient>();
        ResultSet resultat;
        try {

            query = "SELECT * from LIGNE_COMMANDE_CLIENT  ";
            PreparedStatement pStatement = (PreparedStatement) ConnectionBDD.getInstance().getPreparedStatement(query);
            resultat = pStatement.executeQuery(query);

            while (resultat.next()) {
                // System.out.println(resultat.getString("PAYS"));
                LigneCommandeClient  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"));
                commandes.add(commande);
            }

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

        }

        return commandes;

        
    }