SearchDepartmentFrame.java

package com.ems.gui.analytics;

import javax.swing.JFrame;
import javax.swing.JLabel;

import java.awt.Font;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.ems.db.DBConnection;

public class LowestAttendanceFrame extends JFrame {

    public LowestAttendanceFrame() {

        setTitle("Lowest Attendance Employee");

        setSize(600,300);

        setLocationRelativeTo(null);

        setLayout(null);

        JLabel label =
                new JLabel();

        label.setBounds(
                50,
                100,
                500,
                30);

        label.setFont(
                new Font(
                        "Arial",
                        Font.BOLD,
                        18));

        add(label);

        try {

            Connection con =
                    DBConnection.getConnection();

            String query =
                    "select name,attendance from employee order by attendance asc limit 1";

            PreparedStatement ps =
                    con.prepareStatement(query);

            ResultSet rs =
                    ps.executeQuery();

            if(rs.next()) {

                label.setText(
                        "Lowest Employee : "
                        + rs.getString("name")
                        + " | Attendance : "
                        + rs.getInt("attendance")
                );
            }

            con.close();
        }

        catch(Exception e) {

            System.out.println(e);
        }

        setVisible(true);
    }
}