TopPerformerFrame.java

package com.ems.gui.employee;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.ems.db.DBConnection;
import javax.swing.JFrame;
import javax.swing.JScrollPane;
import javax.swing.JTable;

public class DisplayEmployeeFrame extends JFrame {

    public DisplayEmployeeFrame() {

        setTitle("Display Employees");

        setSize(900, 500);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE);

        String columnNames[] = {
                "ID",
                "Name",
                "Salary",
                "Department",
                "Designation",
                "Email",
                "Phone"
        };

        javax.swing.table.DefaultTableModel model =
                new javax.swing.table.DefaultTableModel(
                        columnNames,
                        0
                );

        JTable table =
                new JTable(model);
        try {

            Connection con =
                    DBConnection.getConnection();

            String query =
                    "select * from employee";

            PreparedStatement ps =
                    con.prepareStatement(query);

            ResultSet rs =
                    ps.executeQuery();

            while(rs.next()) {

                Object row[] = {

                        rs.getInt("employee_id"),

                        rs.getString("name"),

                        rs.getDouble("salary"),

                        rs.getString("department"),

                        rs.getString("designation"),

                        rs.getString("email"),

                        rs.getString("phone_number")
                };

                model.addRow(row);
            }
        }

        catch(Exception e) {

            System.out.println(e);
        }
        JScrollPane scrollPane =
                new JScrollPane(table);

        scrollPane.setBounds(
                20,
                20,
                840,
                400);

        add(scrollPane);

        setVisible(true);
    }
}