mybatis plus分页使用使用

1. 导入依赖

2. 配置

2.1 插页配置

import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("com.zym.test.mapper")
public class MyBatisPlusConfig {
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

2.2 yml配置

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/cloud-user
mybatis:
  mapper-locations: classpath:mapper/*.xml

3. 实体

@Data
@AllArgsConstructor
@NoArgsConstructor
@TableName("tb_user")
public class user {

    @TableId("id")
    private Integer userId;
    @TableField("username")
    private String userName;
    @TableField("address")
    private String address;
}

4. controller

@Controller
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @GetMapping("/listUser")
    @ResponseBody
    public IPage<user> listUser(int pageNum, int pageSize){
        IPage<user> userByPage = userService.getUserByPage(pageNum,pageSize);

        return userByPage;
    }

}

如果只想返回数据，请改返回为List，并且getRecords,下面是返回了页码等

5 service

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.zym.test.mapper.UserMapper;
import com.zym.test.pojo.user;
import com.zym.test.service.UserService;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
@Service
public class UserServiceImpl implements UserService {

    @Resource
    private UserMapper userMapper;

    public IPage<user> getUserByPage(int pageNum, int pageSize) {
        IPage<user> page = (IPage<user>) new Page<user>(pageNum,pageSize);
        page.setCurrent(pageNum);
        page.setSize(page.getSize());
        page.setTotal(page.getTotal()) ;
        page.setPages(page.getPages());
        IPage<user> userIPage = userMapper.selectPage(page, null);
        return userIPage;
    }
}

6. mapper

@Repository
public interface UserMapper extends BaseMapper<user> {
}