注入到spring @Configuration public class MybatisConfig { public class mybatisPlusConfig { @Bean public PaginationInterceptor paginationInterceptor(){ return new PaginationInterceptor(); } } }

映射文件Mapper.xml 标签属性详解 https://blog.csdn.net/shmily_lsl/article/details/79371600

导包 配置 和和 代码生成器 mybatis-plus: mapper-locations: classpath:mapper/*.xml type-aliases-package: com.Taobao.entity configuration: map-underscore-to-camel-case: true //下划线转驼峰<dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> <version>3.3.1.tmp</version> </dependency> <!--locadate/locadatetime的时间依赖--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-typehandlers-jsr310</artifactId> <version>1.0.2</version> </dependency> <!--代码生成器--> <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-generator</artifactId> <version>3.3.1.tmp</version> </dependency> <!-- 添加 模板引擎 依赖 --> <dependency> <groupId>org.freemarker</groupId> <artifactId>freemarker</artifactId> <version>2.3.28</version> <scope>compile</scope> </dependency>D:\Users\XiaoXiao\Desktop\利福村\java

开启延迟加载 <settings> <!--开启全局的懒加载--> <setting name="lazyLoadingEnabled" value="true"/> <!--关闭立即加载，其实不用配置，默认为false--> <setting name="aggressiveLazyLoading" value="false"/> </settings>

@TableField 自动填充 如数据库时间的自动更新 实体类上的注解：//插入时填充 @TableField(fill = FieldFill.INSERT) private Date createTime; //插入与更新都填充 @TableField(fill = FieldFill.INSERT_UPDATE) private Date updateTime;处理器的实现：@Slf4j @Component //继承MetaObjectHandler来实现填充 public class MyMetaObjectHandler implements MetaObjectHandler { //插入时的填充策略 @Override public void insertFill(MetaObject metaObject) { log.info("start insert fill..."); //三个参数为 //要设置的属性名字 值 metaObject this.setFieldValByName("createTime",new Date(),metaObject); this.setFieldValByName("updateTime",new Date(),metaObject); } //更新时的填充策略 @Override public void updateFill(MetaObject metaObject) { log.info("start update fill..."); this.setFieldValByName("updateTime",new Date(),metaObject); } }