ReadMe

			Database Lab- Fly Tunes Music Store	

1. Description: 

In this database lab, I have constructed database for a Music Store. The user can search for the 

In this lab, I have maintained database for a Music Store. The user can search for music albums and give feedback using this lab

We have Connection with the database,selecting and displaying information from the database insertion in the database tables, drop the tables and remove the connection

2. How to Run this Database Lab:

First we have to see that all the drivers have been installed properly in the machine. Next we have to set the CLASSPATH.

Install Xming and also run Xming in the background. We need Xming so that we can display our GUI in that machine.

Download the file FlyTunesDatabase.jar from www.ecst.csuchico.edu/~aiyer/Lab4/511.html and run it. No need for command prompt or any parameters

Java Files  1. DatabaseManager.java : Handles the connection to the database, creation of the initial database tables

	     2. PasswordDailog.java : This java file takes the user id and password and passes it to the database manager for authentication

	     3. FlyTunesStore.java : Contains the main method that launches the FlyTunes GUI
		
	     4. FlyTunesFrame.java : Has the GUI for the Fly Tunes Lab
	
	     5. ListingsTableModel.java : This java file is used to produce the results in the form of a table for the user to access

	     6. AddCommentDialog. java : GUI for the page that allows the user to submit comments to the database
	
	     7. AddCommentListener.java : Is a custom listener that listens to the click event and launches the window for adding feedback

3. How to work with the GUI.

Once you have the GUI that means you are now connected with the database.

There are two text fields for the user to eneter into. First is the Album Name field and the second one is the Band/Artist Name .
Enter an album name and/or band/artist name in the respective fields and get the result. The results are displayed in the form of the table
above the text fields. If multiple matches are found in the database for the fields enetered then multiple rows will be displayed in the table.
If no matching results are found then an error will be given to the user "No records were found".

Some of the possible searches which should work (You don't have to worry about case sensitivity)

1. Dark side of the moon in album name
2. Greatest hits in the album field for multiple results
3. Michael jackson in the band/artist name field for multiple results displayed
4. Pink Floyd in band/artist name for appropriate result.

Since this is an idea of a music store it does not make sense to allow the user to add results to the database. Hence I have no provision for the user 
to add albums. Since the lab requires some kind of insertion into the database I have added the feedback functionality which allows the user to submit feedback
which is stored inside a seperate table in the database called "comment".

When the user closes the window for the main Fly Tunes GUI , the flytunes and the comment tables are dropped and connection to the database is terminated.

4. Complexity:

Lot of complexity lies in the GUI part and management of the database.

Problem Encountered : None really :)

5. References:

Studied O'Reilly Class notes and developed the connection with the database using the examples and my own client server lab.