本文介绍了PagingAndSortingRepository 如何排序不区分大小写?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的问题是我的代码对结果区分大小写进行排序.
My Problem is that my code sorts the result case-sensitive.
下面是我的代码:
@GetMapping("/user/api_key_list") public ModelAndView apiKeyList(Model model, @RequestParam("pageSize") Optional<Integer> pageSize, @RequestParam("page") Optional<Integer> page, @RequestParam("sortBy") Optional<String> sortBy ) { ModelAndView modelAndView = new ModelAndView("user/apikeylist"); int evalPageSize = pageSize.orElse(INITIAL_PAGE_SIZE); int evalPage = (page.orElse(0) < 1) ? INITIAL_PAGE : page.get() - 1; String sortOrder = sortBy.orElse(INITIAL_SORT); String[] sort = sortOrder.split(","); String evalSort = sort[0]; String sortDirection = sort[1]; Sort.Direction evalDirection = replaceOrderStringThroughDirection(sortDirection); Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, evalDirection, evalSort)); PagerModel pager = new PagerModel(apiKeyList.getTotalPages(), apiKeyList.getNumber(), BUTTONS_TO_SHOW); modelAndView.addObject("apiKeyList", apiKeyList); modelAndView.addObject("selectedPageSize", evalPageSize); modelAndView.addObject("pageSizes", PAGE_SIZES); modelAndView.addObject("pager", pager); modelAndView.addObject("selectedSort", String.format("%s,%s", evalSort, sortDirection)); modelAndView.addObject("sorts", SORTS); return modelAndView; }我的问题是:如何排序不区分大小写?
My question is: How can I sort it case-insensitive?
推荐答案好吧,如果你使用的是 spring-data-jpa,你可以这样做
Well if you are using spring-data-jpa you can do like this
Sort.Order order = new Sort.Order(Sort.Direction.ASC, "columnName").ignoreCase();并在查询中传递此订单.
and pass this Order in query.
就你而言
Page<ApiKey> apiKeyList = apiKeyRepository.findAll(PageRequest.of(evalPage, evalPageSize, new Sort(order)));编辑 1:
对于较新版本的 Spring,不推荐使用上述方法.
For newer version of Spring above method is deprecated.
只需添加 Dullimeister 添加的代码即可完成答案
just adding code added by Dullimeister to complete answer
Sort sortOrderIgnoreCase = Sort.by(new Sort.Order(evalDirection,evalSort).ignoreCase());更多推荐
PagingAndSortingRepository 如何排序不区分大小写?
发布评论