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.beans.property.SimpleStringProperty;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
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.util.Callback;

/**
 * 
 * @author Narayan
 */

public class DynamicTable extends Application{

    //TABLE VIEW AND DATA
    private ObservableList&lt;ObservableList&gt; 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&lt;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&lt;CellDataFeatures&lt;ObservableList,String&gt;,ObservableValue&lt;String&gt;&gt;(){                    
                    public ObservableValue&lt;String&gt; call(CellDataFeatures&lt;ObservableList, String&gt; 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&lt;String&gt; row = FXCollections.observableArrayList();
                for(int i=1 ; i&lt;=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.show();
      }
}

import java.sql.Connection;

import java.sql.ResultSet;

import javafx.application.Application;

import javafx.beans.property.SimpleStringProperty;

import javafx.beans.value.ObservableValue;

import javafx.collections.FXCollections;

import javafx.collections.ObservableList;

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.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.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/company";
    private static String user = "root";
    private static String pass = "root";

    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 &amp;&amp; !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/company";

private static String user = "root";

private static String pass = "root";

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.
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

Java and FX

A perfect java blog