ViewProjectsFrame.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.JLabel;

import java.awt.Font;

public class TotalEmployeesFrame extends JFrame {

    public TotalEmployeesFrame() {

        setTitle("Total Employees");

        setSize(500,300);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE);

        JLabel titleLabel =
                new JLabel("TOTAL EMPLOYEES");

        titleLabel.setBounds(
                120,
                30,
                300,
                40);

        titleLabel.setFont(
                new Font(
                        "Arial",
                        Font.BOLD,
                        24));

        add(titleLabel);

        JLabel countLabel =
                new JLabel(
                        "Employee Count : 0"
                );
        try {

            Connection con =
                    DBConnection.getConnection();

            String query =
                    "select count(*) from employee";

            PreparedStatement ps =
                    con.prepareStatement(query);

            ResultSet rs =
                    ps.executeQuery();

            if(rs.next()) {

                countLabel.setText(

                        "Employee Count : "
                        + rs.getInt(1)
                );
            }
        }

        catch(Exception e) {

            System.out.println(e);
        }

        countLabel.setBounds(
                140,
                120,
                250,
                30);

        countLabel.setFont(
                new Font(
                        "Arial",
                        Font.PLAIN,
                        18));

        add(countLabel);

        setVisible(true);
    }
}