// 
package javafxtemplate1;

import java.sql.SQLException;
import javafx.application.Application;
import javafx.geometry.Pos;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.layout.BorderPane;
import javafx.scene.layout.GridPane;
import javafx.stage.Stage;

public class JavaFXTemplate1 extends Application {
Label caption1 = new Label("Output Label :: Events Name");
Label caption2 = new Label("OutPut Label :: from show_tex1()");
private static String fxstr1=null; 
ExternalClass1 ex1 = new ExternalClass1(); 
@Override
    public void start(Stage primaryStage)throws SQLException {
       
      System.out.println("main block executing ");
      //JDBC PostgreSQL
      System.out.println("Connected to  database successfully"); 
      fxstr1= ex1.loaddata(); 
      //JavaFX Controls 
         BorderPane root = new BorderPane();
        Button ctrlbtn = new Button("Click Me");
        Scene scene = new Scene(root,300,250);
        ctrlbtn.setOnAction(e->ctrlbutton_click());
        GridPane gPane = new GridPane();
        gPane.setAlignment(Pos.CENTER);
        gPane.setHgap(10);gPane.setVgap(15);
        gPane.add(caption1, 0, 0);  
        gPane.add(caption2, 0, 1);  
        gPane.add(ctrlbtn, 0, 2);
        root.setCenter(gPane);
        primaryStage.setTitle(this.fxstr1);
        primaryStage.setScene(scene);
        primaryStage.show();
   }
 public void ctrlbutton_click()
    {
         caption1.setText("Button Clicked " );
         caption2.setText(fxstr1  );
   }
public static void main(String[] args) throws SQLException {
launch(args);
}
}
// ExternalClass1 Codes: 
package javafxtemplate1;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ExternalClass1 {
    private static String str1;  public static String str3= null;
    // call ExtrenalClass2 prior to Externalclass1 
    
    ExternalClass2 extclass = new ExternalClass2();

      
public String loaddata() throws SQLException 
{
    // Connection 
    Connection connect = extclass.createConnection();
    String query = " select show_text1() ";
    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(1);
                       // will have "Hello World" Text 
                    }
    str3 = str1; 
		} catch (Exception e) {
			System.out.println(e.toString());
		}
     return str3; 
}
}
// Codes ExternalClass3: 
package javafxtemplate1;

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

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

}