CS4B Spring 2007

Package <Unnamed>

Class Summary
Batch Just open up a connection to the fruit database using localhost send it three data manipulatin statements using addBatch and then executeBatch - executeBatch returns results rows modified Uses the basic java.sql.Statements...
Database Just open up a connection to the fruit database using localhost and send select query to list the contents of the fruit table all students in class have their own database they should not be using this one
FruitThreadServer Create a ServerSocket wait for someone to connect on port 56789 start up a client thread in threadGroup FruitClients and wait for request.
FruitThreadServerXML Same version as FruitThreadServer but adds the client request XML, XML is a toggle once set, it wraps all query data with XML tags representing the column names.
InventoryController The controller portion of the MVC the controller listens for input and drives the model and viewer Used to add data to inventory and also to monitor the current inventory.
InventoryViewer Viewer portion of the Select MVC with FruitThreadServer JApplet is the Viewer, has three buttons that are handled by InventoryController, InventoryController creates sockets and I/O streams.
Select Just open up a connection to the fruit database Accept a query from the keyboard output the response to standard output Queries can be select, describe table or show tables;
SelectClient setup a client socket connection to SelectSocket
SelectController The controller portion of the MVC the controller listens for input and drives the model and viewer constructor opens up a socket connection to FruitThreadServer current system has three buttons that send three different queries to Server
SelectServer  
SelectThreadServer Create a ServerSocket wait for someone to connect when they do just except a query and send back the respoonse
SelectViewer Viewer portion of the Select MVC with FruitThreadServer JApplet is the Viewer
 


CS4B Spring 2007