dlppp7 - 経済統計練習帳

package dl2;
 
import tool.*;
 
public class pro {
 
    int s,datanumber;
    String[] data=new String[5000];
    String[] link=new String[5000];
  String[] exl=new String[5000];
 
    public static void main(String[] args) {
        pro te=new pro();
    }
 
    pro(){
 
        String urlx="http://www.e-stat.go.jp/SG1/estat/NewList.do?tid=000001073908";
 
       getdata sub=new getdata();
       sub.makedata(urlx,"UTF-8");
       data=sub.data;
       datanumber=sub.datanumber;
 
 
       int s1=0;
       for(s=1;s<datanumber+1;s++){
       if(data[s].indexOf("都道府県")>-1)s1=s;
 
       }
 
 
       String str="";
    for(s=s1;s<datanumber+1;s++){
    str=str+data[s];
 
    }
 
    String[] x=str.split("</tr>");
    for(s=0;s<x.length;s++){
   link[s]=x[s];
    }
 
    for(s=1;s<48;s++){
   int p1=link[s].indexOf("List");
   int p2=link[s].indexOf("'",p1);
   link[s]="http://www.e-stat.go.jp/SG1/estat/"+link[s].substring(p1,p2);
 
    }
 
  int point=1;
 
    int tr;
for(tr=1;tr<48;tr++){     
 
       getdata sub2=new getdata();
       sub2.makedata(link[tr],"UTF-8");
       data=sub2.data;
       datanumber=sub2.datanumber;
 
 
       str="";
    for(s=1;s<datanumber+1;s++){
    str=str+data[s];
 
    }
 
    String[] y=str.split("</tr>");
 
    int sx=0;
    for(s=0;s<y.length;s++){
    if(y[s].indexOf("Xlsdl.do?")>-1)sx=sx+1;
    if(y[s].indexOf("Xlsdl.do?")>-1)exl[sx]=y[s];       
    }
     int number=sx;
 
 
    for(s=1;s<number+1;s++){
     int p1=exl[s].indexOf("Xlsdl.do?");
   int p2=exl[s].indexOf("\"",p1);
   exl[s]="http://www.e-stat.go.jp/SG1/estat/"+exl[s].substring(p1,p2);    
    }
 
 
    dl sub9=new dl();
    sub9.makedata(exl[point], "data/"+tr+".xls");
 
 
 
 
 
}
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
    }
 
 
}
 
 
package dl2;
 
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();
        }
    }
}