ｐりまｒｙけｔｙ - プログラム倉庫

import java.sql.*;

class table2{

int tsecode,tyear,tmonth,tday;
int oprice,hprice,lprice,cprice,volume,rprice;

void makedata(String str){

String url = "jdbc:derby:db;create=true";  
String usr = "";  
String pwd = "";

Connection dbx;  
Statement stx;  
String sqx;

sqx="create table ";
sqx=sqx+str;
sqx=sqx+" (";    
sqx=sqx+"tsecode Integer NOT NULL,";  
sqx=sqx+"tyear Integer NOT NULL,";  
sqx=sqx+"tmonth Integer NOT NULL,";  
sqx=sqx+"tday Integer NOT NULL,";
sqx=sqx+"oprice Integer,";  
sqx=sqx+"hprice Integer,";  
sqx=sqx+"lprice Integer,";  
sqx=sqx+"cprice Integer,";  
sqx=sqx+"volume Integer,";  
sqx=sqx+"rprice Integer,";    
sqx=sqx+"primary key(tsecode,tyear,tmonth,tday))";

try {  
dbx = DriverManager.getConnection(url, usr, pwd);
stx = dbx.createStatement();  
stx.executeUpdate(sqx);

stx.close();
dbx.close();

}
catch (Exception ex) { ex.printStackTrace();}
}


}