ffgoogle - プログラム倉庫

import java.sql.*;

class table{

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+"dbnumber integer,";
sqx=sqx+"name varchar(50),";
sqx=sqx+"code integer,";
sqx=sqx+"nyear integer,";
sqx=sqx+"month varchar(5),";
sqx=sqx+"day integer,";
sqx=sqx+"oprice double,";
sqx=sqx+"hprice double,";
sqx=sqx+"lprice double,";
sqx=sqx+"cprice double,";
sqx=sqx+"volume double)";

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

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

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


}