Payroll-System/pay_slip.java at main · hemantarora81/Payroll-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class pay_slip extends JFrame implements ActionListener {
    Choice c1;
    JTextArea t1;
    JButton b1;
pay_slip(){
    setSize(800,700);
    setLocation(400,150);
    c1 = new Choice();
    try{
        conn c = new conn();
        ResultSet rs = c.s.executeQuery("select * from salary");
            while(rs.next()){
                c1.add(rs.getString("id"));
            }
    }catch(Exception e){}
    setLayout(new BorderLayout());
    JPanel p1 = new JPanel();
    p1.add(new JLabel("Select id"));
    p1.add(c1);
    add(p1,"North");
    t1 = new JTextArea(30,80);
    JScrollPane jsp = new JScrollPane(t1);
    Font f1 = new Font("arial",Font.BOLD,20);
    t1.setFont(f1);
    b1 = new JButton("Generate Pay Slip");
    add(b1,"South");
    add(jsp,"Center");
    b1.addActionListener(this);
}
public void actionPerformed(ActionEvent ae){
try{
    conn c = new conn();
    ResultSet rs = c.s.executeQuery("select * from employee where id="+c1.getSelectedItem());
    rs.next();
    String name = rs.getString("name");
    rs.close();
    rs = c.s.executeQuery("select * from salary where id="+c1.getSelectedItem());
    double gross = 0;
    double net=0;
    java.util.Date d1 = new java.util.Date();
    int month = d1.getMonth();
    t1.setText(" -----------------PAY SLIP FOR THE MONTH OF"+month+",2016 --------------------");
    t1.append("\n");
    if(rs.next()){
        t1.append("\n   Employee ID"+rs.getString("id"));
        t1.append("\n     Employee Name"+name);
        t1.append("\n ---------------------------------------------------");
        t1.append("\n");
        double hra = rs.getDouble("hra");
        t1.append("\n                HRA        :"+hra);
         double da = rs.getDouble("da");
        t1.append("\n                DA        :"+da);
        double med = rs.getDouble("med");
        t1.append("\n                MED        :"+med);
        double pf = rs.getDouble("pf");
        t1.append("\n                PF        :"+pf);
        double basic = rs.getDouble("basic_salary");
        gross=hra+da+med+pf+basic;
        net = gross-pf;
        t1.append("\n               BASIC SALARY : "+basic);

        t1.append("\n ----------------------------------------------");
        t1.append("\n");
        t1.append("\n         GROSS SALARY :"+gross+"     \n       NET SALARY : "+net);
         t1.append("\n        Tax  :   2.1% of gross"+(gross*2.1/100));
          t1.append("\n ----------------------------------------");
           t1.append("\n");
            t1.append("\n");
             t1.append("\n");
              t1.append("  (Signature)      ");

    }
}catch(Exception ee){
    ee.printStackTrace();
}
}
public static void main(String[] args){
    new pay_slip().setVisible(true);
}
}