Gym-Management-System

Gym Management System using java and java swing framework

MySQL Commands

Run the below command one after another in the MySQL Command Line Client Create table for members record

create database gms;
use gms;
create table member(id int,name varchar(200),mobilenumber bigint,email varchar(200),gender varchar(50),fathername varchar(200), mothername varchar(200),gymtime varchar(50),aadharnumber bigint,age int,amount int);
desc member;

Create table for payment records

create table payment(id int,month varchar(50),amount int);
desc payment;

Screenshots

Login

Dashboard

New Member