mybatis—plus

自动填@Slf4j

@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        log.info("start insert fill ....");
        this.setFieldValByName("updateTime", new Date(),metaObject);
        this.setFieldValByName("updateTime", new Date(),metaObject);
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        log.info("start insert fill ....");
        this.setFieldValByName("updateTime", new Date(),metaObject);

    }


}

乐观锁

一.

@Version
private Integer version;

二.

//报  Parameter 'MP_OPTLOCK_VERSION_ORIGINAL' not found 的错  加上  OptimisticLockerInterceptor锁对象

@EnableTransactionManagement
@MapperScan("com.jiu.mybatis_plus.blog.mapper")
@Configuration
public class MyConfig {

    @Bean
    public OptimisticLockerInterceptor OptimisticLockerInnerInterceptor() {
        return new OptimisticLockerInterceptor();
    }


}






分页插件
 @Bean

    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
        return interceptor;
    }

Page<AclUser> pages= new Page<>(1,2);
aclUserMapper.selectPage(pages, null);
 pages.getRecords().forEach(System.out::println);
System.out.println(pages.getTotal());

条件构造器（AbstractWrapper）

 QueryWrapper<AclUser> wrapper = new QueryWrapper<>();

//查询姓名不为空，邮箱不为空的用户,年龄大于等于 链式编程

        wrapper.isNotNull("username")
                .isNotNull("nickName")
                .ge("age",12);
;        aclUserMapper.selectList(wrapper);