087 - 経済統計練習帳

package ann;
import tool.*;
 
 
public class pro {
 
  int s,datanumber;
String[] data=new String[5000];
 String[] codex=new String[5000];
 String[][] namex=new String[50][50];
String[] name=new String[5000];
String[] rr=new String[5000];
String[] yy=new String[5000];
int[] year=new int[5];
 
public static void main(String[] args) {
        pro te=new pro();
 
 
    }
 
pro(){
 
    	 String str1="%20";
 
        String id="155SX0wbhhuyB74z3neSOpM3g4brmrO80M4EIv74Z";
 
       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];
 
   }
 
 
   int p1=str.indexOf("rows");
   p1=str.indexOf(":",p1);
   str=str.substring(p1,str.length());
 
 
 
 int sx;
 int tx=0;
   String[] x=str.split("],");
 
   for(s=0;s<x.length;s++){  
 String[] y=x[s].split(",");
 name[s+1]="";
  rr[s+1]="";
   yy[s+1]="";
 for(sx=0;sx<y.length;sx++){
 if(sx==0)yy[s+1]=y[sx];
 if(sx==1)rr[s+1]=y[sx];
 if(sx==2)name[s+1]=y[sx];
 
 }}
 
int number=x.length;
 
for(s=1;s<number+1;s++){  
    p1=name[s].indexOf("\"");
    int p2=name[s].indexOf("\"",p1+1);
    if(p1>-1)name[s]=name[s].substring(p1+1,p2);
 p1=rr[s].indexOf("\"");
    p2=rr[s].indexOf("\"",p1+1);
    if(p1>-1)rr[s]=rr[s].substring(p1+1,p2);
 p1=yy[s].indexOf("\"");
    p2=yy[s].indexOf("\"",p1+1);
   if(p1>-1) yy[s]=yy[s].substring(p1+1,p2);
}
 
 
 
 
 
for(s=1;s<number+1;s++){     
bing sub2=new bing();
String c1=sub2.makedata(name[s]);
check sub3=new check();
String n1=sub3.makedata(c1);
System.out.println(yy[s]+","+rr[s]+","+name[s]+","+c1+","+n1);
 
}
 
 
 
}
 
 
 
}