jQuery读取并输出JSON数据

Question

我有来自雅虎（YQL）的提要，需要将一些信息输出到网页。有人可以帮忙吗？谢谢！！这让我非常头痛。哈哈

cbfunc({
 "query": {
  "count": "1",
  "created": "2010-12-07T10:38:18Z",
  "lang": "en-US",
  "results": {
   "quote": {
    "symbol": "^FTSE",
    "Ask": null,
    "AverageDailyVolume": "0",
    "Bid": null,
    "AskRealtime": null,
    "BidRealtime": null,
    "BookValue": null,
    "Change_PercentChange": "+67.33 - +1.17%",
    "Change": "+67.33",
    "Commission": null,
    "ChangeRealtime": "+67.33",
    "AfterHoursChangeRealtime": "N/A - N/A",
    "DividendShare": null,
    "LastTradeDate": "12/7/2010",
    "TradeDate": null,
    "EarningsShare": null,
    "ErrorIndicationreturnedforsymbolchangedinvalid": "N/A",
    "EPSEstimateCurrentYear": null,
    "EPSEstimateNextYear": null,
    "EPSEstimateNextQuarter": null,
    "DaysLow": "5769.67",
    "DaysHigh": "5838.52",
    "YearLow": "4790.04",
    "YearHigh": "5902.11",
    "HoldingsGainPercent": "- - -",
    "AnnualizedGain": "-",
    "HoldingsGain": null,
    "HoldingsGainPercentRealtime": "- - -",
    "HoldingsGainRealtime": null,
    "MoreInfo": "cnv",
    "OrderBookRealtime": "N/A",
    "MarketCapitalization": null,
    "MarketCapRealtime": null,
    "EBITDA": null,
    "ChangeFromYearLow": null,
    "PercentChangeFromYearLow": null,
    "LastTradeRealtimeWithTime": "5:20am - <b>5837.61</b>",
    "ChangePercentRealtime": "+67.33 - +1.17%",
    "ChangeFromYearHigh": null,
    "PercebtChangeFromYearHigh": null,
    "LastTradeWithTime": "5:20am - <b>5837.61</b>",
    "LastTradePriceOnly": "5837.61",
    "HighLimit": null,
    "LowLimit": null,
    "DaysRange": "5769.67 - 5838.52",
    "DaysRangeRealtime": "5769.67 - 5838.52",
    "FiftydayMovingAverage": null,
    "TwoHundreddayMovingAverage": null,
    "ChangeFromTwoHundreddayMovingAverage": null,
    "PercentChangeFromTwoHundreddayMovingAverage": null,
    "ChangeFromFiftydayMovingAverage": null,
    "PercentChangeFromFiftydayMovingAverage": null,
    "Name": "FTSE 100",
    "Notes": "-",
    "Open": "5770.28",
    "PreviousClose": "5770.28",
    "PricePaid": null,
    "ChangeinPercent": "+1.17%",
    "PriceSales": null,
    "PriceBook": null,
    "ExDividendDate": "N/A",
    "PERatio": null,
    "DividendPayDate": "N/A",
    "PERatioRealtime": null,
    "PEGRatio": null,
    "PriceEPSEstimateCurrentYear": null,
    "PriceEPSEstimateNextYear": null,
    "Symbol": "^FTSE",
    "SharesOwned": null,
    "ShortRatio": null,
    "LastTradeTime": "5:20am",
    "TickerTrend": "N/A",
    "OneyrTargetPrice": null,
    "Volume": "0",
    "HoldingsValue": null,
    "HoldingsValueRealtime": null,
    "YearRange": "4790.04 - 5902.11",
    "DaysValueChange": "- - +1.17%",
    "DaysValueChangeRealtime": "- - +1.17%",
    "StockExchange": "FSI",
    "DividendYield": null,
    "PercentChange": "+1.17%"
   }
  }
 }
});

Answer 1

经过两天的绞尽脑汁，得到了答案。简直不敢相信。这是代码。这只是为了输出 FTSE 100 的 YQL 查询数据。感谢大家的回答！

<div id="finance"></div>

<script type="text/javascript" src="js/jquery-1.4.4.min.js"></script>
<script type="text/javascript">
$(function() {
    $.getJSON(

"http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.quotes%20where%20symbol%20in%20(%22%5EFTSE%22)%0A%09%09&format=json&env=http%3A%2F%2Fdatatables.org%2Falltables.env&callback=?", 

function(json){
  $('#finance').text(json.query.results.quote.Change);  
    // Patching payload into page element ID = "dog"
});


});
</script>

Answer 2

jQuery.getJSON() ：使用 GET HTTP 请求从服务器加载 JSON 编码的数据。

jQuery.parseJSON ：采用格式良好的 JSON 字符串并返回生成的 JavaScript 对象。

Answer 3

你到底想输出什么？如果这是字符串格式的有效 JSON 对象，您可以使用...

var obj = eval(JSON);

其中 JSON 是您从 Yahoo 接收的提要。

然后您可以访问对象的属性，例如。

var queryCount = obj.query.count;