API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 21st, 2016
66
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.68 KB | None | 0 0
raw download clone embed print report
  1. public void captureDataSuper() {
  2. Connection c;
  3. ObservableList<ObservableList> data;
  4. data = FXCollections.observableArrayList();
  5. try {
  6. c = KonekDB.createConnection();
  7. //SQL FOR SELECTING ALL OF CUSTOMER
  8. String SQL = "SELECT * from adminsupervisor";
  9. //ResultSet
  10. ResultSet rs = c.createStatement().executeQuery(SQL);
  11.  
  12. /**
  13. * ********************************
  14. * TABLE COLUMN ADDED DYNAMICALLY * ********************************
  15. */
  16. for (int i = 0; i < rs.getMetaData().getColumnCount(); i++) {
  17. //We are using non property style for making dynamic table
  18. final int j = i;
  19. TableColumn col = new TableColumn(rs.getMetaData().getColumnName(i + 1));
  20. //now its editable
  21. col.setCellFactory(TextFieldTableCell.<Adminsupervisor>forTableColumn());
  22. //trying to make effect on database after edited with setOnEditCommit
  23. col.setOnEditCommit(
  24. new EventHandler<CellEditEvent<Adminsupervisor, String>>() {
  25.  
  26. public void handle(CellEditEvent<Adminsupervisor, String> t) {
  27. ((Adminsupervisor) t.getTableView().getItems().get(
  28. t.getTablePosition().getRow())).set(j, t.getNewValue());
  29. }
  30. }
  31. );
  32. col.setCellValueFactory(new Callback<CellDataFeatures<ObservableList, String>, ObservableValue<String>>() {
  33. public ObservableValue<String> call(CellDataFeatures<ObservableList, String> param) {
  34. return new SimpleStringProperty(param.getValue().get(j).toString());
  35. }
  36. });
  37.  
  38. supervisorTable.getColumns().addAll(col);
  39. System.out.println("Column [" + i + "] ");
  40. }
  41.  
  42. /**
  43. * ******************************
  44. * Data added to ObservableList * ******************************
  45. */
  46. while (rs.next()) {
  47. //Iterate Row
  48. ObservableList<String> row = FXCollections.observableArrayList();
  49. for (int i = 1; i <= rs.getMetaData().getColumnCount(); i++) {
  50. //Iterate Column
  51. row.add(rs.getString(i));
  52. }
  53. System.out.println("Row [1] added " + row);
  54. data.add(row);
  55.  
  56. }
  57.  
  58. //FINALLY ADDED TO TableView
  59. supervisorTable.setItems(data);
  60. } catch (Exception e) {
  61. e.printStackTrace();
  62. System.out.println("Error on Building Data");
  63. }
  64. }
  65.  
  66. col.setOnEditCommit(
  67. new EventHandler<CellEditEvent<Adminsupervisor, String>>() {
  68.  
  69. public void handle(CellEditEvent<Adminsupervisor, String> t) {
  70. ((Adminsupervisor) t.getTableView().getItems().get(
  71. t.getTablePosition().getRow())).set(j, t.getNewValue());
  72. }
  73. }
  74. );
  75.  
  76. public class Adminsupervisor {
  77.  
  78. private String id;
  79. private String username;
  80. private String password;
  81. private String userType;
  82.  
  83. public String getId() {
  84. return id;
  85. }
  86.  
  87. public String getUsername() {
  88. return username;
  89. }
  90.  
  91. public String getPassword() {
  92. return password;
  93. }
  94.  
  95. public String getUserType() {
  96. return userType;
  97. }
  98.  
  99. public void setId(String id) {
  100. this.id = id;
  101. }
  102.  
  103. public void setUsername(String username) {
  104. this.username = username;
  105. }
  106.  
  107. public void setPassword(String password) {
  108. this.password = password;
  109. }
  110.  
  111. public void setUserType(String userType) {
  112. this.userType = userType;
  113. }
  114.  
  115. void set(int j, String newValue) {
  116. for (j = 0; j < 4; j++) {
  117. if (j == 0) {
  118. setId(newValue);
  119. }
  120. if (j == 2) {
  121. setPassword(newValue);
  122. }
  123. if (j == 3) {
  124. setUserType(newValue);
  125. }
  126. if (j == 1) {
  127. setUsername(newValue);
  128. }
  129. }
  130. try {
  131. Connection c = KonekDB.createConnection();
  132.  
  133. String SQL = "UPDATE adminsupervisor SET "
  134. + "username=" + username + ","
  135. + "password=" + password + ","
  136. + "userType=" + userType + " WHERE id=" + id + "";
  137. //ResultSet
  138. c.createStatement().executeUpdate(SQL);
  139. } catch (Exception e) {
  140. e.printStackTrace();
  141. System.out.println("Error on Building Data");
  142. }
  143. }}
  144.  
  145. Exception in thread "JavaFX Application Thread" java.lang.ClassCastException: com.sun.javafx.collections.ObservableListWrapper cannot be cast to AdminSide.Adminsupervisor
  146. at AdminSide.PanelAdmin$1.handle(PanelAdmin.java:275)
  147. at AdminSide.PanelAdmin$1.handle(PanelAdmin.java:272)
  148. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  149. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  150. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  151. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  152. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  153. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  154. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  155. at javafx.event.Event.fireEvent(Event.java:198)
  156. at javafx.scene.control.TableCell.commitEdit(TableCell.java:349)
  157. at javafx.scene.control.cell.CellUtils.lambda$createTextField$615(CellUtils.java:248)
  158. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:86)
  159. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  160. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  161. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  162. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  163. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  164. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  165. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  166. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  167. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  168. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  169. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  170. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  171. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  172. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  173. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  174. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  175. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  176. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  177. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  178. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  179. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:49)
  180. at javafx.event.Event.fireEvent(Event.java:198)
  181. at javafx.scene.Node.fireEvent(Node.java:8411)
  182. at com.sun.javafx.scene.control.behavior.TextFieldBehavior.fire(TextFieldBehavior.java:179)
  183. at com.sun.javafx.scene.control.behavior.TextInputControlBehavior.callAction(TextInputControlBehavior.java:178)
  184. at com.sun.javafx.scene.control.behavior.BehaviorBase.callActionForEvent(BehaviorBase.java:218)
  185. at com.sun.javafx.scene.control.behavior.TextInputControlBehavior.callActionForEvent(TextInputControlBehavior.java:127)
  186. at com.sun.javafx.scene.control.behavior.BehaviorBase.lambda$new$74(BehaviorBase.java:135)
  187. at com.sun.javafx.event.CompositeEventHandler$NormalEventHandlerRecord.handleBubblingEvent(CompositeEventHandler.java:218)
  188. at com.sun.javafx.event.CompositeEventHandler.dispatchBubblingEvent(CompositeEventHandler.java:80)
  189. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:238)
  190. at com.sun.javafx.event.EventHandlerManager.dispatchBubblingEvent(EventHandlerManager.java:191)
  191. at com.sun.javafx.event.CompositeEventDispatcher.dispatchBubblingEvent(CompositeEventDispatcher.java:59)
  192. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:58)
  193. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  194. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  195. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  196. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  197. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  198. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  199. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  200. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  201. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  202. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  203. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  204. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  205. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  206. at com.sun.javafx.event.BasicEventDispatcher.dispatchEvent(BasicEventDispatcher.java:56)
  207. at com.sun.javafx.event.EventDispatchChainImpl.dispatchEvent(EventDispatchChainImpl.java:114)
  208. at com.sun.javafx.event.EventUtil.fireEventImpl(EventUtil.java:74)
  209. at com.sun.javafx.event.EventUtil.fireEvent(EventUtil.java:54)
  210. at javafx.event.Event.fireEvent(Event.java:198)
  211. at javafx.scene.Scene$KeyHandler.process(Scene.java:3964)
  212. at javafx.scene.Scene$KeyHandler.access$1800(Scene.java:3910)
  213. at javafx.scene.Scene.impl_processKeyEvent(Scene.java:2040)
  214. at javafx.scene.Scene$ScenePeerListener.keyEvent(Scene.java:2501)
  215. at com.sun.javafx.tk.quantum.GlassViewEventHandler$KeyEventNotification.run(GlassViewEventHandler.java:197)
  216. at com.sun.javafx.tk.quantum.GlassViewEventHandler$KeyEventNotification.run(GlassViewEventHandler.java:147)
  217. at java.security.AccessController.doPrivileged(Native Method)
  218. at com.sun.javafx.tk.quantum.GlassViewEventHandler.lambda$handleKeyEvent$353(GlassViewEventHandler.java:228)
  219. at com.sun.javafx.tk.quantum.QuantumToolkit.runWithoutRenderLock(QuantumToolkit.java:389)
  220. at com.sun.javafx.tk.quantum.GlassViewEventHandler.handleKeyEvent(GlassViewEventHandler.java:227)
  221. at com.sun.glass.ui.View.handleKeyEvent(View.java:546)
  222. at com.sun.glass.ui.View.notifyKey(View.java:966)
  223. at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
  224. at com.sun.glass.ui.win.WinApplication.lambda$null$148(WinApplication.java:191)
  225. at java.lang.Thread.run(Thread.java:745)
  226.  
  227. while (rs.next()) {
  228. //Iterate Row
  229. ObservableList<String> row = FXCollections.observableArrayList();
  230. ...
  231. data.add(row);
  232. }
  233.  
  234. public void handle(CellEditEvent<Adminsupervisor, String> t) {
  235. ((Adminsupervisor) t.getTableView().getItems().get(
  236. t.getTablePosition().getRow())).set(j, t.getNewValue());
  237. }
  238.  
  239. for (j = 0; j < 4; j++) {
  240. if (j == 0) {
  241. setId(newValue);
  242. }
  243. if (j == 2) {
  244. setPassword(newValue);
  245. }
  246. if (j == 3) {
  247. setUserType(newValue);
  248. }
  249. if (j == 1) {
  250. setUsername(newValue);
  251. }
  252. }
  253.  
  254. setId(newValue);
  255. setUsername(newValue);
  256. setPassword(newValue);
  257. setUserType(newValue);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!