UpdateSalaryFrame.java

package com.ems.gui.performance;

import javax.swing.*;
import java.sql.*;

import com.ems.db.DBConnection;

public class TopPerformerFrame extends JFrame {

    public TopPerformerFrame() {

        setTitle("Top Performer");

        setSize(500,300);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE
        );

        try {

            Connection con =
                    DBConnection.getConnection();

            String query =
                    "select * from employee_performance "
                    + "order by performance_rating desc limit 1";

            PreparedStatement ps =
                    con.prepareStatement(query);

            ResultSet rs =
                    ps.executeQuery();

            if(rs.next()) {

                JTextArea area =
                        new JTextArea();

                area.setBounds(
                        30,
                        30,
                        400,
                        180
                );

                area.setText(

                        "Employee ID : "
                        + rs.getInt("employee_id")

                        + "\n\nPerformance Rating : "

                        + rs.getDouble(
                                "performance_rating"
                        )

                        + "\n\nPerformance Remark : "

                        + rs.getString(
                                "performance_remark"
                        )
                );

                add(area);
            }

            con.close();

        } catch(Exception e) {

            JOptionPane.showMessageDialog(
                    null,
                    e.getMessage()
            );
        }

        setVisible(true);
    }
}