在开发JPA中,遇见需要对数据进行多属性排序的情况,例如
select * from MldmasView order by vslName ASC,custName ASC,docDate DESC;
导入jar包
import org.springframework.data.domain.Sort.Order;
代码示例
List<Sort.Order> list = new ArrayList<>();
Order order1 = new Order(Direction.ASC, "vslName");
Order order2 = new Order(Direction.ASC, "custName");
Order order3 = new Order(Direction.DESC, "docDate");
list.add(order1);
list.add(order2);
list.add(order3);
Sort sort = Sort.by(list);
final List<MldmasView> mldmasViews = this.mldmasViewRepository
.findAll(sort);
完成对 mldmasViews 的排序