Insert, Update, And Delete Records In Java

This blog demonstrates the CRUD operations in Java using the JDBC (Java Database Connectivity) into MySQL database using NetBeans IDE.

Introduction

 

MySQL is an RDBMS (Relational Database Management System) database. In this blog, we will learn using JDBC (Java Database Connectivity) to insert, update and delete data into MySQL database using the NetBeans IDE.

 

student.sql 

--Go to MySql database and click on Import tab click on Browse button and select this file(student.sql)
create database Studentinformation;
use Studentinformation;
create table student(roll int(3) primary key, name varchar(20), marks int(3));

STEP 1

 

Open the NetBeans IDE. Click on File -> New Project, select the Java category; from Projects, select Java Application. Click on the "Next" button.

 

 

 

STEP 2

 

Enter your project name and uncheck "Create Main Class" then click the "Finish" button.

 

STEP 3

 

Expand your project folder and right-click on the Libraries folder and click "Add Library…".

 

Select the "JDBC MYSQL Driver" click on the "Add Library" button.

 

 

 

STEP 4

 

Right-click on the project folder and go to New -> JFrame Form and enter your Class Name. Now, click the "Finish" button.

 

 

 

STEP 5

 

Drag and drop three jLabel, three JTextField, and three button fields. Now, change the jLabel text and the button text like in the below image.

 

 

 

STEP 6

 

Click on the "Source" button just beside the "Design" button.

// Import these package
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
// Create Referesh Method
public void Referesh() {
    jTextField1.setText("");
    jTextField2.setText("");
    jTextField3.setText("");
}

Insert

 

Right-click on the "Insert" button. Go to Event -> action -> actionPerformed and add the below code.

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    try {
        Class.forName("com.mysql.jdbc.Driver");
        // establish connection
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Studentinformation", "root", "");
        Statement statement = con.createStatement();
        statement.executeUpdate("INSERT INTO student VALUES(" + jTextField1.getText() + ",'" + jTextField2.getText() + "'," + jTextField3.getText() + ")");
        JOptionPane.showMessageDialog(null, "Record inserted...");
        statement.close();
        con.close();
        Referesh(); //Calling Referesh() method
    } catch (SQLException | ClassNotFoundException e) {
        JOptionPane.showMessageDialog(null, e);
    }
}

Update

 

Right-click the "Update" button. Go to Event -> action -> actionPerformed and add the below code.

private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    try {
        Class.forName("com.mysql.jdbc.Driver");
        // establish connection
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Studentinformation", "root", "");
        Statement stmt = con.createStatement();
        stmt.execute("UPDATE student SET name='" + jTextField2.getText() + "',marks=" + jTextField3.getText() + " WHERE roll=" + jTextField1.getText() + "");
        JOptionPane.showMessageDialog(null, "Record is updated...");
        stmt.close();
        con.close();
        Referesh(); //Calling Referesh() method
    } catch (SQLException | ClassNotFoundException se) {
        JOptionPane.showMessageDialog(null, se);
    }
}

Delete 

 

Right-click the "Delete" button. Go to Event -> action -> actionPerformed and add the below code.

private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {
    try {
        Class.forName("com.mysql.jdbc.Driver");
        // establish connection
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/Studentinformation", "root", "");
        Statement statement = con.createStatement();
        statement.executeUpdate("DELETE FROM student WHERE roll=" + jTextField1.getText() + "");
        JOptionPane.showMessageDialog(null, "Record deleted...");
        statement.close();
        con.close();
        Referesh(); //Calling Referesh() method
    } catch (SQLException | ClassNotFoundException e) {
        JOptionPane.showMessageDialog(null, e);
    }
}

STEP 6

 

Now, your project is completed. Run (F6) the project.

 

 

 

In this blog, I covered MySQL database operations (Insert, Update and Delete) with JDBC using NetBeans IDE. If you have any problem, please comment.