Display Records From Database Using JTable in Java

 For inserting values in Data Base ClickHere

What is JTable

JTable is a java swing component used to display records in tabular form.

Libraries :

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableModel;

Steps :

create a connection:

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root", "root");
        

Add prepared statement:

PreparedStatement pst = con.prepareStatement("select * from regis");

Create Result set:

The object of Result Set maintains a cursor pointing to a row of a table. Initially, cursor points to before the first row.

ResultSet rs = pst.executeQuery();

Get values from DataBase:

while(rs.next()){
  String name = rs.getString("Name");
  String id = rs.getString("Id");
  String roll = rs .getString("Roll");
  String position = rs.getString("position");
             }

Store values in array:

Object obj[] = {name,id,roll,position};

Add row into Tables:

 model = (DefaultTableModel)tbl_data.getModel();
 model.addRow(obj);

Clear previous values from table:

public void clearTable(){
         DefaultTableModel model = null;
         model = (DefaultTableModel) tbl_data.getModel();
         model.setRowCount(0);
     }

set value In JTable from Database 

Example :

 

 public void set_member_data(){
         DefaultTableModel model = null;
         try{
             Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student","root", "root");
             PreparedStatement pst = con.prepareStatement("select * from regis");
             ResultSet rs = pst.executeQuery();
             while(rs.next()){
             String name = rs.getString("Name");
             String id = rs.getString("Id");
             String roll = rs .getString("Roll");
             String position = rs.getString("position");
             
             Object obj[] = {name,id,roll,position};
             model = (DefaultTableModel)tbl_data.getModel();
             model.addRow(obj);
             }   
             }
         catch(Exception e){
             
         }
     }
     public void clearTable(){
         DefaultTableModel model = null;
         model = (DefaultTableModel) tbl_data.getModel();
         model.setRowCount(0);
     }