Super Market Management System

DATABASE CONECTIVITY :

In Mysql DBMS,

• create database named as "supermarketmanagementsystem".

• create tables named as "login" ,"employee" and "product".

Structure of "login" table

Structure of "employee" table

Structure of "product" table

How to run an application

• make database connectivity
• add external jar files to project directory
• run the file "src/Splash.java"

Working of Application

• run src/Splash.java

• Signup module for new employee
• Here are 3 types of users(Admin,Manager,Cashier)
• Input validation :
  • Password and Confirm-Password should be same
  • Username and Password have to be more 0 length and less than size of VARCHAR specified in DB.
  • Password must contain atleast one Uppercase [A-Z] ,Lowercase [a-z], Number [0-9] and Special Char(@#$%)

• Added detailes for one employee

• DETAILS also added successfully to "login" table

• login as "Navin"
• Since "Navin" is cashier, he is able to see only options for logout and billing System

• after enter detailes of cutomer we can add items by thier Id or Name using add1 button or add2 button

+ after pessing bill you will bill in your textarea

• save as will create txt file for bill and refresh button reset input fields

+ when you logged in as "admin" you will get additionally two more functionality for employee management and product management

• employee detailes after pressing view employee

• adding new employee detailes

• after adding new employee

+deleting employee by employeeId

+after deleting an employee

• same CRUD functionalities for product management

• product detailes