public static void main(String args[]) {
Connection conn = null;
Statement stmt = null;
try {
conn = getConnection();
stmt = conn.createStatement();
stmt.executeUpdate(USER_TABLE);
stmt.executeUpdate(PUBLICATION_TABLE);
stmt.executeUpdate(AUTHOR_TABLE);
stmt.executeUpdate(PUBLICATION_AUTHOR_TABLE);
stmt.executeUpdate(ARTICLE_TABLE);
stmt.executeUpdate(BOOK_TABLE);
stmt.executeUpdate(THESIS_TABLE);
stmt.executeUpdate(EDITOR_TABLE);
stmt.executeUpdate(EDITOR_PUBLICATION_TABLE);
stmt.executeUpdate(SCHOOL_TABLE);
stmt.executeUpdate(SCHOOL_THESIS_TABLE);
stmt.executeUpdate("insert into User(email, password) values('rootemail', 'rootpassword')");
// stmt.executeUpdate("insert into MyEmployees3(id, firstName) values(200, 'B')");
ReadXMLFile(stmt);
System.out.println("CreateEmployeeTableMySQL: main(): table created.");
} catch (ClassNotFoundException e) {
System.out.println("error: failed to load MySQL driver.");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("error: failed to create a connection object.");
e.printStackTrace();
} catch (Exception e) {
System.out.println("other error:");
e.printStackTrace();
} finally {
try {
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
