Java Reference
In-Depth Information
STATIC STRING[] SQLALTER = {
"ALTER TABLE CONTACT_INFO ADD PHONE VARCHAR(16);",
"ALTER TABLE CONTACT_INFO ADD EMAIL VARCHAR(50);",
};
PUBLIC TABLEMODIFIER(){
REGISTERDRIVER();
}
PUBLIC VOID REGISTERDRIVER(){
TRY {
CLASS.FORNAME(JDBCDRIVER);
DRIVERMANAGER.REGISTERDRIVER(NEW JDBCODBCDRIVER());
}
CATCH(CLASSNOTFOUNDEXCEPTION E){
SYSTEM.ERR.PRINT(E.GETMESSAGE());
}
CATCH(SQLEXCEPTION E){
SYSTEM.ERR.PRINTLN(E.GETMESSAGE());
}
}
PUBLIC VOID EXECUTE(STRING[] SQLCOMMAND){
TRY {
CONNECTION CON = DRIVERMANAGER.GETCONNECTION(URL);
STATEMENT STMT = CON.CREATESTATEMENT();
FOR(INT I=0;I<SQLCOMMAND.LENGTH;I++){
STMT.EXECUTE(SQLCOMMAND[I]);
}
CON.CLOSE();
}
CATCH(SQLEXCEPTION E){
SYSTEM.ERR.PRINTLN(E.GETMESSAGE());
}
}
PUBLIC STATIC VOID MAIN(STRING[] ARGS) {
TABLEMODIFIER TABLEMODIFIER = NEW TABLEMODIFIER();
Search WWH ::




Custom Search