我是springboot的新手,在JPQL中面临问题,nativeQuery。在进行读取操作时,本机查询正在中工作
@Query(value="select * from student s where s.name= :name", nativeQuery=true)
List<Student> getStudentByName(String name);
在数据库上执行删除操作时工作,但不工作
@Query(value="delete from student s where s.name= :name",nativeQuery = true)
void deleteStudentByName(String name);
实体类
package com.example.demo.test.entity;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
@Entity
public class Student {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
private Long id;
private String name;
private Integer age;
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
}
请帮忙。谢谢
写入操作需要与读取操作不同地执行,您还需要使用@Modification注释来注释存储库方法。因此,将@Modifying置于删除查询之上。
@Modifying
@Query(value="delete from student s where s.name= :name",nativeQuery = true)
void deleteStudentByName(String name);
我建议你不要写nativeQuery并学习JPQL,因为
- 本机查询结果的分页需要额外的步骤
- Spring Data JPA不支持对本机SQL语句进行动态排序
只需尝试在回购中使用此代码
@Modifying
@Transactional
@Query(value="delete from student s where s.name= ?1",nativeQuery = true)
void deleteStudentByName(String name);
Use可以使用类似void deleteByteName(字符串名称(的JPQL查询;
您可以尝试此查询
@Query("DELETE FROM Student c WHERE c.name = ?1")
void deleteStudentByName(String name);
我建议您学习如何编写JPQL查询:https://www.javatpoint.com/jpa-jpql-introduction