如何使用JPA和@Query命名参数将数据转换为MySQL
如何使用JPA和@Query命名参数将数据转换为MySQL
提问于 2015-05-02 15:36:17
我收到以下错误：
Using named parameters for method public static void com.htd.repository.MaterialRepository.uploadMaterialData(java.lang.String,java.math.BigDecimal,java.lang.String,java.math.BigDecimal,java.math.BigDecimal) but parameter 'material_number' not found in annotated query 'INSERT INTO hillcresttooldie VALUES (?,?,?,?,?)'!我在http://docs.spring.io/spring-data/jpa/docs/1.4.3.RELEASE/reference/html/jpa.repositories.html上阅读了文档，但我仍然有问题。我的印象是JPA为我们创建了查询。我习惯于写出查询，直到我看到这项令人惊叹的技术。
public interface MaterialRepository extends JpaRepository<Material,Long> {
@Query("INSERT INTO hillcresttooldie VALUES (?,?,?,?,?)")
static void uploadMaterialData(String material_number,BigDecimal material_thickness,String material_size,BigDecimal lb_per_sheet,BigDecimal dollar_per_lb) {
}
}正在尝试使用MaterialResource.java文件中的查询
//puts materials into map and the key is the material number
materialMap.put(materialValue, material);
MaterialRepository.uploadMaterialData(material.getMaterial_number(), material.getMaterial_thickness(),
material.getMaterial_size(), material.getLb_per_sheet(), material.getDollar_per_lb());回答 2
Stack Overflow用户
发布于 2015-05-02 15:43:52
将代码更改为
@Query("INSERT INTO hillcresttooldie (material_number,material_thickness,material_size,lb_per_sheet,dollar_per_lb) VALUES (:number, :thickness, :size, :lbPerSheet, :dollarPerLb)")
void uploadMaterialData(String number, BigDecimal thickness, String size, BigDecimal lbPerSheet, BigDecimal dollarPerLb)Stack Overflow用户
发布于 2015-05-02 15:47:19
尝试：
public interface MaterialRepository extends JpaRepository<Material,Long> {
@Modifying
@Query(nativeQuery = true,"INSERT INTO hillcresttooldie(material_number,material_thickness,material_size,lb_per_sheet,dollar_per_lb) VALUES (?1,?2,?3,?4,?5)")
static void uploadMaterialData(String material_number,BigDecimal material_thickness,String material_size,BigDecimal lb_per_sheet,BigDecimal dollar_per_lb) {
}}
public interface MaterialRepository extends JpaRepository<Material,Long> {
@Query("INSERT INTO hillcresttooldie(material_number) VALUES (:material_number)") //....
static void uploadMaterialData(@Param("material_number") String material_number) {
}}
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/29999683
复制相关文章
相似问题
腾讯云开发者
