<%@ page import="apz.db.*" %> <% try { dbUser[] userArray = db.getUsers(); dbItem[] itemArray = db.getItems(); dbThread[] threadArray = db.getThreads(); out.println(""); out.println(""); out.println(""); out.println(""); for(int i=0; i"); dbUser.Attribute[] attributeArray = userArray[i].getValues(); dbUser.Order[] orderArray = userArray[i].getOrders(); dbUser.Message[] messageArray = userArray[i].getMessages(); for(int j=0; j"); for(int j=0; j"); for(int j=0; j"); } out.println("

dbUser	Number of users: " + userArray.length + "
Primary Key	" + userArray[i].getUserName() + "
" + attributeArray[j].getName() + "	" + attributeArray[j].getValue().toString() + "
Order	ID: " + orderArray[j].getID() + " Item ID:" + orderArray[j].getItemID() + " Quantity: " + orderArray[j].getQuantity() + " Status: " + orderArray[j].getOrderStatus() + "
Message	ID: " + messageArray[j].getID() + " Sender: " + messageArray[j].getSender() + " Title: " + messageArray[j].getTitle() + " Date Sent: " + messageArray[j].getDateSent() + " Message: " + messageArray[j].getMessage() + "

"); out.println("

---

"); out.println(""); out.println(""); for(int i=0; i"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); } out.println("

dbItem	Number of items: " + itemArray.length + "
Item ID	" + itemArray[i].getItemID() + "
Name	" + itemArray[i].getItemName() + "
Description	" + itemArray[i].getDescription() + "
Price	£" + (itemArray[i].getPrice()) + "
Number in Stock	" + itemArray[i].getNumInStock() + "
Image Path	" + itemArray[i].getImagePath() + "

"); out.println("

---

"); out.println(""); out.println(""); for(int i=0; i"); out.write(""); out.write(""); out.write(""); out.write(""); out.write(""); for(int j=0; j"); } out.println("

dbThread	Number of threads: " + threadArray.length + "
Thread ID	" + threadArray[i].getID() + "
Title	" + threadArray[i].getTitle() + "
Author	" + threadArray[i].getAuthor() + "
Date Started	" + threadArray[i].getDateStarted() + "
Status	" + threadArray[i].getFlags() + "
Last Post	" + threadArray[i].getLastPost() + "
Post	ID: " + postArray[j].getID() + " Author: " + postArray[j].getAuthor() + " Date Posted: " + postArray[j].getDatePosted() + " Message: " + postArray[j].getMessage() + "

"); out.println(""); out.println(""); } catch(Exception e) { out.println(e.getMessage()); } %>