Creating a Table withJDBC and SQL - Java Database Programming Bible - page 171

"CONTACT_ID INTEGER NOT NULL PRIMARY KEY,"+
"FIRST_NAME VARCHAR(20) NOT NULL,"+
"MI CHAR(1) NULL,"+
"LAST_NAME VARCHAR(30) NOT NULL,"+
"STREET VARCHAR(50) NOT NULL,"+
"CITY VARCHAR(30) NOT NULL,"+
"STATE CHAR(2) NOT NULL,"+
"ZIP VARCHAR(10) NOT NULL"+
");";
public TableMaker(){
registerDriver();
}
public void setDatabaseName(String dbName){
this.dbName=dbName;
}
public void registerDriver(){
try {
Class.forName(jdbcDriver);
}
catch(ClassNotFoundException e){
System.err.print(e.getMessage());
}
catch(SQLException e){
System.err.println(e.getMessage());
}
}
public void execute(String SQLCommand){
url += dbName;
Connection con;
Statement stmt;
try {
con = DriverManager.getConnection(url);