Electricity Bill Payment System

C.L.I BASED APPLICATION

The Electricity bill corporation of Rajasthan has an app for consumers to view and pay monthly bills. The bill includes a fixed connection charge, units consumed (at 10/- per unit), taxes (2.5% of total bill), and adjustments (if any, such as advanced payment, inflated meter reading, or pending previous month's bill).

The application will be used by the two categories of users:

• Admin (Administrator)
• User (Consumer)

Tech Stack

• JAVA
• J.D.B.C
• MYSQL

System Structure

The platform allows a consumer to browse the information related to the Electricity Bill, view his own History .

Administrator can see all consumers, bills, only paid and pending bills and can deactivate a consumer.

-Administrator :

1. Display All Consumers
2. Display Bill of Consumer
3. Display All Bill
4. Display Paid And Pending
5. Delete Consumer

-Consumer :

1. Sign-up
2. Login
3. Pay Bill
4. Transaction History

The ER-Diagram :

Setting & Installation

Install the Spring Tools Suite

https://spring.io/tools

Install MySQL Community Server

https://dev.mysql.com/downloads/mysql/

Clone the Project

https://github.com/Jasmin2410/superb-laborer-7095.git

Open MySQL Server

Create a New Database in SQL: Electricity_Bill_Payment_System 

Go to the Project Directory & Open SQL Folder > SQL Tables

Create The Same Tables in Your Electricity_Bill_Payment_System Database 

Create a Admin For Your Database

INSERT INTO ADMIN VALUES('Admin','Admin');

Run Locally

Go to the Project Directory

Open the Electricity_Bill_Payment_System Folder With S.T.S 

Go to Build Path > Libraries > Class_Path

 Add the Jar File Present in JDBC Driver As External Jar

Go to Utility Package > Data Base Utility

Connection = DriverManager.getConnection(url, "root", "ENTER YOUR SQL SERVER PASSWORD");

Go to Run Package

NOTE : Insert Data Into Database Either Through Application OR Through MySQL By Entering the Queries From SQL Queries  

Run as Java Application !

Demo

Screenshots

Contributions

Contributions are always Welcome !

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are Greatly Appreciated.

If you have a suggestion that would make this application better, Please fork the repo and create a pull request. You can also connect with me for further development of this application !

Don't forget to give the project a star ! Thank You !

🔗 Contact Me

Authors

• Jasmin Shaik

Acknowledgements

• Masai School