java - 如何在 Hibernate 中使用 REST API 删除多条记录
问题描述
您好我是 Spring Boot 的新手,我已经开发了通过 ID 获取、创建和删除单个记录的 API,现在我想请求删除选定的多个记录。示例:我喜欢在单个请求中删除 10 条记录中的 4 条记录,而不是发出 4 条删除请求。
项目控制器.java
@Qualifier("projectServiceImpl")
@Autowired
private ProjectService projectService;
@Autowired
private MapValidationErrorService mapValidationErrorService;
@PostMapping("")
public ResponseEntity<?> createNewProject(@Valid @RequestBody Project project, BindingResult result){
ResponseEntity<?> errorMap = mapValidationErrorService.MapValidationService(result);
if(errorMap!=null) return errorMap;
Project project1 = projectService.saveOrUpdateProject(project);
return new ResponseEntity<Project>(project1, HttpStatus.CREATED);
}
@GetMapping("/{id}")
public ResponseEntity<?> findProjectById(@PathVariable Long id){
Project project = projectService.findProjectById(id);
return new ResponseEntity<Project>(project, HttpStatus.OK);
}
@GetMapping("")
public List<Project> getAllProjects(){return projectService.findAllProjects();}
@DeleteMapping("/{id}")
public ResponseEntity<?> deleteProject(@PathVariable Long id){
projectService.deleteProjectById(id);
return new ResponseEntity<String>("Project with id: '"+id+ "' was deleted", HttpStatus.OK);
}
ProjectServiceImpl.java
@Autowired
private ProjectRepository projectRepository;
@Override
public long count() {
return projectRepository.count();
}
public Project saveOrUpdateProject(Project project){
try{
project.setProjectNumber(project.getProjectNumber());
return projectRepository.save(project);
}catch (Exception e){
throw new ProjectNumberException("The project number "+project.getProjectNumber()+" is already existed. Please select a different project number.");
}
}
public Project findProjectById(Long id) {
return projectRepository.findById(id).orElse(null);
}
public List<Project> findAllProjects() {
return projectRepository.findAll();
}
public void deleteProjectById(Long id) {
Project project = projectRepository.findById(id).orElse(null);;
projectRepository.delete(project);
}
项目存储库.java
@Repository
public interface ProjectRepository extends JpaRepository<Project, Long>, QuerydslPredicateExecutor<Project> {}
解决方案
您可以在ProjectRepository
@Modifying
@Query("delete from Project where id in (:ids)")
int deleteByIds(@Param("ids") List<Long> ids);
您需要一个端点来处理此类 JSON 请求
{
"ids" : [1, 2, 3]
}