• get listivew as
   
• ListyView :
  ObservableList<String> oString1 =
  FXCollections.<String>observableArrayList(ext1.list1);
  ListView<String> lvwList = new ListView<>(oString1);
• ComboBox
  ObservableList<String> oString1 =
  FXCollections.<String>observableArrayList(ext1.list1);
  ComboBox<String> CBox1 = new ComboBox(oString1);
   

package javafxtemplate1;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.application.Application;
import javafx.application.Platform;
import javafx.beans.property.SimpleIntegerProperty;
import javafx.beans.value.ObservableValue;
//import javafx.beans.property.SimpleStringProperty;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ComboBox;
import javafx.scene.control.Label;
import javafx.scene.control.ListView;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableColumn.CellDataFeatures;
import javafx.scene.control.TableColumn.CellEditEvent;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.scene.control.cell.TextFieldTableCell;
import javafx.scene.layout.VBox;
import javafx.stage.Stage;
import javafx.util.Callback;



public class JavaFXTemplate1 extends Application {
private ExternalClass1 ext1 = new ExternalClass1();

@Override
public void start(Stage primaryStage) throws Exception {
Group groot = new Group();
ExternalClass1 ext1 = new ExternalClass1();
ext1.loaddata();// to populate strings in exyternalcl;ass1
//
// working on combox/listView
ObservableList<String> oString1 =
FXCollections.<String>observableArrayList(ext1.list1);
ComboBox<String> CBox1 = new ComboBox(oString1);
ListView<String> lvwList = new ListView<>(oString1);
lvwList.setLayoutX(10); lvwList.setLayoutY(80);
lvwList.setMaxWidth(100);
//
CBox1.setLayoutX(110);CBox1.setLayoutY(80);
CBox1.setMaxWidth(100);

//

primaryStage.setWidth(300);
primaryStage.setHeight(250);
Label label1 = new Label("fname");
Label label2 = new Label("lname");
Label label3= new Label("Age");
Label label4 = new Label("caption1");
Label label5 = new Label("caption2");
Label label6 = new Label("caption3");

Button exitbtn = new Button("Exit Platform");
exitbtn.setOnAction(new DemoEventHandler1(){ });
Button btn1 = new Button("Display Data ");
btn1.setOnAction((ActionEvent e) -> {
label4.setText(ExternalClass1.str1);
label5.setText(ExternalClass1.str2);
label6.setText(ExternalClass1.str3);
});
//future linked data with labels
CBox1.setOnAction((ActionEvent e) -> {
label4.setText(ExternalClass1.str1);
label5.setText(ExternalClass1.str2);
label6.setText(ExternalClass1.str3);
});
//
exitbtn.setLayoutX(10);exitbtn.setLayoutY(10);
btn1.setLayoutX(150);btn1.setLayoutY(10);
label1.setLayoutX(10);label1.setLayoutY(40);
label2.setLayoutX(80);label2.setLayoutY(40);
label3.setLayoutX(160);label3.setLayoutY(40);
label4.setLayoutX(10);label4.setLayoutY(60);
label5.setLayoutX(80);label5.setLayoutY(60);
label6.setLayoutX(160);label6.setLayoutY(60);

//
groot.getChildren().addAll(label1,label2, label3,
label4,label5, label6,btn1, exitbtn, lvwList,CBox1 );
//
Scene scene = new Scene(groot, 350, 150);
primaryStage.setScene(scene);
primaryStage.setTitle("PostgreSQL:: UIControl");
primaryStage.show();

}



public static void main(String[] args) throws SQLException {

launch(args);
}
}
class DemoEventHandler1 implements EventHandler<ActionEvent>{

@Override
public void handle(ActionEvent event) {
Platform.exit();

}
}
//code ExternalClass1
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package javafxtemplate1;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


/**
*
* @author Manas9
*/
public class ExternalClass1 {
public static String str1, str2, str3; public int n1;
// call ExtrenalClass2 prior to Externalclass1
ExternalClass2 extclass = new ExternalClass2();
private static Connection conn;
public List list1 = new ArrayList();
public void loaddata() throws SQLException
{
// Connection
Connection connect = extclass.createConnection();
String query = " SELECT * FROM pgsvisitor1b where id=102";
Statement st = null;// query statement support
ResultSet rs = null;// active connection database result
//
try {
st = connect.createStatement(); rs = st.executeQuery(query);
while(rs.next())
{
str1 = rs.getString("fname");
str2 =rs.getString("lname");
str3 = Integer.toString(rs.getInt("age"));
//
list1.add( str1);
list1.add(str2);
list1.add( str3);
}
} catch (Exception e) {
System.out.println(e.toString());
}
//return str3;
}


}
//ExternalClass2
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package javafxtemplate1;

import java.sql.Connection;
import java.sql.DriverManager;

/**
*
* @author Manas9
*/
public class ExternalClass2 {
Connection cnn= null;
String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
String user = "postgres"; String pwd = "postgre_manas9";
// Creating a function to get a connection
public Connection createConnection() {
System.out.println("Connection Object Created");
// checking connection
if (cnn != null) {
System.out.println("Can't creaate a connection");
return cnn;
} else {
try {
// Getting connection
cnn = DriverManager.getConnection(dbURL,user,pwd);
} catch (Exception e) {
System.out.println(e.toString());
}
}
return cnn;
}

}