Mapper测试通过

admin

2020-12-01 3ac89536ba5f95cc31f510b8a63b23d8d6e745fd

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
package com.ks.lucky.util;
 
import org.springframework.data.domain.Sort;
 
import java.util.ArrayList;
import java.util.List;
 
public class MongoDBQueryUtil {
 
 
    /**
     * 转换sql语句的排序
     *
     * @param sortList
     * @return
     */
    public static Sort.Order[] convertSQLSort(List<String> sortList) {
        List<Sort.Order> sList = new ArrayList<>();
 
        for (String sort : sortList) {
            String key = "";
            if (sort.trim().contains(" ")) {
                key = sort.trim().split(" ")[0];
            } else {
                key = sort.trim();
            }
 
            if (sort.toLowerCase().endsWith(" desc")) {
                sList.add(Sort.Order.desc(key));
            } else {
                sList.add(Sort.Order.asc(key));
            }
        }
 
        Sort.Order[] sorts = new Sort.Order[sortList.size()];
        sList.toArray(sorts);
        return sorts;
    }
 
}