Connecting to database

Description

Added code to connect local MySQL database to server application

Issue

Issue 52

Feature

Connection to database

Tophatting

1. Download MySQL and SQL workbench locally

• MySQL https://dev.mysql.com/downloads/installer/ (make sure to download MySQL Server and set a password! You'll need this password to login.)
• Download a database "viewer" - Jacob used https://www.mysql.com/products/workbench/
• Connect to your root database and run the query "CREATE DATABASE whatoodo"

2. In LogicApplication.Kt change your username and password for your respective MySQL server
3. Run the server
4. Should output "Successfully connected to database"

Expected current behavior

Connection to database

Changes

• Used Java DriverManager, Connection and SQL Exception to connect to mysql database

Screenshots

Not required

Design Patterns

No design patterns applied

Deviations

Were there any deviations from the original design or architecture plan. If yes, what were they ?

Yes, was supposed to use Firebase/Firestore but now using MySQL

Additional

• Unit test written
• Meets requirements
• Cross-browser tested
• Added/updated documentation as needed
• Camel case style used

Closes #52 (closed)