List_ListView_PgSQL1
  • List :: Java Collection as data handler, is an ordered collection of objects
  • public List list1 = new ArrayList();
    public void loaddata() throws SQLException
     
  • public List list1 = new ArrayList();
    list1.add( str1);
    list1.add(str2);
    list1.add( str3);
  • This uses list object data-type in a remote class
    ObservableList<String> oString1 =
    FXCollections.<String>observableArrayList(ext1.list1);
  • The javafx.collections.ObservableList and javafx.collections.ObservableMap interfaces both extend  javafx.beans.Observable
  • In this Example List-Collection datatype is wrapped with ObservableList, and served a ListView  of JavaFX UI control

List to ListView

ObservableList<String> oString1, refers List Collection in ExternalClass1.

Code:List_ListView_PgSQL1.txt

package javafxtemplate1;

import java.sql.SQLException;
import javafx.application.Application;
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.geometry.Insets;
import javafx.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
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 {
//User Interface - display
private ExternalClass1B ext1 = new ExternalClass1B();
@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 opn combox
ObservableList<String> oString1 =
FXCollections.<String>observableArrayList(ext1.list1);
ListView<String> lvwList = new ListView<>(oString1);
lvwList.setLayoutX(10); lvwList.setLayoutY(80);
lvwList.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 btn1 = new Button("Display Data ");
Button exitbtn = new Button("Exit Platform");
exitbtn.setOnAction(new DemoEventHandler1(){ });
//
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);
exitbtn.setLayoutX(10);exitbtn.setLayoutY(10);
btn1.setLayoutX(150);btn1.setLayoutY(10);
btn1.setOnAction((ActionEvent e) -> {
label4.setText(ExternalClass1B.str1);
label5.setText(ExternalClass1B.str2);
label6.setText(ExternalClass1B.str3);
});
groot.getChildren().addAll(label1,label2, label3,
label4,label5, label6,btn1, exitbtn, lvwList);

Scene scene = new Scene(groot, 350, 150);
primaryStage.setScene(scene);
primaryStage.setTitle("PostgreSQL:: UIControl");
primaryStage.show();
}
public static void main(String[] args) {
launch(args);
}
}
class DemoEventHandler1 implements EventHandler<ActionEvent>{

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

}
}

//

// ExternalClass1B
public class ExternalClass1B {
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

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

}
 

 
 
Runtime Views:

Click on Display: