老師，查詢出來的數據還是所有的數據 控制臺sql沒有輸出 limit阿 你看配置代碼吧
package com.mp.configuration;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
? ?@Bean
? ?public PaginationInterceptor paginationInterceptor(){
? ? ? ?return new PaginationInterceptor();
? ?}
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
? ?@Bean
? ?public PaginationInterceptor paginationInterceptor(){
? ? ? ?return new PaginationInterceptor();
? ?}
}
@Test
public?void?selectPyLambdaWrappersix13?()?{
????//LambdaQueryWrapper<User>?lambdaQuery?=?Wrappers.<User>lambdaQuery();
????//lambdaQuery.ge(User::getAge,"26");
????QueryWrapper<User>?queryWrapper?=?new?QueryWrapper<User>();
????queryWrapper.ge("age","26");
????IPage<User>?iPage?=?userMapper.selectPage(new?Page<User>(1,2),queryWrapper);
????List<User>?userList?=?iPage.getRecords();
????for?(User?user?:?userList)?{
????????System.out.println("--"+user.getName());
????}
}
2019-10-08
正常的話，不應該出現這個問題呀，你調用selectPage方法，日志打印出的是一條select還是兩條？正常應該是兩條，一條沒有limit查總記錄數的，一條是有limit查記錄的。