修正テーブル - プログラム倉庫

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+"articlecode Integer GENERATED BY DEFAULT AS IDENTITY,";  
sqx=sqx+"tsecode Integer,";
sqx=sqx+"zyear  Integer,";
sqx=sqx+"zmonth  Integer,";
sqx=sqx+"zday  Integer,";
sqx=sqx+"title varchar(300),";
sqx=sqx+"source varchar(300),";
sqx=sqx+"link varchar(300),";
sqx=sqx+"content long varchar,";
sqx=sqx+"primary key(tsecode,link))";  

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

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

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

}


}