ｄｌｌ９ - 経済統計練習帳

package link;
 
import tool.*;
 
 
 
public class pro {
 
    int s,datanumber;
    String[] data=new String[5000];
    String[] name=new String[5000];
  String[] link=new String[5000];
 
  String[] namex=new String[5000];
  String[] web=new String[5000];
  int number;
 
    public static void main(String[] args) {
        pro t=new pro();
    }
 
    pro(){
 
 
 
        String urlx="http://www.e-stat.go.jp/SG1/estat/OtherList.do?bid=000000330002&cycode=1";
 
 
  getdata sub2=new getdata();
  sub2.makedata(urlx,"UTF-8");
  data=sub2.data;
  datanumber=sub2.datanumber; 
 
 
  String str="";
  int sx=0;
  for(s=1;s<datanumber+1;s++){
       if(data[s].indexOf("/List.do?")>-1)sx=sx+1;
      if(data[s].indexOf("/List.do?")>-1)link[sx]=data[s];
 
  }
 
  number=sx;
 
  for(s=1;s<number+1;s++){
 
 
      int p1=link[s].indexOf("List.do?");
     int p2=link[s].indexOf("\"",p1);  
        link[s]=link[s].substring(p1,p2);
 
  }
 
 
 
  for(s=1;s<number+1;s++){
 
        urlx="http://www.e-stat.go.jp/SG1/estat/"+link[s];
 
link sub=new link();
  sub.makedata(urlx,s); 
 
  }
 
 
 
 
 
 
 
 
    }
 
 
 
}
 
 
package link;
 
 
import tool.*;
 
 
 
public class link{
 
    int s,datanumber;
    String[] data=new String[5000];
    String[] name=new String[5000];
  String[] link=new String[5000];
 
  String[] namex=new String[5000];
  String[] web=new String[5000];
  int number;
 
 
 
    void makedata(String urlx,int k){
 
 
 
 
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("</tr>");
 
  int sx;
 
     for(s=0;s<x.length;s++){   
     name[s]="";
     link[s]="";
    String[] y=x[s].split("</td>");
     for(sx=0;sx<y.length;sx++){
     y[sx]=y[sx].replace(" ","");
      y[sx]=y[sx].replace("	","");
      if(sx==2)name[s]=y[sx];
      if(sx==3)link[s]=y[sx];
     }
 
     }
 
 
  sx=0;   
     for(s=0;s<x.length;s++){
     if(link[s].indexOf("Excelファイル")>-1)sx=sx+1;
      if(link[s].indexOf("Excelファイル")>-1)namex[sx]=name[s];
       if(link[s].indexOf("Excelファイル")>-1)web[sx]=link[s];  
     }   
 
 
     number=sx;
 
 
 
     for(s=1;s<number+1;s++){
     int p1=web[s].indexOf("Xlsdl.do?");
     int p2=web[s].indexOf("\"",p1);  
        web[s]=web[s].substring(p1,p2);
      web[s]="http://www.e-stat.go.jp/SG1/estat/"+web[s];
    }   
 
       System.out.println(number);
       for(s=1;s<number+1;s++){
       dl sub7=new dl();
       sub7.makedata(web[s], "data/"+k+"("+s+")"+".xls");
 
 
       }
 
 
 
    }
 
 
 
}
 
 
package link;
 
import java.io.*;
import java.io.File;
import java.net.URL;
import java.net.URLConnection;
import java.io.File;
import java.io.*;
 
public class dl {
 
 
 
 
 
 
   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();
        }
    }
}