Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @FXML private void addHandle(ActionEvent Event) {
- String desc = description.getText();
- LocalDate create = LocalDate.now();
- LocalDate due = datePicker.getValue();
- String sql = "INSERT INTO `todo_list`.`todo_list` (`createDate`, `dueDate`, `description`) VALUES (?, ?, ?);";
- if(desc.trim().isEmpty()){
- new Alert(Alert.AlertType.ERROR, "Description cannot be empty").showAndWait();
- }
- try {
- conn = DBConnection.getConnection();
- prep = conn.prepareStatement(sql);
- prep.setObject(1, create);
- prep.setObject(2, due);
- prep.setObject(3, desc);
- prep.executeUpdate();
- loadDataFromDatabase(Event);
- refresh();
- } catch (Exception e) {
- System.out.println("Couldn't add new task");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment