みやこ - 経済統計練習帳

package select;
 
 
public class pro {
 
 
 
    int[] month=new int[20000];
    String[] code=new String[20000];
    String[] name=new String[20000];
    String[] credit=new String[20000];
    int number;
 
     String[][] codex=new String[31][700];
     String[][] namex=new String[31][700];
     int[] numberx=new int[20];
 
      String[] dic_code=new String[2000];
      String[] dic_name=new String[2000];
      int dicnumber;
        int[][] point=new int[2000][31];
        int[] v=new int[2000];
 
    public static void main(String[] args) {
        pro t=new pro();
    }
    pro(){
 
 
           String db,tab;
 
 
        db="talk";
        tab="talk";
 
        dicnumber=0;
 
         int tr=1;
 
          String[] dbx=new String[21];
 
          dbx[1]="tamo";
            dbx[2]="tetu";
            dbx[3]="ton";
            dbx[4]="sanma";
            dbx[5]="smap";
         dbx[6]="sawako";
            dbx[7]="os";
            dbx[8]="asa";
            dbx[9]="a";
            dbx[10]="dare";
         dbx[11]="dt";
           dbx[12]="s7";
 
        for(tr=1;tr<13;tr++){ 
 
 
       select sub3=new select();
       sub3.makedata(db, tab,dbx[tr],2015);
     number=sub3.number;
        code=sub3.code;
         name=sub3.name;
 
        int s;
      for(s=1;s<number+1;s++){
      namex[tr][s]=name[s];    
      codex[tr][s]=code[s];
      }
      numberx[tr]=number;  
 
 
 
      int sx;
      dic_code[0]="";
      for(s=1;s<numberx[tr]+1;s++){
       int h=0;   
       int sxs=0;
      for(sx=0;sx<dicnumber+1;sx++){
      if(codex[tr][s].equals(dic_code[sx]))h=100;    
       if(codex[tr][s].equals(dic_code[sx]))sxs=sx; 
      }   
      if(h<50)dicnumber=dicnumber+1;
      if(h<50)dic_code[dicnumber]=codex[tr][s];
      if(h<50)dic_name[dicnumber]=namex[tr][s];
      if(h>50)point[sxs][tr]=100;
      if(h<50)point[dicnumber][tr]=100;
      }
      }
 
 
       int s;
       for(s=1;s<dicnumber+1;s++){
     int h=0;
           if(point[s][1]>50)h=h+1;
        if(point[s][2]>50)h=h+1;
           if(point[s][3]>50)h=h+1;
           if(point[s][4]>50)h=h+1;
           if(point[s][5]>50)h=h+1;
              if(point[s][6]>50)h=h+1;
        if(point[s][7]>50)h=h+1;
           if(point[s][8]>50)h=h+1;
           if(point[s][9]>50)h=h+1;
           if(point[s][10]>50)h=h+1;
            if(point[s][11]>50)h=h+1;
              if(point[s][12]>50)h=h+1;
            v[s]=h;
      if(v[s]>2)System.out.println(dic_name[s]+","+v[s]);
      }    
 
 
 
 
 
 
    }
 
 
 
 
}
 
 
 
 
package select;
 
import java.sql.*; 
 
class select{ 
 
Connection dbx;   
Statement stx;   
String sqx; 
ResultSet  rsx; 
 
int key; 
String word;
int sx,number;
String[] data=new String[20000];
    int[] year=new int[20000];
    int[] month=new int[20000];
    String[] code=new String[20000];
    String[] name=new String[20000];
    String[] credit=new String[20000];
 
void makedata(String db,String tab,String cr,int yy ){ 
 
String url = "jdbc:h2:"+db+";create=true";   
String usr = "";   
String pwd = ""; 
 
 
 try
          {
            Class.forName("org.h2.Driver");
 
dbx = DriverManager.getConnection(url, usr, pwd); 
} catch (Exception ex) { ex.printStackTrace();} 
 
sx=0;
try {   
stx = dbx.createStatement(); 
sqx="select * from "+tab;    
sqx=sqx+" where year="+yy+" and credit="+change(cr);    
rsx = stx.executeQuery(sqx); 
if (rsx != null) { 
while (rsx.next()) { 
sx=sx+1;
code[sx]= rsx.getString("code");
name[sx]= rsx.getString("name");
} 
} 
 
number=sx;
 
 
rsx.close(); 
stx.close(); 
dbx.close(); 
 
} catch (Exception ex) {ex.printStackTrace();} 
 
 
 
 
} 
 
String change(String word){
String e;
e="'"+word+"'";
return e;    
}    
 
 
 
}