Fall 2011

Lab06
Database Q and A

Due: Thursday December 09, 2010 11:58 PM

Lab06 - Database Q and A

Requirements

Comments placed in the source code file5 pts
Application placed in an executable JAR file5 pts
Questions can be viewed, edited, added, and deleted through a JTable20 pts
Answers can be viewed, edited, added, and deleted through a JTable20 pts
User, Questions, and Answers are stored in a DataBase30 pts
The relative popularity of Questions and Answers can be changed in a meaningful way20 pts
Total100 pts

Resources

Objective

To practice using Databases from Java

Instructions

For this lab you will need to take whatever steps are necessary to reproduce the functionality of Lab02 (Question and Answer Tables) except for this version of the program all of the data for the program should be provided by a MySQL database. See the attached text file for the SQL statements needed for this program.