HttpClient 返回错误的 csv？

Question

您好，我一直在尝试从 http: 下载 csv //download.finance.yahoo.com/d/quotes.csv?s=msft&f=sl1p2 并一直在尝试随后解析数据。这是下面的代码。目前它只返回 toast 中的 html 标头。知道为什么它不返回 csv 中的实际结果吗？

    Stock stock = new Stock();
    try {

        //need to call yahoo api and get csv -> parse csv for most recent price and price change
        HttpClient httpClient = new DefaultHttpClient();
        HttpContext localContext = new BasicHttpContext();
        HttpGet httpGet = new HttpGet(uri);
        HttpResponse response = httpClient.execute(httpGet, localContext);
        String result = "";

        BufferedReader reader = new BufferedReader(new InputStreamReader(response.getEntity().getContent()));

        String line = "";
        while ((line = reader.readLine()) != null){

              result += line + "\n";
              String[] RowData = result.split("\n");
              Toast.makeText(this, result, Toast.LENGTH_LONG).show();
              String name = RowData[0];
              String price = RowData[1];
              String change = RowData[2];

              stock.setPrice(Double.parseDouble(price));
              stock.setTicker(name);
              stock.setChange(change);


            }

Answer 1

您不需要在逗号而不是换行符上分割吗？

String[] RowData = result.split(",");

当我使用上面的代码运行代码并将 Toast 替换为

System.out.println("result = "+ result);

我得到：

result = "MSFT",24.80,"+0.08%"

并且 name、price 和 change 的值已成功填充。我根本没有看到标题行。

请注意，Java 约定变量名称以小写字母开头，因此 rowData 而不是 RowData。

Answer 2

 http://download.finance.yahoo.com/d/quotes.csv?s=msft&f=sl1p2

您提供的网址包含两个参数：

1: s=msft
   -this is the yahoo finance api code for microsoft

2: f=sl1p2 
   - this contains 3 sub-parameters
   - s [it is the company name]
   - l1 [it is the company's last quote price]
   - p2 [it is the price change]

所以我猜您获得的 CSV 是正确的。

Answer 3

<?php

function getStockSite($stockLink){

   if ($fp = fopen($stockLink, 'r')) {
      $content = '';

      while ($line = fread($fp, 1024)) {
         $content .= $line;
      }
   }

   return $content;  
}

?>

<table cellpadding="0" style="width:700px;" cellspacing="0">

<tr>
<th>Country</th>
<th>Indices</th>
<th>Date</th>
<th>Price</th>
<th>Prev. Price</th>
<th>High</th>
<th>Low</th>
<th>Change</th>
</tr>


<?php

$url="http://finance.yahoo.com/d/quotes.csv?s=^BSESN&f=d1p5phgc6";
try
{
$data = getStockSite($url);
$bse=explode(",",$data);
}
catch(exception $e)
{
}
?>

<tr>
<td>INDIA</td>
<td>SENSEX</td>
<td><?php echo $bse[0];?></td>
<td><?php echo $bse[1];?></td>
<td><?php echo $bse[2];?></td>
<td><?php echo $bse[3];?></td>
<td><?php echo $bse[4];?></td>
<td><?php echo $bse[5];?></td>
<tr>


</table>