sql - 経済統計練習帳

package table;
 
 
import java.sql.*; 
 
class showtable{ 
 
Connection dbx;   
Statement stx;   
String sqx; 
ResultSet  rsx; 
 
int key; 
String word;
int sx,number;
int[] year=new int[50000];
int[] month=new int[50000];
String[] v=new String[50000];
 
void makedata(String db){ 
 
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="SHOW TABLES";   
DatabaseMetaData md = dbx.getMetaData();
String table[]={"TABLE"}; 
 
rsx=md.getTables(null,null,null,table);  
 
String tn="";
 
while(rsx.next()){  
tn=rsx.getString(3);  
} 
 
 
 
 ResultSet pp = md.getColumns(null,null,tn,null);
        while(pp.next()) {
      System.out.print("クレジット=>"+pp.getString("COLUMN_NAME"));
        System.out.print("○");
      System.out.println("性質=>"+pp.getString("TYPE_NAME"));
        }
        pp.close(); 
 
 
rsx.close(); 
stx.close(); 
dbx.close(); 
 
} catch (Exception ex) {ex.printStackTrace();} 
 
 
 
 
} 
 
 
}