PerformanceFrame.java

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

import javax.swing.JOptionPane;

import com.ems.db.DBConnection;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JButton;

import java.awt.Font;

public class DeleteEmployeeFrame extends JFrame {

    public DeleteEmployeeFrame() {

        setTitle("Delete Employee");

        setSize(600, 400);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE);

        JLabel titleLabel =
                new JLabel("DELETE EMPLOYEE");

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

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

        add(titleLabel);

        JLabel idLabel =
                new JLabel("Employee ID");

        idLabel.setBounds(
                100,
                120,
                100,
                30);

        add(idLabel);

        JTextField idField =
                new JTextField();

        idField.setBounds(
                220,
                120,
                180,
                30);

        add(idField);

        JButton deleteButton =
                new JButton("Delete");

        deleteButton.setBounds(
                220,
                200,
                120,
                35);

        add(deleteButton);
        deleteButton.addActionListener(

        	    e -> {

        	        try {

        	            int id =
        	                    Integer.parseInt(
        	                            idField.getText()
        	                    );

        	            Connection con =
        	                    DBConnection.getConnection();

        	            String query =
        	                    "delete from employee where employee_id=?";

        	            PreparedStatement ps =
        	                    con.prepareStatement(query);

        	            ps.setInt(1, id);

        	            int rows =
        	                    ps.executeUpdate();

        	            if(rows > 0) {

        	                JOptionPane.showMessageDialog(
        	                        null,
        	                        "Employee Deleted Successfully"
        	                );

        	                idField.setText("");
        	            }

        	            else {

        	                JOptionPane.showMessageDialog(
        	                        null,
        	                        "Employee Not Found"
        	                );
        	            }

        	        }

        	        catch(Exception ex) {

        	            System.out.println(ex);
        	        }

        	    }
        	);

        setVisible(true);
    }
}