sarthakdevhub/Spark-bill-payment-system

The Electricity bill payment having crud funtionality techksatck used - java,mySQL,JDBC.

Bill payment System

The Electricity bill corporation of Rajasthan has provided an application to view/pay bills to consumers. Bills are generated monthly i.e. bill cycle is from the 1st of every month to the last day of the month. Bill is computed on behalf of a fixed charge for connection + units consumed (10/- per unit) + Taxes (2.5% of total bill) + Adjustment (if any, such that adjustment can be in favor of consumer/corporation like due to any advanced payment, inflated meter reading, pending previous month bill, etc.) There are 2 users in the system:

1. Administrator
2. Consumer

The Role of the Administrator:

Note: Don't create a table to store the credentials of the administrator. Keep the username and password fixed for admin (like username: ‘admin’ password: ‘admin’)

1. Login with his account.
2. View all consumers.
3. View the bill of the consumer. Electricity Bill Payment System 2
4. View all the bills.
5. View all bills paid and pending
6. Delete consumer (means set the consumer connection inactive)

The Role of a Consumer:

1. The consumer can sign-up. At the time of sign up first name, last name, username, password, address, mobile number, and email should be taken.
2. Login with his account
3. Pay bill
4. View his own transaction History

Tech-stack used

1. JAVA
2. MYSQL
3. JDBC
4. GitHub

ER Diagram

Flow Chart