Update data from MySQL in java programming (V93)

How to Update Records

Updating Records in a database means modifying existing data in one or more rows of a table by using the SQL UPDATE statement.

Example: Updating Records in Java

Source Code:

Copied!

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import javax.swing.JOptionPane;

public class Insertstudent extends javax.swing.JFrame{

    Connection conn;
    PreparedStatement pst;
    ResultSet rs;

    public Insertstudents() {
        initComponents();
        connect();
    }

    public void connect() {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url = "jdbc:mysql://localhost/studentdb?useSSL=false&serverTimezone=Asia/Phnom_Penh";
            String user = "root";
            String pass = "root";
            conn = DriverManager.getConnection(url, user, pass);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    private void btnUpdateActionPerformed(java.awt.event.ActionEvent evt) {                                          
        String id = txtID.getText().trim();
        String name = txtName.getText().trim();
        String gender = txtGender.getText().trim();
        String address = txtAddress.getText().trim();
        String phone = txtPhone.getText().trim();

        if (id.isEmpty()) {
            JOptionPane.showMessageDialog(this, "Please enter ID to update");
            return;
        }

        try {
            PreparedStatement pst = conn.prepareStatement(
                "UPDATE students SET name=?, gender=?, address=?, phone=? WHERE id=?"
            );
            pst.setString(1, name);
            pst.setString(2, gender);
            pst.setString(3, address);
            pst.setString(4, phone);
            pst.setInt(5, Integer.parseInt(id));

            int k = pst.executeUpdate();
            if (k == 1) {
                JOptionPane.showMessageDialog(this, "Record Updated Successfully!");
                clearFields();
            } else {
                JOptionPane.showMessageDialog(this, "Record Not Found!");
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }                                                                                                                                                                

Result:

Watch the video:

Ebook: https://softkhpc.blogspot.com/2025/05/java-programming-ebooks.html