API tools faq
paste
Guest User

Untitled

a guest
Oct 22nd, 2017
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.08 KB | None | 0 0
raw download clone embed print report
  1. <TableView fx:id="table" layoutX="46.0" layoutY="83.0" prefHeight="458.0" prefWidth="680.0">
  2. <columns>
  3. <TableColumn fx:id="column_code" prefWidth="100" text="Item Code" />
  4. <TableColumn fx:id="column_name" prefWidth="200" text="Item Name" />
  5. <TableColumn fx:id="column_date" prefWidth="100" text="Order Date" />
  6. <TableColumn fx:id="column_quantity" prefWidth="80" text="Quantity" />
  7. <TableColumn fx:id="column_cost" prefWidth="100" text="Order Cost" />
  8. <TableColumn fx:id="column_status" prefWidth="100" text="Order Status" />
  9. </columns>
  10. </TableView>
  11.  
  12. public class StockController implements Initializable {
  13.  
  14. static Connection con = null;
  15. static PreparedStatement pst = null;
  16. static Statement stmt = null;
  17. static ResultSet rs;
  18. private ObservableList<Stock> data
  19.  
  20.  
  21. @FXML private TableView<Stock> table;
  22. @FXML private TableColumn<?, ?> column_code;
  23. @FXML private TableColumn<?, ?> column_name;
  24. @FXML private TableColumn<?, ?> column_date;
  25. @FXML private TableColumn<?, ?> column_quantity;
  26. @FXML private TableColumn<?, ?> column_cost;
  27. @FXML private TableColumn<?, ?> column_status;
  28.  
  29. @Override
  30. public void initialize(URL url, ResourceBundle rb){
  31.  
  32. con = sample.Database.DBConnection.makeConnection();
  33. data = FXCollections.observableArrayList();
  34.  
  35. try{
  36. stmt = con.createStatement();
  37. } catch (Exception e){
  38. System.out.println("error connecting to db");
  39. }
  40.  
  41. setCellTable();
  42. loadDataFromDB();
  43. }
  44.  
  45. public void setCellTable(){
  46. column_code.setCellValueFactory(new PropertyValueFactory<>("itemCode"));
  47. column_name.setCellValueFactory(new PropertyValueFactory<>("itemName"));
  48. column_date.setCellValueFactory(new PropertyValueFactory<>("orderDate"));
  49. column_quantity.setCellValueFactory(new PropertyValueFactory<>("orderQuantity"));
  50. column_cost.setCellValueFactory(new PropertyValueFactory<>("orderCost"));
  51. column_status.setCellValueFactory(new PropertyValueFactory<>("orderStatus"));
  52. }
  53.  
  54. public void loadDataFromDB(){
  55. try {
  56. String q1 = "SELECT * FROM products";
  57.  
  58. String query = "SELECT products.itemCode, products.itemName, stock.orderDate, stock.orderedQuantity, products.itemCost, stock.orderStatus " +
  59. "FROM products, stock";
  60.  
  61. pst = con.prepareStatement(query);
  62. rs = pst.executeQuery();
  63.  
  64. while (rs.next()){
  65. data.add(new Stock(rs.getString(1), rs.getString(2), rs.getString(3),
  66. rs.getString(4), rs.getString(5), rs.getString(6)));
  67.  
  68. }
  69.  
  70. } catch (Exception e) {
  71. e.printStackTrace();
  72. }
  73.  
  74. table.setItems(data);
  75. }
  76.  
  77. }
  78.  
  79. Oct 22, 2017 8:03:00 PM javafx.scene.control.cell.PropertyValueFactory getCellDataReflectively
  80. WARNING: Can not retrieve property 'itemCode' in PropertyValueFactory: javafx.scene.control.cell.PropertyValueFactory@fe29770 with provided class type: class sample.Stock.Stock
  81. java.lang.IllegalStateException: Cannot read from unreadable property itemCode
  82. at javafx.base/com.sun.javafx.property.PropertyReference.get(PropertyReference.java:170)
  83. at javafx.controls/javafx.scene.control.cell.PropertyValueFactory.getCellDataReflectively(PropertyValueFactory.java:184)
  84. at javafx.controls/javafx.scene.control.cell.PropertyValueFactory.call(PropertyValueFactory.java:154)
  85. at javafx.controls/javafx.scene.control.cell.PropertyValueFactory.call(PropertyValueFactory.java:133)
  86. at javafx.controls/javafx.scene.control.TableColumn.getCellObservableValue(TableColumn.java:593)
  87. at javafx.controls/javafx.scene.control.TableColumn.getCellObservableValue(TableColumn.java:578)
  88. at javafx.controls/javafx.scene.control.TableCell.updateItem(TableCell.java:646)
  89. at javafx.controls/javafx.scene.control.TableCell.indexChanged(TableCell.java:469)
  90. at javafx.controls/javafx.scene.control.IndexedCell.updateIndex(IndexedCell.java:120)
  91. at javafx.controls/javafx.scene.control.skin.TableRowSkinBase.updateCells(TableRowSkinBase.java:539)
  92. at javafx.controls/javafx.scene.control.skin.TableRowSkinBase.<init>(TableRowSkinBase.java:159)
  93. at javafx.controls/javafx.scene.control.skin.TableRowSkin.<init>(TableRowSkin.java:89)
  94. at javafx.controls/javafx.scene.control.TableRow.createDefaultSkin(TableRow.java:213)
  95. at javafx.controls/javafx.scene.control.Control.doProcessCSS(Control.java:897)
  96. at javafx.controls/javafx.scene.control.Control.access$000(Control.java:83)
  97. at javafx.controls/javafx.scene.control.Control$1.doProcessCSS(Control.java:89)
  98. at javafx.controls/com.sun.javafx.scene.control.ControlHelper.processCSSImpl(ControlHelper.java:67)
  99. at javafx.graphics/com.sun.javafx.scene.NodeHelper.processCSS(NodeHelper.java:147)
  100. at javafx.graphics/javafx.scene.Node.processCSS(Node.java:9513)
  101. at javafx.graphics/javafx.scene.Node.applyCss(Node.java:9600)
  102. at javafx.controls/javafx.scene.control.skin.VirtualFlow.setCellIndex(VirtualFlow.java:1715)
  103. at javafx.controls/javafx.scene.control.skin.VirtualFlow.getCell(VirtualFlow.java:1692)
  104. at javafx.controls/javafx.scene.control.skin.VirtualFlow.getCellLength(VirtualFlow.java:1801)
  105. at javafx.controls/javafx.scene.control.skin.VirtualFlow.computeViewportOffset(VirtualFlow.java:2638)
  106. at javafx.controls/javafx.scene.control.skin.VirtualFlow.layoutChildren(VirtualFlow.java:1245)
  107. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1226)
  108. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1233)
  109. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1233)
  110. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1233)
  111. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1233)
  112. at javafx.graphics/javafx.scene.Parent.layout(Parent.java:1233)
  113. at javafx.graphics/javafx.scene.Scene.doLayoutPass(Scene.java:590)
  114. at javafx.graphics/javafx.scene.Scene$ScenePulseListener.pulse(Scene.java:2507)
  115. at javafx.graphics/com.sun.javafx.tk.Toolkit.lambda$runPulse$2(Toolkit.java:410)
  116. at java.base/java.security.AccessController.doPrivileged(Native Method)
  117. at javafx.graphics/com.sun.javafx.tk.Toolkit.runPulse(Toolkit.java:409)
  118. at javafx.graphics/com.sun.javafx.tk.Toolkit.firePulse(Toolkit.java:436)
  119. at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.pulse(QuantumToolkit.java:518)
  120. at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.pulse(QuantumToolkit.java:498)
  121. at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.pulseFromQueue(QuantumToolkit.java:491)
  122. at javafx.graphics/com.sun.javafx.tk.quantum.QuantumToolkit.lambda$runToolkit$11(QuantumToolkit.java:319)
  123. at javafx.graphics/com.sun.glass.ui.InvokeLaterDispatcher$Future.run(InvokeLaterDispatcher.java:96)
  124. at javafx.graphics/com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  125. at javafx.graphics/com.sun.glass.ui.win.WinApplication.lambda$runLoop$3(WinApplication.java:175)
  126. at java.base/java.lang.Thread.run(Thread.java:844)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!