ｆｘｌｌ； - 経済統計練習帳

package dl6;
 
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 t=new pro();
    }
    pro(){
 
 
 
       readfile sub=new readfile();
       sub.makedata("data.txt","SJIS");
       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;
       int tx=0;
       for(s=0;s<x.length;s++){
        String[] y=x[s].split("</td>");
           for(sx=0;sx<y.length;sx++){
       if(y[sx].indexOf("tabindex=")>-1)tx=tx+1;
        if(y[sx].indexOf("tabindex=")>-1)link[tx]=y[sx];
 
       }
       }
 
       String  k="http://www.e-stat.go.jp/SG1/estat/";
 
  int number=tx;
 
 
   for(s=1;s<number+1;s++){
   int p1=link[s].indexOf("GL");
   int p2=link[s].indexOf("\"",p1);
   link[s]=k+link[s].substring(p1,p2);
  }
 
   int tr=10;
   for(tr=1;tr<number+1;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[] x1=str.split("</tr>");
 
       int s1=0;
 
       for(s=0;s<x1.length;s++){
       if(x1[s].indexOf("世帯分布")>-1)s1=s;
       }
 
 
 
 
        for(s=s1+1;s<s1+6;s++){
   int p1=x1[s].indexOf("GL");
   int p2=x1[s].indexOf("\"",p1);
   exl[s]=k+x1[s].substring(p1,p2);
     }
 
 
 
 
   for(s=1;s<6;s++){
   dl sub3=new dl();
   sub3.makedata(exl[s1+s], "data/"+tr+"("+s+")"+".xls");
 
       }
 
   }
 
 
 
 
    }
}
 
 
 
package dl6;
 
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();
        }
    }
}