code3131 - 経済統計練習帳

<!DOCTYPE html>
<html lang="ja">
    <head>
        <meta charset="utf-8" />
        <script src="sample.js"></script>
        <script src="jquery.js"></script>
        <title>信長の野望</title>
    </head>
    <body onload="sample()">
        <p id="memo"></p>
 
 
    </body>
</html>
 
var year=new Array();
var point=new Array();
 
function sample() {
 
        var query = "SELECT 'date',c1 FROM " +
            '1mfmQQ4BWoQjPaFfNSD0naRPCNiDz4NCgEBqzK7wH';
        var encodedQuery = encodeURIComponent(query);
 
        var url = ['https://www.googleapis.com/fusiontables/v1/query'];
        url.push('?sql=' + encodedQuery);
        url.push('&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY');
        url.push('&callback=?');
 
 
 
        $.ajax({
          url: url.join(''),
          dataType: 'jsonp',
          success: function (data) {
            var rows = data['rows'];
 
              sx=0;
 
for (var i in rows) {
var x1 = rows[i][0];
var x2 = rows[i][1];                  
sx=sx+1;
year[sx]=x1;
point[sx]=x2;
}
 
number=sx;
 
paint();              
 
}
});
 
}
 
function paint(){
 
str="<table>";
str=str+"<tr>";
str=str+"<td>";
str=str+"year";
str=str+"<td>";
str=str+"point";
str=str+"</td>";
str=str+"</tr>";
for(s=1;s<number+1;s++){
str=str+"<tr>";
str=str+"<td>";
str=str+year[s];
str=str+"</td>";
str=str+"<td>";
str=str+point[s];
str=str+"</td>";
str=str+"</tr>";
}
str=str+"</table>";
 
 
$("#memo").html(str);
}