みずｈｈｈ - 経済統計練習帳

package w1;
 
import java.io.*;
 
public class pro {
 
     int maxx=150;
        int maxy=2300;
    String[][] mat=new String[2400][300]; 
    int fastline;    
    int lastline;    
     String[] city=new String[2500];
    String[] code_city=new String[2500];
     String[] credit=new String[300];
int creditx,credity;
 String[] code=new String[300];
    String[] year=new String[300];
    public static void main(String[] args) {
        pro te=new pro();
    }
 
    pro(){
 
 
        int de;
 
        for(de=2007;de<2017;de++){
        String a=""+de;
 
        File f=new File(a);
        String[] ff=f.list();
 
        int tr;
 
        for(tr=0;tr<ff.length;tr++){
 
         readxls sub2=new readxls();
    sub2.maxx=maxx;
    sub2.maxy=maxy;
    sub2.makedata(a+"/"+ff[tr],0);
    mat=sub2.mat;
 
    writehtml("ren.html");
 
    int prefline=0;
 
    int s,sx;
for(s=1;s<21;s++){
for(sx=1;sx<21;sx++){
int h=0;
if(mat[s][sx].indexOf("北")>-1)h=h+1;
if(mat[s][sx].indexOf("海")>-1)h=h+1;
if(h==2)prefline=sx;
if(h==2)fastline=s;
}
}
 
for(s=fastline;s<maxy;s++){
int h=0;
if(mat[s][prefline].length()>1)lastline=s;
}
 
System.out.println("z1=>"+fastline);
System.out.println("z2=>"+lastline);
 
for(s=fastline;s<lastline+1;s++){
city[s]=mat[s][prefline];
code_city[s]=mat[s][prefline-1];
 
}
 
int creditline=0;
 
 
for(s=1;s<fastline;s++){
int h=0;
if(mat[s][prefline-1].indexOf("市")>-1)h=h+1;
if(mat[s][prefline-1].indexOf("区")>-1)h=h+1;
if(h==2)creditline=s;   
}        
 
System.out.println("z3=>"+creditline);
 
int delta=0;
creditx=3;
for(s=1;s<fastline;s++){
int h=0;
if(mat[s][creditx].indexOf("(")>-1)h=h+1;
if(mat[s][creditx].indexOf("(")>-1)h=h+1;
if(h==2)delta=s;   
}     
 
 
System.out.println("z4=>"+delta);
 
 
 
 
System.out.println(creditline);  
System.out.println(creditx);  
 
for(sx=creditx;sx<maxx;sx++){
if(mat[creditline][sx].length()>1)credity=sx;
}        
 
System.out.println("z5=>"+credity);  
 
for(sx=creditx;sx<credity+1;sx++){
credit[sx]=mat[creditline][sx].replace("\n","");
code[sx]=mat[creditline+1][sx]+mat[creditline+2][sx];
year[sx]=mat[delta+1][sx];  
System.out.println(credit[sx]);  
}       
 
writexml("gdata/"+a+"/"+ff[tr]+".txt");
        }
    }
 
    }
 
 void writexml(String file){ 
 
    int s,sx;
 
try{ 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file))); 
 
for(s=fastline;s<lastline+1;s++){  
if(city[s].length()>1){
for(sx=creditx;sx<credity+1;sx++){ 
if(credit[sx].length()>1){
pw.print("<city>");
pw.print(city[s]);
pw.print("</city>");
pw.print("<code_city>");
pw.print(code_city[s]);
pw.print("</code_city>");
pw.print("<year>");
pw.print(year[sx]);
pw.print("</year>"); 
pw.print("<credit>");
pw.print(credit[sx]);
pw.print("</credit>"); 
pw.print("<code>");
pw.print(code[sx]);
pw.print("</code>"); 
pw.print("<value>");
pw.print(mat[s][sx]);
pw.println("</value>"); 
}
}
}
}
 
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
 
 
    void writehtml(String file){ 
 
    int s,sx;
 
try{ 
PrintWriter pw = new PrintWriter (new BufferedWriter(new FileWriter(file))); 
 
 
pw.println("<html>");
 
pw.println("<head>");
pw.println("<meta charset=\"UTF-8\">");
pw.println("</head>");
pw.println("<body>");
pw.print("<table rules=\"all\">"); 
pw.print("<tr>"); 
pw.print("<td>"); 
pw.print(""); 
pw.print("</td>"); 
for(sx=1;sx<maxx+1;sx++){ 
pw.print("<th>"); 
pw.print(sx); 
pw.print("</th>"); 
} 
pw.println("</tr>"); 
for(s=1;s<maxy+1;s++){ 
pw.print("<tr>"); 
pw.print("<th>"); 
pw.print(s); 
pw.print("</th>"); 
for(sx=1;sx<maxx+1;sx++){ 
pw.print("<td>"); 
pw.print(mat[s][sx]); 
pw.print("</td>"); 
} 
pw.println("</tr>"); 
}   
pw.println("</table>"); 
pw.println("</body>");
pw.println("</html>");
 
System.out.println("ファイルに書きこみました。"); 
pw.close(); 
} catch(IOException ep){ System.out.println("入出力エラーです。"); } 
 
 
} 
 
 
 
}