Unit testing for database access control methods

• 1. Ensure that end user uses batch file contained within configuration files to check whether on not MySQL is installed on the system. Output for said test will print appropriate action to screen.
  • 1.1. If MySQL was found, batch file populates database using Java application
  • 1.2. If MySQL was not found command prompt will print error message.
• 2. Ensure that the proper java helper applications are installed on the system, otherwise command prompt will print error message.
  • 2.1. Ensure that the JDBC is able to connect to the database
  • 2.2. Ensure that the JDBC is able to communicate with the database
• 3. Ensure that the data is able to be accessed by the virtual casino Graphical User Interface (GUI).
  • 3.1. End user enters playerID and password issued by system administrator into appropriate text box areas.
  • 3.2 If player enters correct username and password is then assigned to table automatically.
  • 3.3 If player enters incorrect username and password user is prompted by dialog box to retry username and password or to exit program.
• 4. Exit the blackjack game after having the starting bank balance changed in value .
• 5. Re-enter the same playerID and check that the bank balance changes are reflected by the previous actions taken in step 4.
• 6. Open another client and have that client try an log in using the same playerID as the one used in step 9 ensuring that the database recognizes that an existing client is using that playerID and the proper action is taken.
• 7. Ensure that database rollback and recovery system is invoked when "-r" is entered into command prompt.