SoFunction
Updated on 2025-05-20

How to solve the problem of mybatisplus error: getSqlFirst

mybatisplus error: getSqlFirst

mistake

: can not use this method for "getSqlFirst"

Code involved

query=lambdaQuery().eq(User::getId,id);
page(new Page(1,20),query);

reason

The correct way to write it should be

lambdaQuery().eq(User::getId,id).page(new Page(1,20);

Although the page method can receive the return value of lambdaQuery(), its comment has stated that the parameter must beQueryWrapper

/**
      * Page turn query
      *
      * @param page page turn object
      * @param queryWrapper Entity object encapsulation operation class {@link }
      */
    default <E extends IPage<T>> E page(E page, Wrapper<T> queryWrapper) {
        return getBaseMapper().selectPage(page, queryWrapper);
    }

Summarize

The above is personal experience. I hope you can give you a reference and I hope you can support me more.