Updated: Dynamic TableView Data From Database

Updated in: Aug 5, 2014 @ 12:50 by Narayan [This update is compatible with new Java 8 codes modified]

Hello, Today I’m going to show the demo of how to display the exact database data in JavaFX 2.0 from TableView. I call this TableView as Dynamic TableView because the tableview automatically manages the columns and rows.

Requirements of this demo:

Database Structure
This below give the structure of database table I used for sample.

Customer Table
+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| col0           | int(11)      | NO   | PRI | NULL    | auto_increment |
| col1           | varchar(200) | NO   |     | NULL    |                |
| col2       | int(4)       | NO   |     | NULL    |                |
+----------------+--------------+------+-----+---------+----------------+

Customer Table

+----------------+--------------+------+-----+---------+----------------+

+----------------+--------------+------+-----+---------+----------------+

| col0 | int(11) | NO | PRI | NULL | auto_increment |

| col1 | varchar(200) | NO | | NULL | |

| col2 | int(4) | NO | | NULL | |

+----------------+--------------+------+-----+---------+----------------+

JavaFX 2.0 SourceCode
Main GUIClass

This class consists all the GUI Components and the data are being extracted from database

import java.sql.Connection;
import java.sql.ResultSet;
import javafx.application.Application;
import javafx.application.Platform;
import javafx.beans.property.SimpleStringProperty;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.EventHandler;
import javafx.scene.Scene;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableColumn.CellDataFeatures;
import javafx.scene.control.TableView;
import javafx.stage.Stage;
import javafx.stage.WindowEvent;
import javafx.util.Callback;

/**
 *
 * @author Narayan
 */
public class DynamicTable extends Application {

    //TABLE VIEW AND DATA
    private ObservableList<ObservableList> data;

    private TableView tableview;

    //MAIN EXECUTOR
    public static void main(String[] args) {
        launch(args);
    }

    //CONNECTION DATABASE
    public void buildData() {
        Connection c;
        data = FXCollections.observableArrayList();
        try {
            c = DBConnect.connect();
            //SQL FOR SELECTING ALL OF CUSTOMER
            String SQL = "SELECT * from CUSTOMER";
            //ResultSet
            ResultSet rs = c.createStatement().executeQuery(SQL);

            /**
             * ********************************
             * TABLE COLUMN ADDED DYNAMICALLY *
             *********************************
             */
            for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {
                //We are using non property style for making dynamic table
                final int j = i;
                TableColumn col = new TableColumn(rs.getMetaData().getColumnName(i + 1));
                col.setCellValueFactory(new Callback<CellDataFeatures<ObservableList, String>, ObservableValue<String>>() {
                    public ObservableValue<String> call(CellDataFeatures<ObservableList, String> param) {
                        return new SimpleStringProperty(param.getValue().get(j).toString());
                    }
                });

                tableview.getColumns().addAll(col);
                System.out.println("Column [" + i + "] ");
            }

            /**
             * ******************************
             * Data added to ObservableList *
             *******************************
             */
            while (rs.next()) {
                //Iterate Row
                ObservableList<String> row = FXCollections.observableArrayList();
                for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
                    //Iterate Column
                    row.add(rs.getString(i));
                }
                System.out.println("Row [1] added " + row);
                data.add(row);

            }

            //FINALLY ADDED TO TableView
            tableview.setItems(data);
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Error on Building Data");
        }
    }

    @Override
    public void start(Stage stage) throws Exception {
        //TableView
        tableview = new TableView();
        buildData();

        //Main Scene
        Scene scene = new Scene(tableview);

        stage.setScene(scene);
        stage.setOnCloseRequest(new EventHandler<WindowEvent>() {
            @Override
            public void handle(WindowEvent event) {
                Platform.exit();
                System.exit(0);
            }
        });
        stage.show();
    }
}

100

101

102

103

104

105

106

107

108

import java.sql.Connection;

import java.sql.ResultSet;

import javafx.application.Application;

import javafx.application.Platform;

import javafx.beans.property.SimpleStringProperty;

import javafx.beans.value.ObservableValue;

import javafx.collections.FXCollections;

import javafx.collections.ObservableList;

import javafx.event.EventHandler;

import javafx.scene.Scene;

import javafx.scene.control.TableColumn;

import javafx.scene.control.TableColumn.CellDataFeatures;

import javafx.scene.control.TableView;

import javafx.stage.Stage;

import javafx.stage.WindowEvent;

import javafx.util.Callback;

/**

* @author Narayan

public class DynamicTable extends Application {

//TABLE VIEW AND DATA

private ObservableList<ObservableList> data;

private TableView tableview;

//MAIN EXECUTOR

public static void main(String[] args) {

launch(args);

}

//CONNECTION DATABASE

public void buildData() {

Connection c;

data = FXCollections.observableArrayList();

try {

c = DBConnect.connect();

//SQL FOR SELECTING ALL OF CUSTOMER

String SQL = "SELECT * from CUSTOMER";

//ResultSet

ResultSet rs = c.createStatement().executeQuery(SQL);

/**

* ********************************

* TABLE COLUMN ADDED DYNAMICALLY *

*********************************

for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {

//We are using non property style for making dynamic table

final int j = i;

TableColumn col = new TableColumn(rs.getMetaData().getColumnName(i + 1));

col.setCellValueFactory(new Callback<CellDataFeatures<ObservableList, String>, ObservableValue<String>>() {

public ObservableValue<String> call(CellDataFeatures<ObservableList, String> param) {

return new SimpleStringProperty(param.getValue().get(j).toString());

}

});

tableview.getColumns().addAll(col);

System.out.println("Column [" + i + "] ");

}

/**

* ******************************

* Data added to ObservableList *

*******************************

while (rs.next()) {

//Iterate Row

ObservableList<String> row = FXCollections.observableArrayList();

for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {

//Iterate Column

row.add(rs.getString(i));

}

System.out.println("Row [1] added " + row);

data.add(row);

}

//FINALLY ADDED TO TableView

tableview.setItems(data);

} catch (Exception e) {

e.printStackTrace();

System.out.println("Error on Building Data");

}

@Override

public void start(Stage stage) throws Exception {

//TableView

tableview = new TableView();

buildData();

//Main Scene

Scene scene = new Scene(tableview);

stage.setScene(scene);

stage.setOnCloseRequest(new EventHandler<WindowEvent>() {

@Override

public void handle(WindowEvent event) {

Platform.exit();

System.exit(0);

}

});

stage.show();

}

Here I used ObservableList< ObservableList > ‘data’ for keeping the records so that I could add data of Rows and Columns.The above class makes a dynamic TableView extracted data from Database.

Database Connectivity Class

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/**
 * 
 * @author Narayan
 */

public class DBConnect {

    private static Connection conn;
    private static String url = "jdbc:mysql://localhost/test";
    private static String user = "root";
    private static String pass = "rootp@$$";

    public static Connection connect() throws SQLException{
        try{
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        }catch(ClassNotFoundException cnfe){
            System.err.println("Error: "+cnfe.getMessage());
        }catch(InstantiationException ie){
            System.err.println("Error: "+ie.getMessage());
        }catch(IllegalAccessException iae){
            System.err.println("Error: "+iae.getMessage());
        }

        conn = DriverManager.getConnection(url,user,pass);
        return conn;
    }
    public static Connection getConnection() throws SQLException, ClassNotFoundException{
        if(conn !=null && !conn.isClosed())
            return conn;
        connect();
        return conn;

    }
}

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

/**

* @author Narayan

public class DBConnect {

private static Connection conn;

private static String url = "jdbc:mysql://localhost/test";

private static String user = "root";

private static String pass = "rootp@$$";

public static Connection connect() throws SQLException{

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

}catch(ClassNotFoundException cnfe){

System.err.println("Error: "+cnfe.getMessage());

}catch(InstantiationException ie){

System.err.println("Error: "+ie.getMessage());

}catch(IllegalAccessException iae){

System.err.println("Error: "+iae.getMessage());

}

conn = DriverManager.getConnection(url,user,pass);

return conn;

}

public static Connection getConnection() throws SQLException, ClassNotFoundException{

if(conn !=null && !conn.isClosed())

return conn;

connect();

return conn;

}

In above class the url,user,pass may varies according to your mysql configuration.

Output:

TableView From Database

Here you go the output depends upon the database queries.

All the source code are published in a github repository : https://github.com/privatejava/javafx-dynamic-tableview

Don’t hesitate on commenting your views.
Thanks for viewing Hava a 🙂 good day.

This entry was posted on October 19, 2011, 12:50 pm and is filed under JavaFX, JavaFX 2.0. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.

#1 by Narayan G. Maharjan on November 6, 2017 - 12:36 pm

Quote

Hi,
Thank you for reminding the bug. I have just fixed that issue 🙂 .

Thanks

#2 by nickraz on December 18, 2017 - 7:58 pm

ObservableList cannot be converted to ObservableList

#3 by Priyanka on March 16, 2018 - 8:07 am

hello,
I am getting this error it can not be string why?

#4 by Vinod on April 5, 2018 - 1:10 pm

It works awsm… thanks

#5 by Meena on June 20, 2018 - 5:21 pm

The below part of code never works for me, I am not getting any values in TableView for rows. I am getting only column names inside the table.

while(rs.next()){
ObservableList row = FXCollections.observableArrayList();
for(int i=1 ; i<=rs.getMetaData().getColumnCount(); i++){
row.add(rs.getString(i));
}
System.out.println(row );
data.add(row);
}
//FINALLY ADDED TO TableView
tableview.setItems(data);

#6 by Narayan G. Maharjan on June 20, 2018 - 11:59 pm

Hi Meena,
Do you have any data in that tables ?

If you need to get start with this you can clone : https://github.com/privatejava/javafx-dynamic-tableview

#7 by Nicko on September 2, 2018 - 8:31 pm

Is it working in inner join ?

#8 by Narayan G. Maharjan on September 11, 2018 - 11:50 am

Yes you can

Java and FX

A perfect java blog