アットウィキロゴ

あdfれj

import java.sql.*;

class attable{

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+"num integer,";
sqx=sqx+"atname varchar(30),";
sqx=sqx+"atcode integer,";  
sqx=sqx+"title varchar(200),";  
sqx=sqx+"name varchar(100),";  
sqx=sqx+"alyear integer,";  
sqx=sqx+"almonth integer,";  
sqx=sqx+"alday integer,";  
sqx=sqx+"content long varchar)";

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

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

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


}
最終更新:2011年04月01日 16:50