AddPerformanceFrame.java

package com.ems.gui.employee;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.JOptionPane;

import com.ems.db.DBConnection;

import java.sql.Connection;
import java.sql.PreparedStatement;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
import javax.swing.JButton;

import java.awt.Font;

public class AddEmployeeFrame extends JFrame {
	JTextField idField;

	JTextField nameField;

	JTextField salaryField;

	JTextField departmentField;

	JTextField designationField;

	JTextField emailField;

	JTextField phoneField;

    public AddEmployeeFrame() {

        setTitle("Add Employee");

        setSize(700, 700);

        setLocationRelativeTo(null);

        setLayout(null);

        setDefaultCloseOperation(
            JFrame.DISPOSE_ON_CLOSE
        );

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

        titleLabel.setBounds(
            220,
            20,
            300,
            40
        );

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

        add(titleLabel);

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

        idLabel.setBounds(
            80,
            100,
            150,
            30
        );

        add(idLabel);

        idField =
        	    new JTextField();

        	idField.setBounds(
        	    250,
        	    100,
        	    250,
        	    30
        	);

        	add(idField);

        JLabel nameLabel =
            new JLabel("Employee Name");

        nameLabel.setBounds(
            80,
            150,
            150,
            30
        );

        add(nameLabel);

        nameField =
        	    new JTextField();

        	nameField.setBounds(
        	    250,
        	    150,
        	    250,
        	    30
        	);

        	add(nameField);

        JLabel salaryLabel =
            new JLabel("Salary");

        salaryLabel.setBounds(
            80,
            200,
            150,
            30
        );

        add(salaryLabel);

        salaryField =
        	    new JTextField();

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

        	add(salaryField);

        JLabel departmentLabel =
            new JLabel("Department");

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

        add(departmentLabel);

        departmentField =
        	    new JTextField();

        	departmentField.setBounds(
        	    250,
        	    250,
        	    250,
        	    30
        	);

        	add(departmentField);

        JLabel designationLabel =
            new JLabel("Designation");

        designationLabel.setBounds(
            80,
            300,
            150,
            30
        );

        add(designationLabel);

        designationField =
        	    new JTextField();

        	designationField.setBounds(
        	    250,
        	    300,
        	    250,
        	    30
        	);

        	add(designationField);

        JLabel emailLabel =
            new JLabel("Email");

        emailLabel.setBounds(
            80,
            350,
            150,
            30
        );

        add(emailLabel);

        emailField =
        	    new JTextField();

        	emailField.setBounds(
        	    250,
        	    350,
        	    250,
        	    30
        	);

        	add(emailField);

        JLabel phoneLabel =
            new JLabel("Phone Number");

        phoneLabel.setBounds(
            80,
            400,
            150,
            30
        );

        add(phoneLabel);

        phoneField =
        	    new JTextField();

        	phoneField.setBounds(
        	    250,
        	    400,
        	    250,
        	    30
        	);

        	add(phoneField);

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

        addButton.setBounds(
            220,
            500,
            200,
            40
        );

        add(addButton);
        addButton.addActionListener(

        	    new ActionListener() {

        	        public void actionPerformed(
        	            ActionEvent e
        	        ) {

        	            try {

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

        	                String employeeName =
        	                    nameField.getText();

        	                double salary =
        	                    Double.parseDouble(
        	                        salaryField.getText()
        	                    );

        	                String department =
        	                    departmentField.getText();

        	                String designation =
        	                    designationField.getText();

        	                String email =
        	                    emailField.getText();

        	                String phone =
        	                    phoneField.getText();

        	                Connection con =
        	                    DBConnection.getConnection();

        	                String query =
        	                    "insert into employee "
        	                    + "(employee_id,name,salary,"
        	                    + "department,designation,"
        	                    + "email,phone_number)"
        	                    + " values(?,?,?,?,?,?,?)";

        	                PreparedStatement ps =
        	                    con.prepareStatement(query);

        	                ps.setInt(
        	                    1,
        	                    employeeId
        	                );

        	                ps.setString(
        	                    2,
        	                    employeeName
        	                );

        	                ps.setDouble(
        	                    3,
        	                    salary
        	                );

        	                ps.setString(
        	                    4,
        	                    department
        	                );

        	                ps.setString(
        	                    5,
        	                    designation
        	                );

        	                ps.setString(
        	                    6,
        	                    email
        	                );

        	                ps.setString(
        	                    7,
        	                    phone
        	                );

        	                ps.executeUpdate();

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

        	            }

        	            catch(Exception ex) {

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

        setVisible(true);
    }
}