The GMS (Gym Management System) project is the software program that tracks, maintains, and manages all the member and staff data, entirely constructed at the administrative level, only the administration has access, it was developed in Java Programming using NetBeansIDE, JFrame, and MySQL Database. That project will assist gym managers to manage their customers, and staffs.
- Front-end: Friendly user-interface with Java Swing
- Back-end: Handled by the SQL database via JDBC API to communicate with MySQL.
- Administrative level: provided username and password {admin,admin}
- Record of Member, Payment, and Trainer
To execute the below project, you will need the following requirements:
- MySQL Community Server
- MySQL JDBC Connector
- Java
- NetBeans IDE
- The user will be an admin by default, and the username and password will be {admin, admin}
- The admin menu as below, consists of Add Member, Manage Member, Trainers, Members List, Payments, and Log out
- To add member, click on the option "Add Members" from admin menu
- To manage member, click on the option "Manage Members" from admin menu
- To add/manage trainer, click on the option "Trainers" from admin menu
- To view the members, click on the option "Members List" from admin menu
- To manage payments, click on the option "Payments" from admin menu
-
To get the database first create a database in MySQL and then put the gmsdb_dump.sql dump file in your MySQL Server 8.0\bin directory. Now in command prompt enter:
- cd Program Files/MySQL/MySQL Server8.0/bin “press enter"
- mysql –u root –p database_name < database_name.sql “press enter”
This will complete the database transfer to your computer.
- Tai Quach quachthientai@gmail.com






