The Tournament Manager revisited
For this exam problem we will be rewriting the tournament manager application to use a database.
The user interface of the application is unchanged from the previous version. Once again, there are tabs for registering players, displaying matches that have not been completed, and showing a leaderboard.
What you need to do
Start by clicking the "Starter Project" button above to download the project folder for the project.
Inside that project folder you will find a "database" folder containing files for the database. In the MySQL workbench make a new empty schema with the name "tournament" and then use the data import feature to import the database files from the database folder. The database I provided also contains some test data for the application. With the database installed you can start up the application and see that matches and the leaderboard are both displayed.
The FXML portion of the project is complete - you will not need to make any changes to the user interface.
I have removed a couple of methods and some of the member variables from the DAO class. I have also removed some of the code from each of the three action methods in the controller class. Your job is to put the missing code back in.
Here is what the action methods need to do:
- The
register()method needs to insert a new player into the database along with matches between that player and each one of the other players. - The other two action methods need to record the winner for a particular match. To do this you will update the entry in the matches table to record the winner and also update the played and wins fields for both of the players involved in the match.
To support these two operations you will need to put a couple of methods in the DAO class, along with whatever member variables those methods need to do their job. Make sure you also add code to initialize those member variables to the DAO class constructor.