mybatis

1.添加依赖

	
	
		mysql
		mysql-connector-java
	
	
	
   		org.projectlombok
	    lombok
	
	 
	
		com.baomidou
	    mybatis-plus-boot-starter
	    3.0.5
	
	
	
	
	    org.apache.velocity
	    velocity-engine-core
	    2.0
	
	
	
	    com.spring4all
	    spring-boot-starter-swagger
	    1.5.1.RELEASE
	
	
	
	    org.freemarker
	    freemarker
	    2.3.30
	
	
	
	    com.ibeetl
	    beetl
	    3.3.2.RELEASE
	
    

2.配置application.properties

spring.profiles.active=dev
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis_plus? useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
# 逻辑已删除值(默认为 1)
mybatis-plus.global-config.db-config.logic-delete-value=1
# 逻辑未删除值(默认为 0)
mybatis-plus.global-config.db-config.logic-not-delete-value=0

#mybatis配置
mybatis-plus.type-aliases-package=com.xhz.pojo
mybatis-plus.mapper-locations=classpath:mybatis/mapper

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

    

    // 逻辑删除组件！  3.3.0 逻辑删除不需要添加这个
    @Bean
    public ISqlInjector sqlInjector() {
        return new LogicSqlInjector();
    }

    //SQL执行效率插件
    @Bean
    @Profile({"dev", "test"})// 设置 dev test 环境开启，保证我们的效率
    public PerformanceInterceptor performanceInterceptor() {
        PerformanceInterceptor performanceInterceptor = new PerformanceInterceptor();
        performanceInterceptor.setMaxTime(100);
        // ms设置sql执行的最大时间，如果超过了则不 执行
        performanceInterceptor.setFormat(true); // 是否格式化代码
        return performanceInterceptor;
    }
}

5配置拦截器 package com.xhz.handler;

@Slf4j
@Component
public class MymetaObjectHandler implements metaObjectHandler {
   // 插入时的填充策略
   @Override
   public void insertFill(metaObject metaObject) {
       log.info("start insert fill ....");
       // 起始版本 3.3.0(推荐使用)
       //this.strictInsertFill(metaObject, "createTime", LocalDateTime.class, LocalDateTime.now());
       //this.strictInsertFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());

       //3.0.5
       this.setFieldValByName("createTime", new Date(), metaObject);//创建时加载时间
       this.setFieldValByName("updateTime", new Date(), metaObject);//更新时加载时间
   }

   // 更新时的填充策略
   @Override
   public void updateFill(metaObject metaObject) {
       log.info("start update fill.....");
       // 起始版本 3.3.0(推荐)
       //this.strictUpdateFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());

       this.setFieldValByName("updateTime",new Date(),metaObject);
   }
}

如果xml文件在resources目录下

#mybatis-plus配置
mybatis-plus.type-aliases-package=com.xhz.pojo
mybatis-plus.mapper-locations=classpath:mybatis/mapper/*.xml

如果在mapper目录下,需要配置maven

• 参考 跳转

    
       
           
               
               src/main/java
               
                   **/*.xml
               
               false
           
           
               ${basedir}/src/main/resources
               
                   *.yml
                   *.yaml
                   *.properties
                   *.xml
               
           
       
   
   
#mybatis-plus配置
mybatis-plus.type-aliases-package=com.xhz.pojo
mybatis-plus.mapper-locations=classpath:/com/xhz/mapper/xml/*.xml