public static List<CommandeClient> selectCommandeClient() throws SQLException {

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

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

            while (resultat.next()) {

               // CommandeClient cmd = new CommandeClient(resultat.getInt("ID_COMMANDE"), resultat.getInt("ID_ENTREPRISE"), resultat.getInt("ID_COMMERCIAL"), resultat.getString("COMREF"), resultat.getDate("COMDATE"), resultat.getFloat("COMREMISE"));
               // Commande.add(cmd);
            }

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

        }

        return Commande;

    }