uitableview加载MySQL数据_如何用数据库数据填充TableView

以下是从tableView中填充数据的最佳解决方案.

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

//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,ObservableValue>(){

public ObservableValue call(CellDataFeatures 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 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();

}

}

谢谢..