mybatis-plus LambdaQueryWrapper分页查询+指定字段排序

最新推荐文章于 2025-10-24 11:19:15 发布

原创最新推荐文章于 2025-10-24 11:19:15 发布 · 710 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java

该文章已生成可运行项目，

当前端传递要排序的字段和排序的顺序时，后台又想使用LambdaQueryWrapper时可使用下面方法

public BaseResponse<Page<User>> listUserByPage(@RequestBody UserQueryRequest userQueryRequest) {
        ThrowUtils.throwIf(ObjUtil.isEmpty(userQueryRequest), ErrorCode.PARAMS_ERROR);
        LambdaQueryWrapper<User> qw = new LambdaQueryWrapper<>();
        qw.eq(ObjUtil.isNotNull(userQueryRequest.getId()), User::getId, userQueryRequest.getId());
        qw.like(StrUtil.isNotBlank(userQueryRequest.getUserName()), User::getUserName, userQueryRequest.getUserName());
        qw.like(StrUtil.isNotBlank(userQueryRequest.getUserAccount()), User::getUserAccount, userQueryRequest.getUserAccount());
        qw.like(StrUtil.isNotBlank(userQueryRequest.getUserProfile()), User::getUserProfile, userQueryRequest.getUserProfile());

        Page<User> objectPage = new Page<>(userQueryRequest.getCurrent(), userQueryRequest.getPageSize());
        //拼接排序条件
        if (StrUtil.isNotBlank(userQueryRequest.getSortField())) {
            OrderItem orderItem = new OrderItem();
            orderItem.setAsc("asc".equals(userQueryRequest.getSortOrder()));
            orderItem.setColumn(userQueryRequest.getSortField());
            objectPage.addOrder(orderItem);
        }
        Page<User> userPage = userService.page(objectPage, qw);
        return ResultUtils.success(userPage);
    }