Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private boolean validate_HPage(String item1, String item2) {
- try {
- data = FXCollections.observableArrayList();
- Class.forName("com.mysql.jdbc.Driver"); // MySQL database connection
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sample1", "root", "");
- System.out.println(item1);
- System.out.println(item2);
- PreparedStatement pst = con.prepareStatement("SELECT * FROM process WHERE `Status` = '"+item1+"' and `Process_Type` ='"+item2+"'");
- System.out.println("44");
- ResultSet rs = pst.executeQuery();
- System.out.println("45");
- if (rs.next()) {
- System.out.println("45");
- data.add(new ViewProcess(rs.getInt(1), rs.getString(2), rs.getString(3), rs.getString(4), rs.getString(5), rs.getDate(6)));
- System.out.println(rs.getInt("Process_ID"));
- System.out.println(rs.getString("Process_Type"));
- System.out.println(rs.getString("Status"));
- System.out.println(rs.getString("Process_Name"));
- System.out.println(rs.getString("Language"));
- System.out.println(rs.getDate("Date"));
- Integer id = rs.getInt(1);
- //
- // System.err.println("888");
- columnProcess_ID.setCellValueFactory(new PropertyValueFactory<ViewProcess,Integer>("Process_ID"));
- //System.out.println("dis");
- columnProcess_Type.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Process_Type"));
- //System.out.println("dis");
- columnStatus.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Status"));
- System.out.println("dis");
- columnProcess_Name.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Process_Name"));
- System.out.println("dis");
- columnLanguage.setCellValueFactory(new PropertyValueFactory<ViewProcess,String>("Language"));
- System.out.println("dis");
- columnDate.setCellValueFactory(new PropertyValueFactory<ViewProcess,Date>("Date"));
- System.out.println("dis");
- tbl_processlist.setItems(null);
- tbl_processlist.setItems(data);
- System.out.println(rs.getDate(6));
- System.out.println("45");
- return true;
- }
- else {
- System.out.println("47");
- return false;
- }
- } catch (Exception e) {
- e.printStackTrace();
- return false;
- }
Add Comment
Please, Sign In to add comment