アットウィキロゴ

jjjl;;;

import java.sql.*;

class ytable{

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+"name varchar(50),";
sqx=sqx+"ccode integer,";
sqx=sqx+"nyear integer,";
sqx=sqx+"month varchar(10),";
sqx=sqx+"day integer,";
sqx=sqx+"title varchar(200),";
sqx=sqx+"des varchar(1000),";
sqx=sqx+"link varchar(500))";

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

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

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


}
最終更新:2011年03月30日 20:02