だうんろ０－０－ - 経済統計練習帳

package dl;
 
import tool.*;
 
public class pro {
 
     int s,datanumber;
    String[] data=new String[5000];
  String[] link=new String[5000];
 
 
    public static void main(String[] args) {
        pro r=new pro();
    }
 
    pro(){
 
         String urlx="http://www.e-stat.go.jp/SG1/estat/GL08020102.do?_toGL08020102_&tclassID=000001065558&cycleCode=7&requestSender=estat";
 
        getdata sub=new getdata();
        sub.makedata(urlx,"UTF-8");
        data=sub.data;
        datanumber=sub.datanumber;
 
           int sx=0;
   for(s=1;s<datanumber+1;s++){
  if(data[s].indexOf("listID=")>-1)sx=sx+1;
   if(data[s].indexOf("listID=")>-1)link[sx]=data[s];
 
   }
 
     int number=sx;   
     for(s=1;s<number+1;s++){    
     int p1=link[s].indexOf("GL");
      int p2=link[s].indexOf("\"",p1);
     link[s]=link[s].substring(p1,p2);
 
    }
 
 
     int tr;
 
     for(tr=2;tr<number+1;tr++){
 
     urlx="http://www.e-stat.go.jp/SG1/estat/"+link[tr];
 
 
       getdata sub2=new getdata();
        sub2.makedata(urlx,"UTF-8");
        data=sub2.data;
        datanumber=sub2.datanumber;
 
        String str="";
   for(s=1;s<datanumber+1;s++){
   str=str+data[s];
 
 
   }
 
   String[] x=str.split("</tr>");
 
 
   String strx="";
   for(s=0;s<x.length;s++){
   if(x[s].indexOf("歳入内訳")>-1)strx=x[s]; 
   }  
 
 
 
 
 
     int p1=strx.indexOf("GL");
      int p2=strx.indexOf("\"",p1);
     strx=strx.substring(p1,p2);
 
     strx="http://www.e-stat.go.jp/SG1/estat/"+strx;
 
 
     dlx sub5=new dlx();
     sub5.makedata(strx,"data/"+tr+".xlsx");
 
     System.out.println(strx);
 
     }
 
 
    }
 
 
}
 
 
package dl;
 
import java.io.*;
import java.net.URL;
import java.net.URLConnection;
public class dlx {
 
 
 
 
 
    void makedata(String urlx,String filex){
 
 
         try {
 
URL url = new URL(urlx);
URLConnection conn = url.openConnection();
InputStream in = conn.getInputStream();
 
File file = new File(filex); 
FileOutputStream out = new FileOutputStream(file, false);
int b;
while((b = in.read()) != -1){
    out.write(b);
}
 
out.close();
in.close();
 
        } catch (Exception e) {e.printStackTrace();}  
 
 
 
    }
 
 
 
}