UpdateDepartmentFrame.java

package com.ems.gui.leave;

import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JOptionPane;

import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.Connection;
import java.sql.PreparedStatement;

import com.ems.db.DBConnection;

public class RejectLeaveFrame extends JFrame {

    JTextField employeeIdField;

    public RejectLeaveFrame() {

        setTitle("Reject Leave");

        setSize(600, 400);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
                JFrame.DISPOSE_ON_CLOSE
        );

        JLabel titleLabel =
                new JLabel("REJECT LEAVE");

        titleLabel.setBounds(
                170,
                40,
                300,
                40
        );

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

        add(titleLabel);

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

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

        add(idLabel);

        employeeIdField =
                new JTextField();

        employeeIdField.setBounds(
                250,
                140,
                180,
                30
        );

        add(employeeIdField);

        JButton rejectButton =
                new JButton(
                        "Reject Leave"
                );

        rejectButton.setBounds(
                200,
                240,
                180,
                40
        );

        add(rejectButton);

        rejectButton.addActionListener(

                new ActionListener() {

                    public void actionPerformed(
                            ActionEvent e) {

                        try {

                            int employeeId =
                                    Integer.parseInt(
                                            employeeIdField.getText()
                                    );

                            Connection con =
                                    DBConnection.getConnection();

                            String query =
                                    "update employee_leave set leave_status='Rejected' where employee_id=?";

                            PreparedStatement ps =
                                    con.prepareStatement(query);

                            ps.setInt(
                                    1,
                                    employeeId
                            );

                            int rows =
                                    ps.executeUpdate();

                            if(rows > 0) {

                                JOptionPane.showMessageDialog(
                                        null,
                                        "Leave Rejected Successfully"
                                );
                            }

                            else {

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

                            con.close();

                        }

                        catch(Exception ex) {

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

        setVisible(true);
    }
}