６５５ｐ０００ - 経済統計練習帳

package blog;
 
 
import tool.*;
 
 
public class pro {
 
  int s,datanumber;
String[] data=new String[5000];
String[][] subdata=new String[5000][10];
 
    public static void main(String[] args) {
        pro te=new pro();
 
 
    }
 
pro(){
 
    	 String str1="%20";
 
        String id="1t44XhdJDmlVkXXTocsmzpaqUu5m-OoZ12CJHn01E";
 
       String urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT";
       urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1;
       urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY";
 
   getdata sub=new getdata();
   sub.makedata(urlx,"UTF-8");
   data=sub.data;
   datanumber=sub.datanumber;
 
   String str="";
   for(s=1;s<datanumber+1;s++){
   str=str+data[s];
 
   }
   String[] x=str.split("],");
 
   int sx;
 
 for(s=1;s<x.length;s++){  
 x[s]=x[s].replace("[","");
 String[] y=x[s].split(",");
 for(sx=0;sx<y.length;sx++){
 y[sx]=y[sx].replace("\"","");
 y[sx]=y[sx].replace(" ","");
 y[sx]=y[sx].replace("]]}","");
 y[sx]=y[sx].replace("rows:","");
subdata[s][sx+1]=y[sx];     
 }
 }
 
 
 
 
 
 
}
 
 
 
}