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 opn combox ObservableList oString1 = FXCollections.observableArrayList(ext1.list1); ComboBox CBox1 = new ComboBox(oString1); ListView lvwList = new ListView<>(oString1); lvwList.setLayoutX(10); lvwList.setLayoutY(80); // 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); }); // 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); // 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{ @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); //will have "Hello World" Text } //str3 = str1; } catch (Exception e) { System.out.println(e.toString()); } //return str3; } } // Code 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; } }