p081509 - 経済統計練習帳

package travel;
 
import tool.*;
 
public class pro {
 
 
     String[] data=new String[50000];
int s,sx,datanumber,tx;
      String[] v=new String[50000];
      String[] bus=new String[50000];
      String[] credit=new String[50000];
       String[] year=new String[50000];
 
      String[] code_go=new String[50000];
      String[] code_come=new String[50000];
 
 
          int creditnumber;
String[] creditp=new String[50];
String[] style=new String[50];
int[] strlong=new int[50];
     String[][] datax=new String[500000][10];
 
    public static void main(String[] args) {
       pro re=new pro();
    }
 
 
    pro(){
 
 
        creditnumber=4;
        creditp[1]="year";
        creditp[2]="bus";
        creditp[3]="credit";
        creditp[4]="value"; 
        style[1]="INTEGER";
        style[2]="VARCHAR";
        style[4]="VARCHAR";
       style[3]="VARCHAR";
        strlong[4]=20;
strlong[3]=20;
        strlong[1]=20;
strlong[2]=20;
 
        String db,tab;
 
 
        db="mat";
        tab="mat";
 
 
 
        table sub7=new table();
        sub7.credit=creditp;
        sub7.creditnumber=creditnumber;
        sub7.style=style;
        sub7.strlong=strlong;
        sub7.makedata(db,tab);
 
 
 
 
            int dicnumber,h,dicnumber2;
 
          String[] dic=new String[50000];
          String[] dic2=new String[50000];
        dicnumber=0;
    dicnumber2=0;
 
        int tr;
 
        for(tr=0;tr<20;tr++){    
 
     readfile sub79=new readfile();
    sub79.makedata(tr+".txt", "UTF-8");
    data=sub79.data;
    datanumber=sub79.datanumber;
 
    String str;
 
        for(s=1;s<datanumber+1;s++){
 
        catchword sub8=new catchword();
        v[s]=sub8.makedata(data[s],"value");
        bus[s]=sub8.makedata(data[s],"credit")+sub8.makedata(data[s],"subcredit")+sub8.makedata(data[s],"bus");
        credit[s]=sub8.makedata(data[s],"index");
        year[s]=sub8.makedata(data[s],"year");
        }
 
 
 
        for(s=1;s<datanumber+1;s++){
     h=0;
    for(sx=1;sx<dicnumber+1;sx++){
    if(bus[s].equals(dic[sx]))h=100;     
     }
    if(h<50)dicnumber=dicnumber+1;
    if(h<50)dic[dicnumber]=bus[s];
     }
 
 
 
    for(s=1;s<datanumber+1;s++){
    for(sx=1;sx<dicnumber+1;sx++){
    if(bus[s].equals(dic[sx]))code_go[s]="b"+sx;       
    }
    }
 
 
      for(s=1;s<datanumber+1;s++){
     h=0;
    for(sx=1;sx<dicnumber2+1;sx++){
    if(credit[s].equals(dic2[sx]))h=100;     
     }
    if(h<50)dicnumber2=dicnumber2+1;
    if(h<50)dic2[dicnumber2]=credit[s];
     }
 
 
 
    for(s=1;s<datanumber+1;s++){
    for(sx=1;sx<dicnumber2+1;sx++){
    if(credit[s].equals(dic2[sx]))code_come[s]="c"+sx;       
    }
    }
 
        for(s=1;s<datanumber+1;s++){
 
        datax[s][1]=""+year[s];
        datax[s][2]=""+code_go[s];
        datax[s][3]=""+code_come[s];
        datax[s][4]=""+v[s];
        }
 
 
 
 
        insert sub5=new insert();
        sub5.creditnumber=creditnumber;
        sub5.style=style;
        sub5.data=datax;
        sub5.datanumber=datanumber;
        sub5.makedata(db,tab);
 
 
 
 
    System.out.println(dicnumber);    
 
 
 
        }
 
 
 
    for(sx=1;sx<dicnumber+1;sx++){
    System.out.println("b"+sx+","+dic[sx]);  
     }
 
 
         for(sx=1;sx<dicnumber2+1;sx++){
    System.out.println("c"+sx+","+dic2[sx]);  
     }
 
 
    }
 
 
 
}