A B D F I M Q R S

A

actionPerformed(ActionEvent) - Method in class InventoryController

send all getActionCommand strings to the model-server

actionPerformed(ActionEvent) - Method in class SelectController

send all getActionCommand strings to the model

B

Batch - Class in <Unnamed>

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...

Batch() - Constructor for class Batch

D

Database - Class in <Unnamed>

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

Database() - Constructor for class Database

F

FruitThreadServer - Class in <Unnamed>

Create a ServerSocket wait for someone to connect on port 56789 start up a client thread in threadGroup FruitClients and wait for request.

FruitThreadServerXML - Class in <Unnamed>

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.

I

init() - Method in class InventoryViewer

controller creates socket to FruitThreadServer

init() - Method in class SelectViewer

controller creates socket to FruitThreadServer

InventoryController - Class in <Unnamed>

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.

InventoryController(InventoryViewer, String) - Constructor for class InventoryController

Creates a socket connection to the intended Server url is the IP/URL address of the serverSocket

InventoryViewer - Class in <Unnamed>

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.

InventoryViewer() - Constructor for class InventoryViewer

M

main(String[]) - Static method in class Batch

main(String[]) - Static method in class Database

main(String[]) - Static method in class FruitThreadServer

Load database driver, create connection, create ServerSocket wait for client, when client connects start up thread using FruitThreadServer constructor

main(String[]) - Static method in class FruitThreadServerXML

main(String[]) - Static method in class Select

main(String[]) - Static method in class SelectClient

main(String[]) - Static method in class SelectServer

main(String[]) - Static method in class SelectThreadServer

Q

query(String) - Method in class InventoryController

Send query to FruitServer Query can be a data manipulation or select query it can actuall be any command of FruitThreadServer

queryVector(String) - Method in class InventoryController

Send query to FruitServer

R

run() - Method in class FruitThreadServer

Just connect to the IP/Port and then send requests Constructor creates socket and SQL statement, thread run creates server I/O for socket, and then waits for Client request

run() - Method in class FruitThreadServerXML

run() - Method in class SelectThreadServer

S

Select - Class in <Unnamed>

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;

Select() - Constructor for class Select

SelectClient - Class in <Unnamed>

setup a client socket connection to SelectSocket

SelectClient() - Constructor for class SelectClient

SelectController - Class in <Unnamed>

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

SelectController(SelectViewer) - Constructor for class SelectController

a future upgrade may send commands back and forth to the model using a socket

SelectServer - Class in <Unnamed>

SelectServer() - Constructor for class SelectServer

SelectThreadServer - Class in <Unnamed>

Create a ServerSocket wait for someone to connect when they do just except a query and send back the respoonse

SelectViewer - Class in <Unnamed>

Viewer portion of the Select MVC with FruitThreadServer JApplet is the Viewer

SelectViewer() - Constructor for class SelectViewer

setResponse(String) - Method in class InventoryViewer

setResponse(String) - Method in class SelectViewer

setResponseAppend(String) - Method in class InventoryViewer

setResponseAppend(String) - Method in class SelectViewer

A B D F I M Q R S