A DBMS app for managing Electricity Bills. It has TWO apps one is for admin and the other is for the user.
Admin app features include adding new connections deleting existing connections checking any complaints raised by the user. As we don't have any hardware to measure electricity consumption the admin can also input the kilowatt consumed by the user.
User app features include paying the Bills using a Card, viewing the previous transaction made, downloading the invoice, raising the issues to the admin & changing the password.
This project focuses on Database concepts and Java application development. In Database, we have used Triggers and Stored Procedures.
Technologies used for UI Development
Java
JavaFX
AnimateFX
JDBC
CSS
MySQL/SQL
IDE - IntelliJ, Scene Builder
Database Management - MySQL Workbench
Admin Login Details
User Name - admin
Password - admin
Database Name ESM
Username - root
Password - MySQL@123
Fun Fact - This Project Has 5966 lines of code.
Buttons color Changes when Hovered Over.
User APP
Login Page
Here There is Image SildeShow & SildeShow about facts on Indian Power Grid.
User UI
Payment
Transaction History
More History will come by doing more transactions like in PhonePe.
Change Password
Complaint Section
ADMIN APP
Login Page
Here There is Image SildeShow & SildeShow about facts on Indian Power Grid.
Admin UI
New Connection
Regular Expressions are used for checking the inputs.
Bills
Check existing users
Inbox
SQL Tables
Copyright @ Nithin R, The Oxford College Of Engineering.