Mybatis-Plus分页查询

    org.projectlombok
    lombok
    true


    mysql
    mysql-connector-java


    com.baomidou
    mybatis-plus-boot-starter
    3.0.5

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/mybatis
    driver-class-name: com.mysql.jdbc.Driver
#配置日志
mybatis-plus:
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

@Data
@AllArgsConstructor
@NoArgsConstructor
public class user implements Serializable {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    private Integer age;
    private String email;

    @Version//乐观锁注解
    private Integer version;

    @TableField(fill = FieldFill.INSERT)
    private Date createTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;
}

@Repository
public interface mapper extends baseMapper  {

}

//扫描mapper包
@MapperScan("com.xys.Mapper")
@EnableTransactionManagement
@Configuration//配置类
public class MybatisConfig {

    //注册乐观锁插件
    @Bean
    public OptimisticLockerInterceptor optimisticLockerInterceptor(){
        return new OptimisticLockerInterceptor();
    }

    //分页插件
    @Bean
    public PaginationInterceptor paginationInterceptor(){
        return new PaginationInterceptor();
    }
}

@Slf4j
@Component
public class MymetaObjectHandler implements metaObjectHandler {
    //插入时的填充策略
    @Override
    public void insertFill(metaObject metaObject) {
        log.info("start insert info....");
        this.setFieldValByName("createTime",new Date(),metaObject);
        this.setFieldValByName("updateTime",new Date(),metaObject);
    }

    //更新时的填充策略
    @Override
    public void updateFill(metaObject metaObject) {
        log.info("start update info....");
        this.setFieldValByName("updateTime",new Date(),metaObject);
    }
}

分页在网站使用的十分之多!

1、原始的limit进行分页

2、pageHelper第三方插件

3、MP其实也内置了分页插件!

//测试分页查询
@Test
void testPage(){
    Page page=new Page<>(1,5);
    mapper.selectPage(page,null);
    page.getRecords().forEach(System.out::println);
}