Guest User

Untitled

a guest
Feb 2nd, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.49 KB | None | 0 0
  1. private boolean validate_HPage(String item1, String item2) {
  2.  
  3. try {
  4. data = FXCollections.observableArrayList();
  5. Class.forName("com.mysql.jdbc.Driver"); // MySQL database connection
  6. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sample1", "root", "");
  7. System.out.println(item1);
  8. System.out.println(item2);
  9. PreparedStatement pst = con.prepareStatement("SELECT * FROM process WHERE `Status` = '"+item1+"' and `Process_Type` ='"+item2+"'");
  10. System.out.println("44");
  11. ResultSet rs = pst.executeQuery();
  12. System.out.println("45");
  13. if (rs.next()) {
  14.  
  15. System.out.println("45");
  16. data.add(new ViewProcess(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getDate(6)));
  17. System.out.println(rs.getInt("Process_ID"));
  18. System.out.println(rs.getString("Process_Type"));
  19. System.out.println(rs.getString("Status"));
  20. System.out.println(rs.getString("Process_Name"));
  21. System.out.println(rs.getString("Language"));
  22. System.out.println(rs.getDate("Date"));
  23. Integer id = rs.getInt(1);
  24. //
  25.  
  26.  
  27. // System.err.println("888");
  28. columnProcess_ID.setCellValueFactory(new PropertyValueFactory<ViewProcess,Integer>("Process_ID"));
  29. //System.out.println("dis");
  30. columnProcess_Type.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Process_Type"));
  31. //System.out.println("dis");
  32. columnStatus.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Status"));
  33. System.out.println("dis");
  34. columnProcess_Name.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Process_Name"));
  35. System.out.println("dis");
  36. columnLanguage.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Language"));
  37. System.out.println("dis");
  38. columnDate.setCellValueFactory(new PropertyValueFactory<ViewProcess,Date>("Date"));
  39. System.out.println("dis");
  40. tbl_processlist.setItems(null);
  41. tbl_processlist.setItems(data);
  42. System.out.println(rs.getDate(6));
  43. System.out.println("45");
  44. return true;
  45.  
  46. }
  47.  
  48. else {
  49. System.out.println("47");
  50. return false;
  51. }
  52.  
  53. } catch (Exception e) {
  54. e.printStackTrace();
  55. return false;
  56. }
Add Comment
Please, Sign In to add comment