JDBC INPUT ID, NAME, JOB_TITLE, SALARY STORE MYSQL WORKBENCH

                                                    JDBC  PROJECT      

                                INPUT ID, NAME, JOB_TITLE, SALARY 

                                                    STORE MYSQL

WORK BENCH QUERY

SOURCE CODE 

 import javax.swing.*;

import java.awt.*;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

public class InsertData extends JFrame implements ActionListener {

    private JTextField idField, nameField, jobTitleField, salaryField;

    private JButton submitButton;

    public InsertData() {

        setTitle("Data Storage Application");

        setSize(400, 200);

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        setLayout(new FlowLayout());

        idField = new JTextField(10);

        nameField = new JTextField(20);

        jobTitleField = new JTextField(20);

        salaryField = new JTextField(10);

        submitButton = new JButton("Submit");

        submitButton.addActionListener(this);

        add(new JLabel("ID: "));

        add(idField);

        add(new JLabel("Name: "));

        add(nameField);

        add(new JLabel("Job Title: "));

        add(jobTitleField);

        add(new JLabel("Salary: "));

        add(salaryField);

        add(submitButton);

    }

    @Override

    public void actionPerformed(ActionEvent e) {

        String id = idField.getText();

        String name = nameField.getText();

        String jobTitle = jobTitleField.getText();

        String salary = salaryField.getText();

        // Store data in SQL database

        try (Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "SUDHIR")) {

            String query = "INSERT INTO employee (id, name, job_title, salary) VALUES (?, ?, ?, ?)";

            PreparedStatement preparedStatement = connection.prepareStatement(query);

            preparedStatement.setString(1, id);

            preparedStatement.setString(2, name);

            preparedStatement.setString(3, jobTitle);

            preparedStatement.setString(4, salary);

            preparedStatement.executeUpdate();

            JOptionPane.showMessageDialog(this, "Data inserted successfully.");

        } catch (SQLException ex) {

            ex.printStackTrace();

            JOptionPane.showMessageDialog(this, "Failed to insert data: " + ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);

        }

        // Clear fields after submission

        idField.setText("");

        nameField.setText("");

        jobTitleField.setText("");

        salaryField.setText("");

    }

    public static void main(String[] args) {

        SwingUtilities.invokeLater(() -> {

            InsertData frame = new InsertData();

            frame.setVisible(true);

        });

    }

}