Using the MySQL "classroom" database that we have previously used in assignments, construct a simple Java console based (command-line) frontend similar to that used in Blackboard. The frontend will use JDBC for the database connection and should have the following properties:
- Users should be initially presented with a list of available classes.
- After selecting a class (through the command line -> typing a class identifier/name), a list of all enrolled students, assignments and assignment grades should be displayed in a tabular form (use white space, | and _ characters to display in the command line like a table).
- Each assignment should have a class average calculated for it (don't forget to exclude the students who have not submitted that assignment).
- Users should be able to select a student (through the command line -> typing a class identifier/name) and view a list of all courses he or she is enrolled in.
- This new class list should function the same way as the original class list.
- There should be an option at any time to return to the full list of classes or to exit.
- Users should not be able to change anything.
- It is fine if the lists scroll off the top of the page.
- Selections can be done by prompting for class/student name or using a numbering system (i.e. "Please choose class 1-15").
Grading (out of 10 points):
5 pts. - SQL queries function correctly.
3 pts. - The interface functions correctly.
2 pt. - The Java code is properly commented and submitted.
Submission:
Turn in a zipped/rar'd archive of your source code and the JDBC driver jar file you used in Blackboard. Make sure you also include the command line you used to execute the program.
Java Programming References:
http://java.sun.com/javase/technologies/database/index.jsp