Electricity Billing System

Tech Stack Used: Java/Java Swing MySQL

Aim: For an electricity consumer, to be able to pay/generate their electricity bill.

Things kept in mind: Users will be able to create and login into their account and get their bills generated on the basis of their location and meter rent. Users can only take a look at their bills. They cannot create their own bills and add meter readings, as this can lead to bluffing. Admins will have their respective id/password, through which they can login and can upload bills of different customers based on their meterID. Admins can also look at the details of various bills and customers.

Database Information:

Table 1: User having attributes name, phone, meter_no, state, email, username

Table 2: Userlogin having attributes username, password

Table 3: bill having attributes meter_no, month and bill

Table 4: state_tax having attributes state and tax

Table 5: login(admin) having attributes username, password

Table 6: Meter_type having attributes type_name and rent

Table 5: Meter having attributes meter_no and type_name

Steps to run the application:

import the databases into mysql database. Connect - connect class with mysql using JDBC jar file. Run flash class. Preview of different classes are as follows:

This is the opening screen. After this user/admin is needed to be selected.

If admin is selected following screen will appear:

If view users is selected :

If Generate a bill is selected: Meter no. and units consumed is needed and then corresponding bills will be generated as shown below.

If an admin wants to delete a user, he just needs to enter the unique username to do so.

If user is selected:

They can see their profile details on login.

If users click on get bill, they can take a look at the bills as updated by the admin.