Databases
StackOverflow2013
Postsdbo
PODisplay Items from a Database in a JavaFX TableView
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODisplay Items from a Database in a JavaFX TableView
    primarykey
    data
    text
    <p>Ok, so I'm new to this, and I've been searching for two weeks trying to get an SQL resultset to print to a TableView made by JavaFX Scene Builder. I can print my resultset using System.out.println and the data is correct, but when I try put it into a List, my tableview shows one column with 0s and the other column blank. I'm trying to print the List (println), but I get the object pointer(?) and not the data, so I can't see if I'm passing from the ResultSet to the List incorrectly.</p> <p>Any help would be appreciated ... I want to understand the concept, not just get an answer.</p> <p>Here's my controller code:</p> <pre><code>public class TesterUIController implements Initializable { @FXML private TableView&lt;dataClass&gt; Table; @FXML private Button TestButton; @FXML private TableColumn&lt;dataClass, Integer&gt; colKey; @FXML private TableColumn&lt;dataClass, String&gt; colSalesNo; public static void main (String[] args) { System.out.println("Main has run"); } /** * * @param fxmlFileLocation * @param resources */ @Override public void initialize(URL fxmlFileLocation, ResourceBundle resources) { TestButton.setOnAction(new EventHandler&lt;ActionEvent&gt;() { @Override public void handle(ActionEvent event) { System.out.println("Button Pressed"); colKey.setCellValueFactory(new PropertyValueFactory&lt;dataClass, Integer&gt;("Key")); colSalesNo.setCellValueFactory(new PropertyValueFactory&lt;dataClass, String&gt;("SalesNo")); Table.getItems().setAll(gobbledyGook()); } } ); } /* * dataClass is a (sub)class representing the data for TableView "Table" */ public class dataClass { private IntegerProperty Key; public void setKey (int value) {KeyProperty().set(value);} public int getKey() { return KeyProperty().get(); } public IntegerProperty KeyProperty() { if (Key == null) Key = new SimpleIntegerProperty(this, "Key"); return Key; } private StringProperty SalesNo; public void setSalesNo(String value) { SalesNoProperty().set(value); } public String getSalesNo() { return SalesNoProperty().get(); } public StringProperty SalesNoProperty() { if (SalesNo == null) SalesNo = new SimpleStringProperty(this, "SalesNo"); return SalesNo; } } private List&lt;dataClass&gt; gobbledyGook() { //ObservableList&lt;dataClass&gt; gobbledyGook() { // ResultSet getData() { Connection conn; String dbDriver; Statement st; ResultSet rs;// = null; List ll = new LinkedList(); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); dbDriver = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};" + "DBQ=Inventario.mdb;"; conn = DriverManager.getConnection(dbDriver, "", ""); st = conn.createStatement(); String getSalesNumber = "SELECT * FROM SalesNumber " // TOP 1 * FROM ... + "ORDER BY SalesNumber.Key DESC";// LIMIT 1"; rs = st.executeQuery(getSalesNumber); while (rs.next()) { int Key = rs.getInt(1); double saleNo = rs.getDouble(2); NumberFormat formatter = new DecimalFormat("###########"); String SalesNo = formatter.format(saleNo); System.out.println(Key + ", " + SalesNo); //key + ", " + saleNo); dataClass roww = new dataClass(); ll.add(roww); } } catch (ClassNotFoundException | SQLException ex) { Logger.getLogger(TesterUIController.class.getName()).log(Level.SEVERE, null, ex); } return ll; } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjewelsea
    1. USJohn
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODisplay Items from a Database in a JavaFX TableView
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PODisplay Items from a Database in a JavaFX TableView
      1. USmr.wolle
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload