Guest User

Untitled

a guest
Jun 1st, 2018
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. @FXML private void addHandle(ActionEvent Event) {
  2. String desc = description.getText();
  3. LocalDate create = LocalDate.now();
  4. LocalDate due = datePicker.getValue();
  5. String sql = "INSERT INTO `todo_list`.`todo_list` (`createDate`, `dueDate`, `description`) VALUES (?, ?, ?);";
  6.  
  7. if(desc.trim().isEmpty()){
  8. new Alert(Alert.AlertType.ERROR, "Description cannot be empty").showAndWait();
  9. }
  10.  
  11.  
  12. try {
  13. conn = DBConnection.getConnection();
  14. prep = conn.prepareStatement(sql);
  15. prep.setObject(1, create);
  16. prep.setObject(2, due);
  17. prep.setObject(3, desc);
  18.  
  19. prep.executeUpdate();
  20.  
  21. loadDataFromDatabase(Event);
  22.  
  23. refresh();
  24. } catch (Exception e) {
  25. System.out.println("Couldn't add new task");
  26. }
  27. }
Advertisement
Add Comment
Please, Sign In to add comment