Basketball Database is a Java Swing GUI (Graphical User Interface) application. This program is for all intents and purposes a database management system (DBMS), which allows for quick and easy entry, editing, and management of records. In addition, it allows the user to see existing entries in the database as well. In a nutshell, it allows for keeping track of players and teams in the NBA.
Basketball Database consists of the following features:
Basketball Database was made for the Computer Science and Information Systems course 2410 (Advanced Programming) at Salt Lake Community College. It was made for the assignment titled "A02 Database Application", where the purpose was to show we could write a Java GUI application that can modify a connected database using the JDBC API. It practices use of separation of functionality and display (output), clear GUI design, and reaction to user-input. In addition, data validation is used to ensure correct formats are entered when data is added or updated.
For this particular project, we use Apache Derby as the underlying SQL database, which is a self-contained SQL database. This means that no external database is needed to allow it to work.
Although this project in particular is not exactly super useful due to it being designed for such a specific purpose, the concepts applied could quickly be adapted into a more general-purpose DBMS. It's also a cool tool to be able to see the possibilites of the JDBC API.
Basketball Database is an application that uses a Graphical User Interface, or GUI. This means that you (the user) will interact with the program by "pointing and clicking" with your mouse cursor.
When you first launch the application, the starting database must be generated, so it may take a moment to launch the first time around. Subsequent launches will be faster as the initial database will not need to be generated. Please be patient the first time around though so it can generate fully. You will likely notice a folder where the database files will be generated. Make sure you don't delete that folder, as that will delete the entire database!
Once you have launched the Basketball Database program, the first step to displaying the data you wish to see is to click the button at the top of the window that says "Lookup New Data". This will display a dialog that will allow you to choose what kind of information you want to display from the database.
Go through each area of the information selection and answer the questions that are asked there. If you do not answer all of the questions, an error message will be displayed and you will have to close it and fill in the missing information. The only exception to this is the last section where it asks about sorting. Sorting is completely optional.
Once you have selected the types of information you wish to see from the database, click the "OK" button at the bottom of the dialog. You will now see that the table has been refreshed with the information you selected. At this point you may add, edit, or delete information stored in the database or you may start over and look up some different information repeating the above steps.
There are three possible ways to add information to the database. Which option you choose is completely up to you, and the multiple methods are there for your ease of use.
The options to add data are:
The row will be added to the end of the table regardless of what is currently selected.
Once you use one of the above methods, a dialog will pop up and you will be able to enter in information to add to the database. Once all of the fields have been filled out, you can click the "Add" button, and it will add the information you typed in into the database. It's important to note that you must make sure you enter the right kind of information into the fields. For example, if you enter a name into the field asking for an age (which their age should be a number) the data you typed would be considered invalid. If this were to occur, an error message would display and you would have to go through and fix any invalid fields.
There are three possible ways to edit information currently stored in the database. Which option you choose is completely up to you, and the multiple methods are there for your ease of use.
The options to edit data are:
The row that will be edited is going to be whatever row you currently have selected in the table. If no rows are selected, nothing will happen when you follow one of the above methods.
Once you use one of the above methods, a dialog will pop up and you will be able to enter in information to edit in the database. Once all of the fields have been filled out, you can click the "Update" button, and it will update the information you typed in into the database. It's important to note that you must make sure you enter the right kind of information into the fields. For example, if you enter a name into the field asking for an age (which their age should be a number) the data you typed would be considered invalid. If this were to occur, an error message would display and you would have to go through and fix any invalid fields.
There are three possible ways to delete information currently stored in the database. Which option you choose is completely up to you, and the multiple methods are there for your ease of use.
The options to delete data are:
The row that will be deleted is going to be whatever row you currently have selected in the table. If no rows are selected, the very last row (the one at the very bottom) will be deleted from the database.
You will notice that deleting data works slightly differently from editing and adding data, as there is nothing to update or add to the database. So once you choose one of the above methods, a confirmation box will appear asking if you are absolutely sure that you want to delete the data. It's important to note that if you click "Yes", the data will be deleted and you cannot undo it. It is gone forever (or until you add it back in)!
If you mess up, you don't have to fear! You can reset the database back to its default values simply by going to the Edit Menu and then clicking on "Reset Entire Database". It's important to note though, that if you do click this option, any data that you may have added will be lost. This should only be used as a last resort when you have lost too much information to undo!
IMPORTANT NOTE: This feature is for advanced users ONLY. If you do not know how to use SQL commands, please do not attempt to use this feature!
For those advanced users wishing to access every little nook and cranny of the Basketball Database, you can enter in custom SQL Commands into the Admin Mode Panel. This feature is disabled by default, so to enable it, click on the Options Menu, then click the check box option that says "Show Admin Mode Panel".
As soon as you have done this, you will notice on the left-hand side of the window a text-box will have appeared. Here you can enter in your SQL Statement, then click "Submit Query" at the bottom left of the window, and the results of your query (if it's valid) will be displayed in the table. Please Note: Only SELECT Statements will work here (i.e. statements to display data).
Before downloading, it is recommended you review the How To Use tab, which explains how to use Basketball Database. System Requirements and Installation Instructions can be found below.
This is the latest and recommended version of Basketball Database.
| Version | File Size | Date Published | Changelog |
|---|---|---|---|
| 1.0.0 | 5.04 MB | February 23, 2019 |
In order to use Basketball Database, you will need the following system specifications.
Take the following steps to install Basketball Database on your computer: