Question

JavaFX code for a simple tableview done in scene builder which only shows first name and last name populated automatically from the netbeans derby database? Im having trouble making it do it so anything would help. Thank you

Answer 1

2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121

package sample.util; import com.sun.rowset.CachedRowSetImpl; import java.sql.*; /** * Created by ONUR BASKIRT on 22.02.2016. */ public class DBUtil {     //Declare JDBC Driver     private static final String JDBC_DRIVER = "oracle.jdbc.driver.OracleDriver";     //Connection     private static Connection conn = null;     //Connection String     //String connStr = "jdbc:oracle:thin:Username/Password@IP:Port/SID";     //Username=HR, Password=HR, IP=localhost, IP=1521, SID=xe     private static final String connStr = "jdbc:oracle:thin:HR/HR@localhost:1521/xe";     //Connect to DB     public static void dbConnect() throws SQLException, ClassNotFoundException {         //Setting Oracle JDBC Driver         try {             Class.forName(JDBC_DRIVER);         } catch (ClassNotFoundException e) {             System.out.println("Where is your Oracle JDBC Driver?");             e.printStackTrace();             throw e;         }         System.out.println("Oracle JDBC Driver Registered!");         //Establish the Oracle Connection using Connection String         try {             conn = DriverManager.getConnection(connStr);         } catch (SQLException e) {             System.out.println("Connection Failed! Check output console" + e);             e.printStackTrace();             throw e;         }     }     //Close Connection     public static void dbDisconnect() throws SQLException {         try {             if (conn != null && !conn.isClosed()) {                 conn.close();             }         } catch (Exception e){            throw e;         }     }     //DB Execute Query Operation     public static ResultSet dbExecuteQuery(String queryStmt) throws SQLException, ClassNotFoundException {         //Declare statement, resultSet and CachedResultSet as null         Statement stmt = null;         ResultSet resultSet = null;         CachedRowSetImpl crs = null;         try {             //Connect to DB (Establish Oracle Connection)             dbConnect();             System.out.println("Select statement: " + queryStmt + "\n");             //Create statement             stmt = conn.createStatement();             //Execute select (query) operation             resultSet = stmt.executeQuery(queryStmt);             //CachedRowSet Implementation             //In order to prevent "java.sql.SQLRecoverableException: Closed Connection: next" error             //We are using CachedRowSet             crs = new CachedRowSetImpl();             crs.populate(resultSet);         } catch (SQLException e) {             System.out.println("Problem occurred at executeQuery operation : " + e);             throw e;         } finally {             if (resultSet != null) {                 //Close resultSet                 resultSet.close();             }             if (stmt != null) {                 //Close Statement                 stmt.close();             }             //Close connection             dbDisconnect();         }         //Return CachedRowSet         return crs;     }     //DB Execute Update (For Update/Insert/Delete) Operation     public static void dbExecuteUpdate(String sqlStmt) throws SQLException, ClassNotFoundException {         //Declare statement as null         Statement stmt = null;         try {             //Connect to DB (Establish Oracle Connection)             dbConnect();             //Create Statement             stmt = conn.createStatement();             //Run executeUpdate operation with given sql statement             stmt.executeUpdate(sqlStmt);         } catch (SQLException e) {             System.out.println("Problem occurred at executeUpdate operation : " + e);             throw e;         } finally {             if (stmt != null) {                 //Close statement                 stmt.close();             }             //Close connection             dbDisconnect();         }     } }