Advertisement
Guest User

Untitled

a guest
Nov 8th, 2016
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.11 KB | None | 0 0
  1. FilteredList <Paisjet> filteredData = new FilteredList<>(data,e -> true);
  2.  
  3. paisjaSearch.textProperty().addListener((observableValue,oldValue,newValue) ->
  4. {
  5. filteredData.setPredicate( paisjet ->
  6. {
  7. if(newValue == null || newValue.isEmpty())
  8. {
  9. return true;
  10. }
  11. String lowerCaseFilter = newValue.toLowerCase();
  12. if(paisjet.getPaisja().toLowerCase().contains(lowerCaseFilter))
  13. {
  14. return true;
  15. }
  16. return false;
  17. });
  18. });
  19. kategoriaSearch.textProperty().addListener((observableValue,oldValue,newValue) ->
  20. {
  21. filteredData.setPredicate( paisjet ->
  22. {
  23. if(newValue == null || newValue.isEmpty())
  24. {
  25. return true;
  26. }
  27. String lowerCaseFilter = newValue.toLowerCase();
  28. if(paisjet.getKategoria().toLowerCase().contains(lowerCaseFilter))
  29. {
  30. return true;
  31. }
  32. return false;
  33. });
  34. });
  35. prodhuesiSearch.textProperty().addListener((observableValue,oldValue,newValue) ->
  36. {
  37. filteredData.setPredicate( paisjet ->
  38. {
  39. if(newValue == null || newValue.isEmpty())
  40. {
  41. return true;
  42. }
  43. String lowerCaseFilter = newValue.toLowerCase();
  44. if(paisjet.getProdhuesi().toLowerCase().contains(lowerCaseFilter))
  45. {
  46. return true;
  47. }
  48. return false;
  49. });
  50. });
  51. modeliSearch.textProperty().addListener((observableValue,oldValue,newValue) ->
  52. {
  53. filteredData.setPredicate( paisjet ->
  54. {
  55. if(newValue == null || newValue.isEmpty())
  56. {
  57. return true;
  58. }
  59. String lowerCaseFilter = newValue.toLowerCase();
  60. if(paisjet.getModeli().toLowerCase().contains(lowerCaseFilter))
  61. {
  62. return true;
  63. }
  64. return false;
  65. });
  66. });
  67.  
  68. SortedList <Paisjet> sortedData = new SortedList<>(filteredData);
  69. sortedData.comparatorProperty().bind(tableView.comparatorProperty());
  70. tableView.setItems(sortedData);
  71.  
  72. Caused by: java.lang.UnsupportedOperationException
  73. at java.util.AbstractList.remove(AbstractList.java:161)
  74. at java.util.AbstractList$Itr.remove(AbstractList.java:374)
  75. at java.util.AbstractList.removeRange(AbstractList.java:571)
  76. at java.util.AbstractList.clear(AbstractList.java:234)
  77. at main.MainWindowController.clearTable(MainWindowController.java:315)
  78. at main.MainWindowController.addToTableFromDatabase(MainWindowController.java:320)
  79. at main.MainWindowController.addToDatabase(MainWindowController.java:309)
  80. ... 61 more
  81.  
  82. public void clearTable()
  83. {
  84. tableView.getItems().clear(); // line 315 at OUTPUT ERROR
  85. }
  86.  
  87. public void addToTableFromDatabase() throws ClassNotFoundException, SQLException
  88. {
  89. clearTable(); //line 320 at OUTPUT ERROR
  90. Class.forName("com.mysql.jdbc.Driver");
  91. String url="jdbc:mysql://***.***.**.*:****/*********";
  92. String uname="*****";
  93. String pass="*********";
  94. connect = (Connection) DriverManager.getConnection(url,uname,pass);
  95.  
  96. Statement statement;
  97. String query = "SELECT * FROM paisjettable" ;
  98. statement = connect.createStatement();
  99. ResultSet rs = statement.executeQuery(query);
  100.  
  101. while(rs.next())
  102. {
  103.  
  104. int id = rs.getInt("id");
  105. String prodhuesi = rs.getString("prodhuesi");
  106. String modeli = rs.getString("modeli");
  107. String paisja = rs.getString("paisja");
  108. String pjesa = rs.getString("pjesa");
  109. String infoshtese = rs.getString("infoshtese");
  110. double qmimi = rs.getDouble("qmimi");
  111. double punedore = rs.getDouble("punedore");
  112. double pagesa = rs.getDouble("pagesa");
  113. int sasia = rs.getInt("sasia");
  114.  
  115. paisjet = new Paisjet(id,prodhuesi,modeli,paisja,pjesa,qmimi,punedore,pagesa,sasia,infoshtese);
  116. data.add(paisjet);
  117. tableView.setItems(data);
  118. }
  119.  
  120. rs.close();
  121. connect.close();
  122. }
  123.  
  124. public void addToDatabase() throws ClassNotFoundException, SQLException
  125. {
  126. addToDatabaseMethod(count,prodhuesiField.getText(),modeliField.getText(),paisjaField.getText(),pjesaField.getText(),Double.parseDouble(qmimiField.getText()),Double.parseDouble(puneDoreField.getText()),Integer.parseInt(sasiaField.getText()),infoArea.getText());
  127. count++;
  128. prodhuesiField.clear();
  129. modeliField.clear();
  130. paisjaField.clear();
  131. pjesaField.clear();
  132. qmimiField.clear();
  133. puneDoreField.clear();
  134. sasiaField.clear();
  135. infoArea.clear();
  136. addToTableFromDatabase(); // line 309 from OUTPUT ERROR
  137. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement