Description of Program

This applet is for the on-line sign up system of Drummlin Tennis Club. To avoid the conflict of players practicing time,
Every one who want to use these court should sign up through the internet.

For this, several function are required for.
1. "SHOW"  : show all the time schedule which are already signed up
2. "CHECK" : check his/her own time table or someone else's
3. "SIGN" : sign up for use of court
4. "CANCEL" : cancel the reservation

In addition to this, there are two more function to communicate with database.
5. "CONNECT" : connect to oracle server
6. "CLOSE" : close connection to oracle server

To implemenet this applet, JDBC 2-tier model is used.
User do input the information through GUI (Applet) and this action is invoke database (JDBC) file to send the SQL query to oracle server.
database file-courtDB gets the result from database and display them on Display Area.
General error is captured inside program and program let user notice it by showing message. And SQLException and other Exceptions are also
displayed.
 

Descrpition of the Algorithm and Overview of the Program
 

    Link To Program Flow Diagram   :  pflow.gif
 

Database

There are two table for this program.
Each table represents 'courtA' and 'courtB' respectively.
 

Field	atable	btable
	- NAME	- NAME
	- DATE	- DATE
	- TIME	- TIME

To create and to load database into oracle, each of table need script file (.sql) and control file (.ctl)
They are 'acreate.sql', 'bcreate.sql', 'atable.ctl' and 'btable.ctl'.
 

Java Program
 

• myApplet.java

public class myApplet extends Applet
             implements ActionListener, ItemListene

public void init()
public void actionPerformed(ActionEvent event)
public void itemStateChanged(ItemEvent event)
public void show_msg(String s)
 

• courtDB.java

class courtDB

public void open(StringBuffer msg)
public void show(myApplet my)
public void search(myApplet my)
public void insert(String n_name, String n_day, String n_time, String wh_side, StringBuffer msg) {
public void delete(myApplet my)
public void close()
 

Reference

• JDK Package index
• Java in a Nutshell (2nd Edition)          by David Flanagan
• Java in a Nutshell : Example        by david Flanagan
• Java: How to Program 2nd Editio        by Deitel & Deitel
• Core Java 1.1 Advanced Features     Cay Horstmann and Gray Cornell