Employee-Management-System/UpdateDesignationFrame.java at main · Varshitha1110006/Employee-Management-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
85
86
87
88
89
90
91
92
93
94
95
package com.ems.gui.leave;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import com.ems.db.DBConnection;
import javax.swing.JFrame;
import javax.swing.JTextArea;
import javax.swing.JScrollPane;

public class ViewLeaveRecordsFrame extends JFrame {

    JTextArea area;

    public ViewLeaveRecordsFrame() {

        setTitle("View Leave Records");

        setSize(700, 500);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE
        );

        area = new JTextArea();

        JScrollPane pane =
                new JScrollPane(area);

        pane.setBounds(
                20,
                20,
                640,
                400
        );

        add(pane);
        try {

            Connection con =
                    DBConnection.getConnection();

            Statement st =
                    con.createStatement();

            ResultSet rs =
                    st.executeQuery(
                            "select * from employee_leave"
                    );

            while(rs.next()) {

                area.append(
                        "Employee ID : "
                        + rs.getInt("employee_id")
                        + "\n"
                );

                area.append(
                        "Leave Reason : "
                        + rs.getString("leave_reason")
                        + "\n"
                );

                area.append(
                        "Leave Days : "
                        + rs.getInt("leave_days")
                        + "\n"
                );

                area.append(
                        "Leave Status : "
                        + rs.getString("leave_status")
                        + "\n"
                );

                area.append(
                        "\n-------------------------\n\n"
                );
            }

            con.close();
        }

        catch(Exception e) {

            System.out.println(e);
        }

        setVisible(true);
    }
}