Mybatis动态实现多字段排序

请求格式为string类型，每个字段用逗号隔开

   

 

将排序字段和排序内容用Map封装:

   

/**
 * @param sortName 排序字段
 * @param  sortState 排序
 * */
public static Map getSort(String sortName,String sortState) {
    Map<String, String> sortmap = new HashMap<>();
    String[] keys = sortName.split(",");
    String[] types = sortState.split(",");
    for (int i = 0; i < keys.length; i++) {
        sortmap.put(keys[i],types[i]);
    }
    Map<String, String> resultMap = new HashMap<>();
    for (Map.Entry<String, String> entry : sortmap.entrySet()) {
        String key =entry.getKey();
        resultMap.put(key, entry.getValue());
    }
    return resultMap;

}

Mapper映射:

    注:用${}映射不是用#{}