Statement statement = conn.createStatement();
// categories
ResultSet rs = statement.executeQuery ("SELECT * FROM categories");
while (rs.next()) {
CategoryEntity category = new CategoryEntity (
rs.getInt ("category_id")
);
allCategories.put (new Integer (category.categoryId), category);
}
// category_names
rs = statement.executeQuery ("SELECT * FROM category_names");
while (rs.next()) {
int categoryId = rs.getInt("category_id");
CategoryEntity category = (CategoryEntity)allCategories.get (new Integer (categoryId));
category.names.set (
rs.getString ("dest_language_code"),
new Name (
rs.getString ("category_name")
)
);
}
// category_members
rs = statement.executeQuery ("SELECT * FROM category_members");
while (rs.next()) {
int categoryId = rs.getInt("category_id");
CategoryEntity category = (CategoryEntity)allCategories.get (new Integer (categoryId));
category.members.set (
new Integer (rs.getInt ("category_sequence")),
new Member (
rs.getInt ("character_id")
)