如何在Spring-Data中插入数据库？

Question

我想发出一个将数据插入数据库的请求。该表有4列:ID_DOCUMENT(PK)、ID_TASK、DESCRIPTION、FILEPATH

... 
@Column(name = "ID_TASK")
private Long idTask;


@Column(name = "DESCRIPTION")
private String description;

@Column(name = "FILEPATH")
private String filepath;
...

@Modifying
@Query("insert into TaskDocumentEntity c (c.idTask, c.description, c.filepath) values (:id,:description,:filepath)")
public void insertDocumentByTaskId(@Param("id") Long id,@Param("description") String description,@Param("filepath") String filepath);

@RequestMapping(value = "/services/tasks/addDocument", method = RequestMethod.POST)
@ResponseBody
public void set(@RequestParam("idTask") Long idTask,@RequestParam("description") String description,@RequestParam("filepath") String filepath){

    //TaskDocumentEntity document = new TaskDocumentEntity();
    taskDocumentRepository.insertDocumentByTaskId(idTask,descriere,filepath);
}

当我运行我的测试时，我得到了这个错误：由：org.hibernate.hql.ast.querysyntaxException引起的：预期打开，在第1行第32列附近发现'c'[insert into TaskDocumentEntity c（c.IDTask,c.Descripere,c.FilePath）值（：ID,：Descripere,:FilePath)]我试图删除别名c，但仍然不起作用。

Answer 1

Spring data提供了用于插入数据库的开箱即用的save方法-不需要使用@query。看看springData的核心概念（http://docs.spring.io/spring-data/jpa/docs/current/reference/html/#repositories.core-concepts）

因此，在控制器中只需创建objectTaskDocumentEntity并将其传递给repository

@RequestMapping(value = "/services/tasks/addDocument", method = RequestMethod.POST)
@ResponseBody
public void set(@RequestParam("idTask") Long idTask,@RequestParam("description") String description,@RequestParam("filepath") String filepath){

// assign parameters to taskDocumentEntity by constructor args or setters
        TaskDocumentEntity document = new TaskDocumentEntity(idTask,descriere,filepath);
        taskDocumentRepository.save(document);
    }