p35 - 経済統計練習帳

package t2;
 
import tool.getdata;
 
 
public class pro {
 
   int s,datanumber;
    String[] data=new String[5000];
 
    String[] v=new String[500];
    String[] code=new String[5000];
    int number;
    int[] point=new int[600];
 
 
    public static void main(String[] args) {
        pro test=new pro();
    }
    pro(){
 
        String codex="c1";
 
         String wh="%20";
 
        String id="1GkHwH61V98YTD_YlHSZNraV8LV3L9-wtU73bmorp";
 
       String urlx="https://www.googleapis.com/fusiontables/v1/query?sql=SELECT";
       urlx=urlx+wh+"*"+wh+"FROM"+wh+id+wh;
       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;
 
    String[] cr=x[0].split(",");
    for(s=1;s<cr.length;s++){
    System.out.println(cr[s]);
    }
 
 
    for(s=1;s<x.length;s++){
    x[s]=x[s].replace("\",","△");
     x[s]=x[s].replace(",","");   
     x[s]=x[s].replace("\"","");  
        String[] y=x[s].split("△");
 
   for(sx=0;sx<y.length;sx++){
 
   }
   }
 
 
 
 
 
 
 
    }
 
 
    String rev(String str){
 
        if(str==null)str="";
 
        int p1=str.indexOf("\"");
        int p2=str.indexOf("\"",p1+1);
        String strx="";
        if(p2>-1)strx=str.substring(p1+1,p2);
        return strx;
    }
 
 
}