java - 使用spring数据jpa的实体关系中的Orderby子句

Question

我有3个实体类如下。

分类实体

 @Entity
    @Table(name = "CLASZ")
    public class Clasz implements Serializable {        
        @Id
        @GeneratedValue(strategy = GenerationType.AUTO)
        @Column(name="CZ_ID")
        private Integer id;
        
        private String name;}

学生实体

@Entity
@Table(name = "STUDENT")
public class Student implements Serializable {
    
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name="S_ID")
    private Integer id;
    
    @Column(name = "S_NAME")
    private String name;
    
    @Column(name = "S_AGE")
    private int age;
    
    @OneToOne
    @JoinColumn(name="CZ_ID")
    private Clasz classz;
    
    @OneToMany
    @JoinColumn(name = "CAT_ID")
    @NotNull
    private List<Category> category;
    
    @Column(name = "S_DESCR")
    private String description; 

//  constructor / getter and Setter    }

类别实体

@Entity
@Table(name = "CATEGORY")
public class Category implements Serializable {
    
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    @Column(name="CAT_ID")
    private Integer id;
    
    @Column(name = "CAT_NAME")
    private String name;
    
    @Column(name = "CAT_DESCRI")
    private String description; 

}

我有一个扩展 JPARepository 的 StudentRepository 接口。按班级ID查找所有学生详细信息，结果应按类别名称排序。我写了一个类似的方法findAllByClaszIdOrderByCategoryNameAsc(int classId).

标签： javaspring-bootspring-data-jpa