sql自定义字段排序与Java集合排序

mysql

select * from city order by FIELD(region,'杭州市','宁波市','温州市','嘉兴市','湖州市','绍兴市','金华市','衢州市','舟山市','台州市','丽水市') asc

pgsql

select * from tb_standard_project order by (company_name='建设单位',company_name='建设单位1',company_name='建设单位2') desc

java

List根据指定顺序排序：

1.加入依赖：

<dependency>
 <groupId>org.apache.commons</groupId>
 <artifactId>commons-collections4</artifactId>
 <version>4.4</version>
</dependency>
2.
//orders 自定义排序规则
ArrayList<String> orders = new ArrayList<>();
Collections.addAll(orders, "生命健康", "信息产业", "先进材料","高端制造","传统产业","新能源及智能网联汽车","绿色产业");//指定的顺序

FixedOrderComparator<String> fixedOrderComparator = new FixedOrderComparator<>(orders);
//FixedOrderComparator.UnknownObjectBehavior.AFTER 不在自定义集合里的数据排在最后
fixedOrderComparator.setUnknownObjectBehavior(FixedOrderComparator.UnknownObjectBehavior.AFTER);
//labels待排序的集合
labels.sort(fixedOrderComparator);