p082210 - 経済統計練習帳

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=6;
 credit[1]="year";
 credit[2]="month";
        credit[3]="bus";
        credit[4]="work";
        credit[5]="di";
        credit[6]="value";
 
 
        style[1]="INTEGER";
         style[2]="INTEGER";
        style[3]="VARCHAR";
         style[4]="VARCHAR";
          style[5]="VARCHAR";
         style[6]="VARCHAR";
 
            strlong[3]=5;
        strlong[4]=5;
   strlong[5]=5;
           strlong[6]=10;
 
        String db,tab;
 
        db="rou";
        tab="rou";
 
         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("b"+s+","+dic[s]);  
        }
 
 
 
 
  readfile sub3=new readfile();
  sub3.makedata("data.txt","UTF-8");
  data=sub3.data;
  datanumber=sub3.datanumber; 
 
  String str,y1,m1;
  String c1,c2,c3;
  int h,dx,pp,sx;
  for(sx=1;sx<datanumber+1;sx++){
 
 
 
 
 
  catchword sub2=new catchword();
 datax[sx][1]=sub2.makedata(data[sx],"year");
datax[sx][2]=sub2.makedata(data[sx],"month");
 
pp=1; 
 c1=sub2.makedata(data[sx],"subcredit");
 if(c1.indexOf("不足")>-1)pp=1;
 if(c1.indexOf("過剰")>-1)pp=2;
 if(c1.indexOf("DI")>-1)pp=3;
 datax[sx][5]="d"+pp;
 
 
 
 c2=sub2.makedata(data[sx],"credit");
  pp=1;
 if(c2.indexOf("全労働者")>-1)pp=1;
 if(c2.indexOf("常用")>-1)pp=2;
 if(c2.indexOf("臨時・季節")>-1)pp=3;
 if(c2.indexOf("パートタイム")>-1)pp=4;
 if(c2.indexOf("全派遣労働者")>-1)pp=5;
 datax[sx][4]="w"+pp;
 
  c3=sub2.makedata(data[sx],"bus");
 
 datax[sx][3]="b0";
 
 for(dx=1;dx<dicnumber+1;dx++){
 if(c3.equals(dic[dx]))datax[sx][3]="b"+dx;   
}
 
 
 datax[sx][6]=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(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(){
 
 
 
 
        int sx,t;
        t=0;
        dic[0]="";
 
  dicnumber=0;      
 
 
 
            readfile sub3=new readfile();
  sub3.makedata("data.txt","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");
 
 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;
  }
 
  }
 
 
 
 
 
 
 
    }