Skip to main content

ELECTRICITY BILLING SYSTEM

ELECTRICITY BILLING SYSTEM
Create a electricity biilling system using JAVA

#knowledge #stream #blog
you can find the full source code for the project below.


A - Below is the source code of the project.

B - Create separate class files for every class.

C - Copy the code of one class (ex: login.java) and paste it in Login class file, do it for every class.

1 - Create your first class with name 'conn' and paste the code


package Electricity;

import java.sql.*;  

//knowledgestreams.blogspot.com

public class conn{
    Connection c;
    Statement s;
    public conn(){  
        try{  
            Class.forName("com.mysql.jdbc.Driver");  
            c =DriverManager.getConnection("jdbc:mysql:///project","root","");    
            s =c.createStatement();  
        }catch(Exception e){ 
            System.out.println(e);
        }  
    }  
}  
//knowledgestreams.blogspot.com
//knowledgestreams.blogspot.com

2 - Create next class with name 'Splash' and paste the code below in it. This is also our Main Frame of the project.

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class splash { public static void main(String[] args){ fframe f1 = new fframe(); f1.setVisible(true); int i; int x=1; for(i=2; i<=600; i+=4, x+=1){ f1.setLocation(800 - ((i+x)/2), 500 - (i/2)); f1.setSize(i+x,i); try{ Thread.sleep(10); }catch(Exception e){} } } } class fframe extends JFrame implements Runnable{ Thread t1; fframe(){ super("Electricity Billing System"); setLayout(new FlowLayout()); ImageIcon c1 = new ImageIcon(ClassLoader.getSystemResource("icon/elect.jpg")); Image i1 = c1.getImage().getScaledInstance(730, 550,Image.SCALE_DEFAULT); ImageIcon i2 = new ImageIcon(i1); JLabel l1 = new JLabel(i2); add(l1); t1 = new Thread(this); t1.start(); } public void run(){ try{ Thread.sleep(7000); this.setVisible(false); Login l = new Login(); l.setVisible(true); }catch(Exception e){ e.printStackTrace(); } } }

 //knowledgestreams.blogspot.com https://knowledgestreams.blogspot.com/

3 - Create next class with name 'Login'.

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class Login extends JFrame implements ActionListener{ JLabel l1,l2,l3; JTextField tf1; JPasswordField pf2; JButton b1,b2; JPanel p1,p2,p3,p4; Login(){ super("Login Page"); l1 = new JLabel("Username"); l2 = new JLabel("Password"); tf1 = new JTextField(15); pf2 = new JPasswordField(15); ImageIcon ic1 = new ImageIcon(ClassLoader.getSystemResource("icon/login.png")); Image i1 = ic1.getImage().getScaledInstance(16, 16,Image.SCALE_DEFAULT); b1 = new JButton("Login", new ImageIcon(i1)); ImageIcon ic2 = new ImageIcon(ClassLoader.getSystemResource("icon/cancel.jpg")); Image i2 = ic2.getImage().getScaledInstance(16, 16,Image.SCALE_DEFAULT); b2 = new JButton("Cancel",new ImageIcon(i2)); b1.addActionListener(this); b2.addActionListener(this); ImageIcon ic3 = new ImageIcon(ClassLoader.getSystemResource("icon/pop.png")); Image i3 = ic3.getImage().getScaledInstance(128, 128,Image.SCALE_DEFAULT); ImageIcon icc3 = new ImageIcon(i3); l3 = new JLabel(icc3); setLayout(new BorderLayout()); p1 = new JPanel(); p2 = new JPanel(); p3 = new JPanel(); p4 = new JPanel(); knowledgestreams.blogspot.com add(l3,BorderLayout.WEST); p2.add(l1); p2.add(tf1); p2.add(l2); p2.add(pf2); add(p2,BorderLayout.CENTER); p4.add(b1); p4.add(b2); add(p4,BorderLayout.SOUTH); p2.setBackground(Color.WHITE); p4.setBackground(Color.WHITE); setSize(440,250); setLocation(600,400); setVisible(true); //knowledgestreams.blogspot.com } public void actionPerformed(ActionEvent ae){ try{ conn c1 = new conn(); String a = tf1.getText(); String b = pf2.getText(); String q = "select * from login where username = '"+a+"' and password = '"+b+"'"; ResultSet rs = c1.s.executeQuery(q); if(rs.next()){ new Project().setVisible(true); this.setVisible(false); }else{ JOptionPane.showMessageDialog(null, "Invalid login"); setVisible(false); } }catch(Exception e){ e.printStackTrace(); System.out.println("error: "+e); } } public static void main(String[] args){ new Login().setVisible(true); } }

//knowledgestreams.blogspot.com
4 - Create next class with name 'Project' and paste the code inside the class.

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class Project extends JFrame implements ActionListener{ Project(){ super("Electricity Billing System"); setSize(1920,1030); /* Adding background image */ ImageIcon ic = new ImageIcon(ClassLoader.getSystemResource("icon/elect1.jpg")); Image i3 = ic.getImage().getScaledInstance(1900, 950,Image.SCALE_DEFAULT); ImageIcon icc3 = new ImageIcon(i3); JLabel l1 = new JLabel(icc3); add(l1); /* First Column */ JMenuBar mb = new JMenuBar(); JMenu master = new JMenu("Master"); JMenuItem m1 = new JMenuItem("New Customer"); JMenuItem m2 = new JMenuItem("Customer Details"); JMenuItem m3 = new JMenuItem("Deposit Details"); master.setForeground(Color.BLUE); /* ---- Customer Details ---- */ m1.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon1 = new ImageIcon(ClassLoader.getSystemResource("icon/icon1.png")); Image image1 = icon1.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); m1.setIcon(new ImageIcon(image1)); m1.setMnemonic('D'); m1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_D, ActionEvent.CTRL_MASK)); m1.setBackground(Color.WHITE); /* ---- Meter Details ---- */ m2.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon2 = new ImageIcon(ClassLoader.getSystemResource("icon/icon2.png")); Image image2 = icon2.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); m2.setIcon(new ImageIcon(image2)); m2.setMnemonic('M'); m2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_M, ActionEvent.CTRL_MASK)); m2.setBackground(Color.WHITE); /* ---- Deposit Details ----- */ m3.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon3 = new ImageIcon(ClassLoader.getSystemResource("icon/icon3.png")); Image image3 = icon3.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); m3.setIcon(new ImageIcon(image3)); m3.setMnemonic('N'); m3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_N, ActionEvent.CTRL_MASK)); m3.setBackground(Color.WHITE); m1.addActionListener(this); m2.addActionListener(this); m3.addActionListener(this); // -------------------------------------------------------------------------------------------- //knowledgestreams.blogspot.com
/* Second Column */ JMenu user = new JMenu("User"); JMenuItem u1 = new JMenuItem("Pay Bill"); JMenuItem u2 = new JMenuItem("Calculate Bill"); JMenuItem u3 = new JMenuItem("Last Bill"); user.setForeground(Color.RED); /* ---- Pay Bill ---- */ u1.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon4 = new ImageIcon(ClassLoader.getSystemResource("icon/icon4.png")); Image image4 = icon4.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); u1.setIcon(new ImageIcon(image4)); u1.setMnemonic('P'); u1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_P, ActionEvent.CTRL_MASK)); u1.setBackground(Color.WHITE); /* ---- Bill Details ---- */ u2.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon5 = new ImageIcon(ClassLoader.getSystemResource("icon/icon5.png")); Image image5 = icon5.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); u2.setIcon(new ImageIcon(image5)); u2.setMnemonic('B'); u2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_B, ActionEvent.CTRL_MASK)); u2.setBackground(Color.WHITE); /* ---- Last Bill ----*/ u3.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon6 = new ImageIcon(ClassLoader.getSystemResource("icon/icon6.png")); Image image6 = icon6.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); u3.setIcon(new ImageIcon(image6)); u3.setMnemonic('L'); u3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_L, ActionEvent.CTRL_MASK)); u3.setBackground(Color.WHITE); u1.addActionListener(this); u2.addActionListener(this); u3.addActionListener(this); // --------------------------------------------------------------------------------------------- /* Third Column*/ JMenu report = new JMenu("Report"); JMenuItem r1 = new JMenuItem("Generate Bill"); report.setForeground(Color.BLUE); /* ---- Report ---- */ r1.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon7 = new ImageIcon(ClassLoader.getSystemResource("icon/icon7.png")); Image image7 = icon7.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); r1.setIcon(new ImageIcon(image7)); r1.setMnemonic('R'); r1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_R, ActionEvent.CTRL_MASK)); r1.setBackground(Color.WHITE); r1.addActionListener(this); // ----------------------------------------------------------------------------------------------- /* Fourth Column*/ JMenu utility = new JMenu("Utility"); JMenuItem ut1 = new JMenuItem("Notepad"); JMenuItem ut2 = new JMenuItem("Calculator"); JMenuItem ut3 = new JMenuItem("Web Browser"); utility.setForeground(Color.RED); /* ---- Calender ---- */ ut1.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon8 = new ImageIcon(ClassLoader.getSystemResource("icon/icon12.png")); Image image8 = icon8.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); ut1.setIcon(new ImageIcon(image8)); ut1.setMnemonic('C'); ut1.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_C, ActionEvent.CTRL_MASK)); ut1.setBackground(Color.WHITE); /* ---- Calculator ---- */ ut2.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon9 = new ImageIcon(ClassLoader.getSystemResource("icon/icon9.png")); Image image9 = icon9.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); ut2.setIcon(new ImageIcon(image9)); ut2.setMnemonic('X'); ut2.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_X, ActionEvent.CTRL_MASK)); ut2.setBackground(Color.WHITE); /* ---- Web Browser ---- */ ut3.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon10 = new ImageIcon(ClassLoader.getSystemResource("icon/icon10.png")); Image image10 = icon10.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); ut3.setIcon(new ImageIcon(image10)); ut3.setMnemonic('W'); ut3.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_W, ActionEvent.CTRL_MASK)); ut3.setBackground(Color.WHITE); ut1.addActionListener(this); ut2.addActionListener(this); ut3.addActionListener(this); // --------------------------------------------------------------------------------------- /*Fifth Column */ JMenu exit = new JMenu("Exit"); JMenuItem ex = new JMenuItem("Exit"); exit.setForeground(Color.BLUE); /* ---- Exit ---- */ ex.setFont(new Font("monospaced",Font.PLAIN,12)); ImageIcon icon11 = new ImageIcon(ClassLoader.getSystemResource("icon/icon11.png")); Image image11 = icon11.getImage().getScaledInstance(20, 20,Image.SCALE_DEFAULT); ex.setIcon(new ImageIcon(image11)); ex.setMnemonic('Z'); ex.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_Z, ActionEvent.CTRL_MASK)); ex.setBackground(Color.WHITE); ex.addActionListener(this); // --------------------------------------------------------------------------------------------- master.add(m1); master.add(m2); master.add(m3); user.add(u1); user.add(u2); user.add(u3); report.add(r1); utility.add(ut1); utility.add(ut2); utility.add(ut3); exit.add(ex); mb.add(master); mb.add(user); mb.add(report); mb.add(utility); mb.add(exit); setJMenuBar(mb); setFont(new Font("Senserif",Font.BOLD,16)); setLayout(new FlowLayout()); setVisible(false); } public void actionPerformed(ActionEvent ae){ String msg = ae.getActionCommand(); if(msg.equals("Customer Details")){ new customer_details().setVisible(true); }else if(msg.equals("New Customer")){ new new_customer().setVisible(true); }else if(msg.equals("Calculate Bill")){ new calculate_bill().setVisible(true); }else if(msg.equals("Pay Bill")){ new pay_bill().setVisible(true); }else if(msg.equals("Notepad")){ try{ Runtime.getRuntime().exec("notepad.exe"); }catch(Exception e){ } }else if(msg.equals("Calculator")){ try{ Runtime.getRuntime().exec("calc.exe"); }catch(Exception e){ } }else if(msg.equals("Web Browser")){ try{ Runtime.getRuntime().exec("C:\\Program Files (x86)\\Mozilla Firefox\\firefox.exe"); }catch(Exception e){ } }else if(msg.equals("Exit")){ System.exit(0); }else if(msg.equals("Generate Bill")){ new generate_bill().setVisible(true); } } public static void main(String[] args){ new Project().setVisible(true); } }

knowledge streams blog spot com

5 - Create next class with name 'new_customer'.


package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class new_customer extends JFrame implements ActionListener{ JLabel l1,l2,l3,l4,l5,l6,l7,l8; JTextField t1,t2,t3,t4,t5,t6,t7; JButton b1,b2; new_customer(){ setLocation(350,200); setSize(650,600); JPanel p = new JPanel(); p.setLayout(new GridLayout(9,2,10,10)); p.setBackground(Color.WHITE); l1 = new JLabel("Name"); t1 = new JTextField(); p.add(l1); p.add(t1); l2 = new JLabel("Meter No"); t2 = new JTextField(); p.add(l2); p.add(t2); l3 = new JLabel("Address"); t3 = new JTextField(); p.add(l3); p.add(t3); l4 = new JLabel("State"); t4 = new JTextField(); p.add(l4); p.add(t4); l5 = new JLabel("City"); t5 = new JTextField(); p.add(l5); p.add(t5); l6 = new JLabel("Email"); t6 = new JTextField(); p.add(l6); p.add(t6); l7 = new JLabel("Phone Number"); t7 = new JTextField(); p.add(l7); p.add(t7); b1 = new JButton("Submit"); b2 = new JButton("Cancel"); b1.setBackground(Color.BLACK); b1.setForeground(Color.WHITE); b2.setBackground(Color.BLACK); b2.setForeground(Color.WHITE); p.add(b1); p.add(b2); setLayout(new BorderLayout()); add(p,"Center"); ImageIcon ic1 = new ImageIcon(ClassLoader.getSystemResource("icon/hicon1.jpg")); Image i3 = ic1.getImage().getScaledInstance(150, 300,Image.SCALE_DEFAULT); ImageIcon ic2 = new ImageIcon(i3); l8 = new JLabel(ic2); add(l8,"West"); //for changing the color of the whole getContentPane().setBackground(Color.WHITE); b1.addActionListener(this); b2.addActionListener(this); } public void actionPerformed(ActionEvent ae){ String a = t1.getText(); String c = t2.getText(); String d = t3.getText(); String e = t4.getText(); String f = t5.getText(); String g = t6.getText(); String h = t7.getText(); String q1 = "insert into emp values('"+a+"','"+c+"','"+d+"','"+e+"','"+f+"','"+g+"','"+h+"')"; try{ conn c1 = new conn(); c1.s.executeUpdate(q1); JOptionPane.showMessageDialog(null,"Employee Created"); this.setVisible(false); }catch(Exception ex){ ex.printStackTrace(); } } public static void main(String[] args){ new new_customer().setVisible(true); } }


6 - Create next class with name 'customer_details'.
#knowledgestreams.blogspot.com

//knowledge streams blog spot

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class customer_details extends JFrame implements ActionListener{ JTable t1; JButton b1; String x[] = {"Emp Name","Meter No","Address","State","City","Email","Phone"}; String y[][] = new String[20][8]; int i=0, j=0; customer_details(){ super("Customer Details"); setSize(1200,650); setLocation(200,200); try{ conn c1 = new conn(); String s1 = "select * from emp"; ResultSet rs = c1.s.executeQuery(s1); while(rs.next()){ y[i][j++]=rs.getString("name"); y[i][j++]=rs.getString("meter_number"); y[i][j++]=rs.getString("address"); y[i][j++]=rs.getString("state"); y[i][j++]=rs.getString("city"); y[i][j++]=rs.getString("email"); y[i][j++]=rs.getString("phone"); i++; j=0; } t1 = new JTable(y,x); }catch(Exception e){ e.printStackTrace(); } b1 = new JButton("Print"); add(b1,"South"); JScrollPane sp = new JScrollPane(t1); add(sp); b1.addActionListener(this); } public void actionPerformed(ActionEvent ae){ try{ t1.print(); }catch(Exception e){} } public static void main(String[] args){ new customer_details().setVisible(true); } }


7 - Create next class with name 'calculate_bill'.

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class calculate_bill extends JFrame implements ActionListener{ JLabel l1,l2,l3,l4,l5; JTextField t1; Choice c1,c2; JButton b1,b2; JPanel p; calculate_bill(){ p = new JPanel(); p.setLayout(new GridLayout(4,2,30,30)); p.setBackground(Color.WHITE); l1 = new JLabel("Calculate Electricity Bill"); l2 = new JLabel("Meter No"); l3 = new JLabel("Units Cosumed"); l5 = new JLabel("Month"); t1 = new JTextField(); c1 = new Choice(); c1.add("1001"); c1.add("1002"); c1.add("1003"); c1.add("1004"); c1.add("1005"); c1.add("1006"); c1.add("1007"); c1.add("1008"); c1.add("1009"); c1.add("1010"); c2 = new Choice(); c2.add("January"); c2.add("February"); c2.add("March"); c2.add("April"); c2.add("May"); c2.add("June"); c2.add("July"); c2.add("August"); c2.add("September"); c2.add("October"); c2.add("November"); c2.add("December"); b1 = new JButton("Submit"); b2 = new JButton("Cancel"); b1.setBackground(Color.BLACK); b1.setForeground(Color.WHITE); b2.setBackground(Color.BLACK); b2.setForeground(Color.WHITE); ImageIcon i1 = new ImageIcon(ClassLoader.getSystemResource("icon/hicon2.jpg")); Image i2 = i1.getImage().getScaledInstance(180, 270,Image.SCALE_DEFAULT); ImageIcon i3 = new ImageIcon(i2); l4 = new JLabel(i3); l1.setFont(new Font("Senserif",Font.PLAIN,26)); //Move the label to center l1.setHorizontalAlignment(JLabel.CENTER); p.add(l2); p.add(c1); p.add(l5); p.add(c2); p.add(l3); p.add(t1); p.add(b1); p.add(b2); setLayout(new BorderLayout(30,30)); add(l1,"North"); add(p,"Center"); add(l4,"West"); //knowledgestreams.blogspot.com b1.addActionListener(this); b2.addActionListener(this); getContentPane().setBackground(Color.WHITE); setSize(650,500); setLocation(350,220); } public void actionPerformed(ActionEvent ae){ String a = c1.getSelectedItem(); String b = t1.getText(); String c = c2.getSelectedItem(); int p1 = Integer.parseInt(b); int p2 = p1*7; int p3 = p2+50+12+102+20+50; String q = "insert into bill values('"+a+"','"+c+"','"+b+"','"+p3+"')"; try{ conn c1 = new conn(); c1.s.executeUpdate(q); JOptionPane.showMessageDialog(null,"Bill Updated"); }catch(Exception aee){ aee.printStackTrace(); } } public static void main(String[] args){ new calculate_bill().setVisible(true); } }



8 - Create next class with name 'pay_bill'.

package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; public class pay_bill extends JFrame{ pay_bill(){ JEditorPane j = new JEditorPane(); j.setEditable(false); try { j.setPage("https://paytm.com/electricity-bill-payment"); }catch (Exception e) { j.setContentType("text/html"); j.setText("<html>Could not load</html>"); } JScrollPane scrollPane = new JScrollPane(j); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); getContentPane().add(scrollPane); setPreferredSize(new Dimension(800,600)); setSize(800,800); setLocation(250,120); setVisible(true); } public static void main(String[] args){ new pay_bill().setVisible(true); } }
//knowledgestreams.blogspot.com

9 - Create next class with name 'generate_bill'.


package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class generate_bill extends JFrame implements ActionListener{ JLabel l1; JTextArea t1; JButton b1; Choice c1,c2; JPanel p1; generate_bill(){ setSize(500,900); setLayout(new BorderLayout()); p1 = new JPanel(); l1 = new JLabel("Generate Bill"); c1 = new Choice(); c2 = new Choice(); //knowledgestreams.blogspot.com
c1.add("1001"); c1.add("1002"); c1.add("1003"); c1.add("1004"); c1.add("1005"); c1.add("1006"); c1.add("1007"); c1.add("1008"); c1.add("1009"); c1.add("1010"); c2.add("January"); c2.add("February"); c2.add("March"); c2.add("April"); c2.add("May"); c2.add("June"); c2.add("July"); c2.add("August"); c2.add("September"); c2.add("October"); c2.add("November"); c2.add("December"); t1 = new JTextArea(50,15); JScrollPane jsp = new JScrollPane(t1); t1.setFont(new Font("Senserif",Font.ITALIC,18)); b1 = new JButton("Generate Bill"); p1.add(l1); p1.add(c1); p1.add(c2); add(p1,"North"); add(jsp,"Center"); add(b1,"South"); b1.addActionListener(this); //knowledgestreams.blogspot.com setLocation(350,40); } public void actionPerformed(ActionEvent ae){ try{ conn c = new conn(); String month = c2.getSelectedItem(); t1.setText("\abc\nELECTRICITY BILL FOR THE MONTH OF "+month+" ,2018\n\n\n"); ResultSet rs = c.s.executeQuery("select * from emp where meter_number="+c1.getSelectedItem()); if(rs.next()){ t1.append("\n Customer Name:"+rs.getString("name")); t1.append("\n Meter Number: "+rs.getString("meter_number")); t1.append("\n Address: "+rs.getString("address")); t1.append("\n State: "+rs.getString("state")); t1.append("\n City: "+rs.getString("city")); t1.append("\n Email: "+rs.getString("email")); t1.append("\n Phone Number "+rs.getString("phone")); t1.append("\n-------------------------------------------------------------"); t1.append("\n"); } rs = c.s.executeQuery("select * from tax"); if(rs.next()){ t1.append("\n Meter Location:"+rs.getString("meter_location")); t1.append("\n Meter Type: "+rs.getString("meter_type")); t1.append("\n Phase Code: "+rs.getString("phase_code")); t1.append("\n Bill Type: "+rs.getString("bill_type")); t1.append("\n Days: "+rs.getString("days")); t1.append("\n"); t1.append("---------------------------------------------------------------"); t1.append("\n\n"); t1.append("\n Meter Rent:\t\t"+rs.getString("meter_rent")); t1.append("\n MCB Rent: \t\t"+rs.getString("mcb_rent")); t1.append("\n Service Tax:\t"+rs.getString("service_rent")); t1.append("\n GST@9%:\t\t"+rs.getString("gst")); t1.append("\n"); } rs = c.s.executeQuery("select * from bill where meter_number="+c1.getSelectedItem()); if(rs.next()){ t1.append("\n Current Month :\t"+rs.getString("month")); t1.append("\n Units Consumed:\t"+rs.getString("units")); t1.append("\n Total Charges :\t"+rs.getString("amount")); t1.append("\n---------------------------------------------------------------"); t1.append("\n TOTAL PAYABLE :\t"+rs.getString("amount")); } //knowledgestreams.blogspot.com
}catch(Exception e){ e.printStackTrace(); } } public static void main(String[] args){ new generate_bill().setVisible(true); } }

10- Create next class with name "Last Bill"
package Electricity; import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; public class LastBill extends JFrame implements ActionListener{ JLabel l1; JTextArea t1; JButton b1; Choice c1; JPanel p1; LastBill(){ setSize(500,900); setLayout(new BorderLayout()); p1 = new JPanel(); l1 = new JLabel("Generate Bill"); c1 = new Choice(); c1.add("1001"); c1.add("1002"); c1.add("1003"); c1.add("1004"); c1.add("1005"); c1.add("1006"); c1.add("1007"); c1.add("1008"); c1.add("1009"); c1.add("1010"); t1 = new JTextArea(50,15); JScrollPane jsp = new JScrollPane(t1); t1.setFont(new Font("Senserif",Font.ITALIC,18)); b1 = new JButton("Generate Bill"); p1.add(l1); p1.add(c1); add(p1,"North"); add(jsp,"Center"); add(b1,"South"); b1.addActionListener(this); setLocation(350,40); } public void actionPerformed(ActionEvent ae){ try{ conn c = new conn(); ResultSet rs = c.s.executeQuery("select * from emp where meter_number="+c1.getSelectedItem()); if(rs.next()){ t1.append("\n Customer Name:"+rs.getString("name")); t1.append("\n Meter Number: "+rs.getString("meter_number")); t1.append("\n Address: "+rs.getString("address")); t1.append("\n State: "+rs.getString("state")); t1.append("\n City: "+rs.getString("city")); t1.append("\n Email: "+rs.getString("email")); t1.append("\n Phone Number "+rs.getString("phone")); t1.append("\n-------------------------------------------------------------"); t1.append("\n"); } t1.append("Details of the Last Bills\n\n\n"); rs = c.s.executeQuery("select * from bill where meter_number="+c1.getSelectedItem()); while(rs.next()){ t1.append(" "+ rs.getString("month") + " " +rs.getString("amount") + "\n"); } }catch(Exception e){ e.printStackTrace(); } } public static void main(String[] args){ new LastBill().setVisible(true); } }


#java #electricity #bill #code
Free source code for java project on electricity billing system.

Labels

Labels:

Popular posts from this blog

Rectangular Microstrip Patch Antenna

Microstrip is a type of electrical transmission line which can be fabricated using printed circuit board technology, and is used to convey microwave-frequency signals. It consists of a conducting strip separated from a ground plane by a dielectric layer known as the substrate. The most commonly employed microstrip antenna is a rectangular patch which looks like a truncated  microstrip  transmission line. It is approximately of one-half wavelength long. When air is used as the dielectric substrate, the length of the rectangular microstrip antenna is approximately one-half of a free-space  wavelength . As the antenna is loaded with a dielectric as its substrate, the length of the antenna decreases as the relative  dielectric constant  of the substrate increases. The resonant length of the antenna is slightly shorter because of the extended electric "fringing fields" which increase the electrical length of the antenna slightly. An early model of the microst...
Read more

Prepare Data for Exploration : weekly challenge 1

Prepare Data for Exploration : weekly challenge 1 #coursera #exploration #weekly #challenge 1 #cybersecurity #coursera #quiz #solution #network Are you prepared to increase your data exploration abilities? The goal of Coursera's Week 1 challenge, "Prepare Data for Exploration," is to provide you the skills and resources you need to turn unprocessed data into insightful information. With the knowledge you'll gain from this course, you can ensure that your data is organised, clean, and ready for analysis. Data preparation is one of the most important processes in any data analysis effort. Inaccurate results and flawed conclusions might emerge from poorly prepared data. You may prepare your data for exploration with Coursera's Weekly Challenge 1. You'll discover industry best practises and insider advice. #answers #questions #flashcard 1 . Question 1 What is the most likely reason that a data analyst would use historical data instead of gathering new data? 1 / 1...
Post a Comment
Read more

Cracking Passwords Using John the Ripper: A Complete Step-by-Step Guide

Cracking Passwords Using John the Ripper: A Complete Step-by-Step Guide In today's post, we’re diving into a practical lab exercise that shows how to use John the Ripper, one of the most effective password-cracking tools in cybersecurity. Whether you're an IT professional or a cybersecurity student, mastering John the Ripper will help you understand password vulnerabilities and enhance your penetration testing skills. Lab Objective: The goal of this lab is to crack the root password on a Linux system (Support) and extract the password from a password-protected ZIP file (located on IT-Laptop). Both tasks are performed using John the Ripper. Steps to Crack the Root Password on Support: Open the Terminal on the Support system. Change directories to /usr/share/john . List the files and open password.lst to view common password guesses. Use John the Ripper to crack the root password by running john /etc/shadow . Once cracked, the password is stored in the john.pot file for future u...
Post a Comment
Read more