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 |