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

package car;
 
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 te=new pro();
    }
    pro(){
 
        int sx=0;
 
        int tr=6;
 
        for(tr=1;tr<15;tr++){
 
        String urlx="http://www.mlit.go.jp/k-toukei/cgi-bin/search.cgi?houkoku=06yyyymmb000nn&file_ext=excelhtml&nengetu_nengou1=%95%BD%90%AC&nengetu_nen1=1&nengetu_getu1=&nengetu_flag=after&nengetu_nengou2=%95%BD%90%AC&nengetu_nen2=&nengetu_getu2=&page="+tr+"&p_ret=4";
 
        getdata sub7=new getdata();
          sub7.makedata(urlx,"SJIS");
        data=sub7.data;
        datanumber=sub7.datanumber; 
 
 
        for(s=1;s<datanumber+1;s++){
            int h=0;
            if(data[s].indexOf("excelhtml")>-1)h=h+1;
             if(data[s].indexOf("自動車輸送統計調査")>-1)h=h+1;
            if(h==2)sx=sx+1;
        if(h==2)link[sx]=data[s];
        }
 
    }
 
 
 
 
        int number=sx;
 
 
 
     for(s=1;s<number+1;s++){  
 
        int p1=link[s].indexOf("sea");
        int p2=link[s].indexOf("\"",p1);
 
        link[s]="http://www.mlit.go.jp/k-toukei/"+link[s].substring(p1,p2);
 
 
    }
 
 
 
 
     for(tr=1;tr<number+1;tr++){
 
         System.out.println(link[tr]);
 
        getdata sub4=new getdata();
          sub4.makedata(link[tr],"SJIS");
        data=sub4.data;
        datanumber=sub4.datanumber; 
 
     String web="";
 
      for(s=1;s<datanumber+1;s++){
          int h=0;
      if(data[s].indexOf("業態別")>-1)h=h+1;
      if(data[s].indexOf("品目別")>-1)h=h+1;
      if(h==2)web=data[s];
      }
 
 
       int p1=web.indexOf("excel");
       int p2=web.indexOf("\"",p1);
 
       System.out.println(tr+","+web);
 
        web="http://www.mlit.go.jp/k-toukei/search/"+web.substring(p1,p2);
 
 
    dl sub8=new dl();
    sub8.makedata(web,"data/"+tr+".xls");
 
    }
 
 
 
    }
 
 
 
}
 
 
package car;
 
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();
        }
    }
}