//JavaFXTemplate1.java
package javafxtemplate1;

import javafx.application.Application;
import javafx.application.Platform;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.Button;
import javafx.scene.control.ListView;
import javafx.stage.Stage;


/**
 *
 * @author Manas9
 */
public class JavaFXTemplate1 extends Application {
    //User Interface - display 
    private final ExternalClass3 ext1 = new ExternalClass3(); 
      @Override
    public void start(Stage primaryStage) throws Exception {
        Group groot = new Group();   
//ext1.loaddata() returns a List object
ObservableList<String> oString1 = 
FXCollections.<String>observableArrayList( ext1.loaddata());
ListView<String> lvwList = new ListView<>(oString1);
       lvwList.setLayoutX(100); lvwList.setLayoutY(10);
       lvwList.setMaxWidth(100);  
Button exitbtn = new Button("Exit Platform");
         exitbtn.setOnAction(new DemoEventHandler1(){ });
          //        
exitbtn.setLayoutX(10);exitbtn.setLayoutY(10);
groot.getChildren().addAll(exitbtn, lvwList);      
Scene scene = new Scene(groot, 350, 350);
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();

}
}

//ExternalClass3.java
package javafxtemplate1;

import com.sun.rowset.JdbcRowSetImpl;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import javax.sql.rowset.JdbcRowSet;
import javax.sql.rowset.RowSetProvider;

/**
 *
 * @author Manas9
 */
public class ExternalClass3 {
      public List list1 = new ArrayList();
      public  List<EMP1> eList = new ArrayList<>();
      //
       Connection c = null;  Statement st = null;
       //Below for tableview uses 
//public  List<EMP1>loaddata() throws SQLException 
 public   List loaddata() throws SQLException 
{
       String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
       String user = "postgres"; String pwd = "postgre_manas9";
       Properties param = new Properties(); 
       String sql1 = "Select * from emp";
       //
       param.put("user",user); param.put("password",pwd);
          c = DriverManager.getConnection(dbURL,user,pwd);
          st = c.createStatement();
  JdbcRowSet rowSet = RowSetProvider.newFactory().createJdbcRowSet();
       rowSet.setUrl(dbURL); rowSet.setUsername(user);
       rowSet.setPassword(pwd); rowSet.setCommand(sql1);
        rowSet.execute();
  st = c.createStatement(); 
     while (rowSet.next()) {
            int eID = rowSet.getInt("empno");
             String firstName = rowSet.getString("ename");
             String ejob = rowSet.getString("job");
             int eDept= rowSet.getInt("deptno");
             double esal = rowSet.getDouble("sal");
    //EMP1 person = new EMP1(eID,firstName, ejob, eDept, esal);
     //        eList.add(person);
       // The above used for table view examples                
             list1.add(eID); list1.add(firstName);
             list1.add(ejob); list1.add(eDept); list1.add(esal);
              list1.add("-------"); 
         }
            return list1;
              }
}