This is a project with MySQL database and JDBC, two databases are set up: 1. companyHR for management of employees, salary, projects et al; 2. sportsComplexManagement for management of a sport complex, data includes members, reserved sport court, date and time, prices and members' payment The goal of this project is for SQL query and JDBC study
#setup:
- database development tool: MySQL workbench
- Java SDE: IntelliJ
- External Library for JDBC: mysql-connector-java-8.0.17.jar
#data imported: All data imported into this project are fake data just for study