import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.LinkedList;
import java.util.List;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
public class StudentInfo {
static String JDBC_DRIVER = "org.postgresql.Driver";
//static String DB_URL = "jdbc:h2:file:C:/WAKILI/WAKILIdb";
// Database credentials
static final String USER = "wrcobb";
static final String PASS = "wrcobb";
public static Connection conn = null;
public List<KIWIDataModel> getAllstudentInfo() throws SQLException {
Statement st = null;
ResultSet rs;
String driver = "org.postgresql.Driver";
List ll = new LinkedList();
String dbName = "wrcobb";
String urlString = System.getProperty( "db.url", "jdbc:postgresql://localhost:5432/" +
dbName + "?user=wrcobb&password=wrcobb" );
conn = DriverManager.getConnection( urlString );
DatabaseMetaData dmd = conn.getMetaData();
try {
Class.forName(driver);
//conn = DriverManager.getConnection(DB_URL, USER, PASS);
conn = DriverManager.getConnection(urlString);
st = conn.createStatement();
String recordQuery = ("SELECT id, KIWI FROM KIWI");
rs = st.executeQuery(recordQuery);
while (rs.next()) {
int Key = rs.getInt(1);
ObservableList row = FXCollections.observableArrayList();
for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
row.add(rs.getString(i));
System.out.println(row);
}
KIWIDataModel roww = new KIWIDataModel();
roww.setFirstName(Key);
ll.add(row);
}
} catch (ClassNotFoundException | SQLException ex) {
// CATCH SOMETHING
}
return ll;
}
}