我有一entity - Team
資料欄下如下
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private Long id;
private String contestitem;
private String schoolname;
private String username;
private String membername;
private String instructor;
private String location;
private String description;
private String comments;
搜尋時想先依location排序, 再依schoolname 最後依 contestitem 排序
做法, 在 TeamRepository裡加上
public interface TeamRepository extends CrudRepository<Team, Long> {
List<Team> findAll(Sort sort);
}
查詢的語法如下
List<Team> teams = teamRepository.findAll(Sort.by("location").and(Sort.by("schoolname")).and(Sort.by("description").and(Sort.by("contestitem"))));
參考:
https://bezkoder.com/spring-data-sort-multiple-columns/
END
