分析 ｆｔ - 経済統計練習帳

package memo;
import tool.*;
 
 
public class pro {
 
  int s,datanumber;
String[] data=new String[5000];
 String[] codex=new String[5000];
 String[] code=new String[5000];
String[] name=new String[5000];
    public static void main(String[] args) {
        pro te=new pro();
 
 
    }
 
pro(){
 
    	 String str1="%20";
 
        String id="1OxeDw746FHwOVwWKUajfQXVjgls7dpBB-lgZ3k9a";
 
       String urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT";
       urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1;
       urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY";
      System.out.println(urlx);
 
        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 sx;
 int tx=0;
   String[] x=str.split("]");
 for(s=1;s<x.length;s++){  
 
String[] y=x[s].split(",");
 for(sx=0;sx<y.length;sx++){
  if(sx==3)tx=tx+1;
     if(sx==3)code[tx]=y[sx];
 if(sx==5)tx=tx+1;
     if(sx==5)code[tx]=y[sx];
 
 }
 }
 
int number=tx;
 
 for(s=1;s<number+1;s++){
  code[s]=code[s].trim();
}
 
 
 
 str1="%20";
 
        id="1exYc2fNRAq1S0wZXHBUms_ZWXzXY0UR7dWmin3UR";
 
       urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT";
       urlx=urlx+str1+"*"+str1+"FROM"+str1+id+str1;
       urlx=urlx+"&key=AIzaSyAH0WCAXRIdHdbI-6bnMSN4kVDDZZmGyqY";
 
   getdata sub2=new getdata();
   sub2.makedata(urlx,"UTF-8");
   data=sub2.data;
   datanumber=sub2.datanumber; 
 
   str="";
   for(s=1;s<datanumber+1;s++){
   str=str+data[s];
 
   }
 
   String[] x1=str.split("]");
 tx=0;
   for(s=1;s<x1.length;s++){  
 
String[] y=x1[s].split(",");
 
for(sx=0;sx<y.length;sx++){
  if(sx==4)tx=tx+1;
     if(sx==4)name[tx]=y[sx-1];
     if(sx==4)codex[tx]=y[sx];
 }
 }
 
int numberx=tx;
 
System.out.println(numberx);
 
for(s=1;s<numberx+1;s++){
  codex[s]=codex[s].trim();   
}
 
for(s=1;s<numberx+1;s++){
 int h=0;   
for(sx=1;sx<number+1;sx++){
if(codex[s].equals(code[sx]))h=100;
}  
System.out.println(name[s]+","+h);
}
 
 
 
 
 
}
 
 
 
}