Use table show data from MySQL in java programming (V95)

How to Use a Table

Example: Using a Table to Display Data from MySQL with 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();
        }
    }

    public void clearFields() {
        txtID.setText("");
        txtName.setText("");
        txtGender.setText("");
        txtAddress.setText("");
        txtPhone.setText("");
        txtID.requestFocus();
    }   

    public void loadTable() {
        try {
            pst = conn.prepareStatement("SELECT * FROM students");
            rs = pst.executeQuery();

            DefaultTableModel model = (DefaultTableModel) tblStudents.getModel();
            model.setRowCount(0); // clear old data

            while (rs.next()) {
                model.addRow(new Object[]{
                    rs.getInt("id"),
                    rs.getString("name"),
                    rs.getString("gender"),
                    rs.getString("address"),
                    rs.getString("phone")
                });
            }

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

    private void btnClearActionPerformed(java.awt.event.ActionEvent evt) {                                         
        clearFields();
    }  

    private void tblStudentsMouseClicked(java.awt.event.MouseEvent evt) {                                         
        DefaultTableModel model = (DefaultTableModel) tblStudents.getModel();
        int selectedRow = tblStudents.getSelectedRow();

        txtID.setText(model.getValueAt(selectedRow, 0).toString());
        txtName.setText(model.getValueAt(selectedRow, 1).toString());
        txtGender.setText(model.getValueAt(selectedRow, 2).toString());
        txtAddress.setText(model.getValueAt(selectedRow, 3).toString());
        txtPhone.setText(model.getValueAt(selectedRow, 4).toString());
    }                                                                                                                                                                  

Result:

Watch the video:

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