spring data jpa soft delete code example
Example 1: spring delete mapping
package com.zetcode.controller;
import com.zetcode.model.Post;
import com.zetcode.service.IPostService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import java.util.Set;
import static org.springframework.http.ResponseEntity.ok;
@Controller
@RequestMapping("/posts")
public class MyController {
@Autowired
private IPostService postService;
@GetMapping
public ResponseEntity<Set<Post>> all() {
return ok().body(postService.all());
}
@DeleteMapping("{id}")
public ResponseEntity<Long> deletePost(@PathVariable("id") Long id) {
var isRemoved = postService.delete(id);
if (!isRemoved) {
return new ResponseEntity<>(HttpStatus.NOT_FOUND);
}
return new ResponseEntity<>(id, HttpStatus.OK);
}
}
Example 2: spring rest jdbc delete
// syntax
String deleteQuery = "delete from Student where id = ?";
jdbcTemplateObject.update(deleteQuery, id);