さくさくざいむ - 経済統計練習帳

package shipx;
 
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import tool.*;
 
public class pro {
 
 
String[] data=new String[5000];    
int s,datanumber;  
int number;
 
String[] memo=new String[5000];    
 
String[] dic=new String[5000];    
 
int dicnumber;
 
int trs;
int creditnumber;
String[] credit=new String[50];
String[] style=new String[50];
int[] strlong=new int[50];
String[][] datax=new String[50000][10];  
 
    public static void main(String[] args) {
       pro test=new pro();
    }
 
    pro(){
 
 
 creditnumber=7;
 credit[1]="year";
 credit[2]="season";
 credit[3]="page";
 credit[4]="bus";
 credit[5]="size";
 credit[6]="term";
 credit[7]="value";
 
 
 
 
        style[1]="INTEGER";
         style[2]="INTEGER";
 
         style[3]="VARCHAR";
         style[4]="VARCHAR";
          style[5]="VARCHAR";
           style[6]="VARCHAR";
 
           style[7]="VARCHAR";
 
     strlong[5]=5;
      strlong[4]=5;
     strlong[7]=50;
 strlong[6]=5;
 strlong[3]=5;
 
 
        String db,tab;
 
        db="mof";
        tab="mof";
 
         table sub=new table();
        sub.credit=credit;
        sub.creditnumber=creditnumber;
        sub.style=style;
        sub.strlong=strlong;
        sub.makedata(db,tab);
 
 
 
 
 
        dic d2=new dic();
        d2.makedata();
        dicnumber=d2.dicnumber;
        dic=d2.dic;
 
        for(s=1;s<dicnumber+1;s++){
        System.out.println(s+","+dic[s]);  
        }
 
 
 
            File f=new File("gdata");
 
        String[] fx=f.list();
 
        number=fx.length;
 
        System.out.println(number);
 
        int sx,t;
        t=0;
 
 
 
 
 
        for(s=0;s<number;s++){
 
            System.out.println(s);
 
 
            readfile sub3=new readfile();
  sub3.makedata("gdata/"+fx[s],"UTF-8");
  data=sub3.data;
  datanumber=sub3.datanumber; 
 
  String str,y1,m1;
  String c1,c2,c3;
  int h,dx,pp;
  for(sx=1;sx<datanumber+1;sx++){
 
 
   datax[sx][1]=fx[s].substring(0,2);
   datax[sx][2]=fx[s].substring(3,4);
 
   String strx=fx[s].substring(4,6);
 
 
 
    int n5=Integer.parseInt("7"+strx)-700;
 
 
 datax[sx][3]="c"+n5;
 
  catchword sub2=new catchword(); 
 c1=sub2.makedata(data[sx],"term");
 c2=sub2.makedata(data[sx],"size");
 c3=sub2.makedata(data[sx],"bus");
 
 String sizex;
 
 sizex="all";
 if(c2.indexOf("大企業")>-1)sizex="big";
 if(c2.indexOf("中堅")>-1)sizex="mid";
 if(c2.indexOf("中小")>-1)sizex="small";
 
 datax[sx][5]=sizex;
 
  sizex="t2";
 if(c1.indexOf("前期")>-1)sizex="t1";
 if(c1.indexOf("当期")>-1)sizex="t2";;
 if(c1.indexOf("翌期")>-1)sizex="t3";;
 if(c1.indexOf("翌々期")>-1)sizex="t4";
 
 datax[sx][6]=sizex;
 
 
 datax[sx][4]="b0";
 
 c3=c3.replace("・","");
 c3=c3.replace("、","");
 c3=c3.replace("※２","");
 c3=c3.replace("※３","");
 c3=c3.replace("※４","");
 if(c3.indexOf("繊維")>-1)c3="繊維";
 if(c3.indexOf("非鉄金属")>-1)c3="非鉄金属";
 if(c3.indexOf("鉱業")>-1)c3="鉱業";
 if(c3.indexOf("繊維")>-1)c3="繊維";
 h=0; 
 if(c3.indexOf("その")>-1)h=h+1;
 if(c3.indexOf("製造")>-1)h=h+1;
 if(h==2)c3="その他の製造業";
 
for(dx=1;dx<dicnumber+1;dx++){
if(c3.equals(dic[dx]))datax[sx][4]="b"+dx;   
}
 
 
 datax[sx][7]=sub2.makedata(data[sx],"value"); 
 
 
 
 
  }
 
 
        insert sub21=new insert();
        sub21.creditnumber=creditnumber;
        sub21.style=style;
        sub21.data=datax;
        sub21.datanumber=datanumber;
        sub21.makedata(db,tab);
 
 
 
 
 
 
 
        }
 
 
        writedic("dic.txt");
 
    }
 
         void writedic(String file){ 
 
    int s,sx;
 
try{ 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file))); 
 
for(s=1;s<dicnumber+1;s++){   
pw.println("b"+s+","+dic[s]);
}
 
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
 
 
 
 
 
 
 
    }
 
 
 
 
 
package shipx;
 
 
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import tool.*;
 
public class dic {
 
 
String[] data=new String[5000];    
int s,datanumber;  
int number;
 
String[] dic=new String[5000];    
 
int dicnumber;
 
 
    void makedata(){
 
 
            File f=new File("gdata");
 
        String[] fx=f.list();
 
        number=fx.length;
 
        System.out.println(number);
 
        int sx,t;
        t=0;
        dic[0]="";
 
  dicnumber=0;      
 
        for(s=0;s<number;s++){
 
            readfile sub3=new readfile();
  sub3.makedata("gdata/"+fx[s],"UTF-8");
  data=sub3.data;
  datanumber=sub3.datanumber; 
 
  String str,y1,m1;
  String c1,c2,c3;
  int h;
 
  for(sx=1;sx<datanumber+1;sx++){
 catchword sub2=new catchword();
 c3=sub2.makedata(data[sx],"bus");
 c3=c3.replace("・","");
 c3=c3.replace("、","");
 c3=c3.replace("※２","");
 c3=c3.replace("※３","");
 c3=c3.replace("※４","");
 if(c3.indexOf("繊維")>-1)c3="繊維";
 if(c3.indexOf("非鉄金属")>-1)c3="非鉄金属";
 if(c3.indexOf("鉱業")>-1)c3="鉱業";
 if(c3.indexOf("繊維")>-1)c3="繊維";
 h=0; 
 if(c3.indexOf("その")>-1)h=h+1;
 if(c3.indexOf("製造")>-1)h=h+1;
 if(h==2)c3="その他の製造業";
 
 int dx;
 h=0;
 for(dx=0;dx<dicnumber+1;dx++){
 if(c3.equals(dic[dx]))h=100;
 } 
 if(c3.indexOf("null")>-1)h=200;
 if(h<50) dicnumber=dicnumber+1;
 if(h<50) dic[dicnumber]=c3;
  }
 
  }
 
 
 
        }
 
 
 
    }