UpdateOperationsFrame.java

package com.ems.gui.performance;

import javax.swing.*;
import java.awt.Font;
import java.sql.Connection;
import java.sql.PreparedStatement;

import com.ems.db.DBConnection;

public class AddPerformanceFrame extends JFrame {

    JTextField employeeIdField;
    JTextField ratingField;
    JTextField remarkField;

    public AddPerformanceFrame() {

        setTitle("Add Performance");

        setSize(600,500);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

        JLabel titleLabel =
                new JLabel("ADD PERFORMANCE");

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

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

        add(titleLabel);

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

        employeeLabel.setBounds(80,130,120,30);

        add(employeeLabel);

        employeeIdField =
                new JTextField();

        employeeIdField.setBounds(250,130,200,30);

        add(employeeIdField);

        JLabel ratingLabel =
                new JLabel("Performance Rating");

        ratingLabel.setBounds(80,190,150,30);

        add(ratingLabel);

        ratingField =
                new JTextField();

        ratingField.setBounds(250,190,200,30);

        add(ratingField);

        JLabel remarkLabel =
                new JLabel("Performance Remark");

        remarkLabel.setBounds(80,250,150,30);

        add(remarkLabel);

        remarkField =
                new JTextField();

        remarkField.setBounds(250,250,200,30);

        add(remarkField);

        JButton addButton =
                new JButton("Add Performance");

        addButton.setBounds(200,340,180,40);

        add(addButton);

        addButton.addActionListener(e -> {

            try {

                Connection con =
                        DBConnection.getConnection();

                String query =
                        "insert into employee_performance values(?,?,?)";

                PreparedStatement ps =
                        con.prepareStatement(query);

                ps.setInt(
                        1,
                        Integer.parseInt(
                                employeeIdField.getText()
                        )
                );

                ps.setDouble(
                        2,
                        Double.parseDouble(
                                ratingField.getText()
                        )
                );

                ps.setString(
                        3,
                        remarkField.getText()
                );

                ps.executeUpdate();

                JOptionPane.showMessageDialog(
                        null,
                        "Performance Added Successfully"
                );

                con.close();

            } catch(Exception ex) {

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

        setVisible(true);
    }
}