[JPA] @Orderby Annotation

@OneToMany나 @ManyToOne 연관관계 설정시 @Orderby로 정렬을 할 수 있다.

 

@OneToMany(fetch=FetchType.LAZY, cascade = CascadeType.ALL)
@OrderBy(clause = "key")
@JoinColumns({
     @JoinColumn(name="A", referencedColumnName="A", insertable = false, updatable = false), 
     @JoinColumn(name="B", referencedColumnName="B", insertable = false, updatable = false)
})
private List<Amount> amountList;

@ManyToOne(fetch=FetchType.LAZY, cascade = CascadeType.ALL)
@JoinColumns({
        @JoinColumn(name = "A", referencedColumnName = "A" , insertable = false, updatable = false),
        @JoinColumn(name = "B", referencedColumnName = "B" , insertable = false, updatable = false),
})
@OrderBy(value = "key")
private Member member

// 내림차순
@OrderBy("key DESC")

// 오름차순
@OrderBy("key ASC")