mybatis_plus笔记

项目构建

1.添加依赖

	<!-- 数据库驱动 -->
	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
	</dependency>
	<!-- lombok -->
	<dependency>
   		<groupId>org.projectlombok</groupId>
	    <artifactId>lombok</artifactId>
	</dependency>
	<!-- mybatis-plus --> <!-- mybatis-plus 是自己开发，并非官方的！ -->
	<dependency>
		<groupId>com.baomidou</groupId>
	    <artifactId>mybatis-plus-boot-starter</artifactId>
	    <version>3.0.5</version>
	</dependency>
	
	<!--模板引擎 依赖:mybatis-plus代码生成的时候报异常-->
	<dependency>
	    <groupId>org.apache.velocity</groupId>
	    <artifactId>velocity-engine-core</artifactId>
	    <version>2.0</version>
	</dependency>
	<!--配置ApiModel在实体类中不生效-->
	<dependency>
	    <groupId>com.spring4all</groupId>
	    <artifactId>spring-boot-starter-swagger</artifactId>
	    <version>1.5.1.RELEASE</version>
	</dependency>
	<!--freemarker-->
	<dependency>
	    <groupId>org.freemarker</groupId>
	    <artifactId>freemarker</artifactId>
	    <version>2.3.30</version>
	</dependency>
	<!--beetl-->
	<dependency>
	    <groupId>com.ibeetl</groupId>
	    <artifactId>beetl</artifactId>
	    <version>3.3.2.RELEASE</version>
	</dependency>
    

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/*.xml

3. 代码生成器

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.po.TableFill;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import org.junit.jupiter.api.Test;
import org.springframework.boot.test.context.SpringBootTest;
import java.util.ArrayList;

   @Test
   void contextLoads() {
       //我们需要构建一个代码生成器对象
       AutoGenerator mpg = new AutoGenerator();
       //怎么样去执行，配置策略

       //1、全局配置
       GlobalConfig gc = new GlobalConfig();
       gc.setOutputDir(System.getProperty("user.dir") + "/src/main/java");//输出到哪个目录
       gc.setAuthor("xhz");
       gc.setOpen(false);
       gc.setFileOverride(false);//是否覆盖
       gc.setServiceName("%sService");//去Service的I前缀 例如：%sBusiness 生成 UserBusiness
       gc.setIdType(IdType.ID_WORKER);
       gc.setDateType(DateType.ONLY_DATE);
       gc.setSwagger2(true);

       mpg.setGlobalConfig(gc);

       //2、设置数据源
       DataSourceConfig dsc = new DataSourceConfig();
       dsc.setUsername("root");
       dsc.setPassword("root");
       dsc.setUrl("jdbc:mysql://localhost:3306/mybatis_plus? useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8");
       dsc.setDriverName("com.mysql.cj.jdbc.Driver");
       dsc.setDbType(DbType.MYSQL);

       mpg.setDataSource(dsc);

       //3、包的配置
       PackageConfig pc = new PackageConfig();
       //pc.setModuleName("mybatis");//添加一个父类包名com.xhz.mybatis
       pc.setParent("com.xhz");//这里写上原本的目录com.xhz
       pc.setEntity("pojo");//com.xhz.mybatis.poji
       pc.setMapper("mapper");
       pc.setService("service");
       pc.setController("controller");

       mpg.setPackageInfo(pc);

       //4、策略配置
       StrategyConfig strategy = new StrategyConfig();
       strategy.setInclude("user", "teacher", "student");//设置要映射的表名,只需改这里即可
       strategy.setNaming(NamingStrategy.underline_to_camel);
       strategy.setColumnNaming(NamingStrategy.underline_to_camel);
       strategy.setEntityLombokModel(true);//是否使用lombok开启注解

       strategy.setLogicDeleteFieldName("deleted");

       //自动填充配置
       TableFill gmtCreate = new TableFill("create_time", FieldFill.INSERT);
       TableFill gmtUpdate = new TableFill("update_time", FieldFill.INSERT_UPDATE);
       ArrayList<TableFill> tableFills = new ArrayList<>();
       tableFills.add(gmtCreate);
       tableFills.add(gmtUpdate);

       strategy.setTableFillList(tableFills);

       //乐观锁配置
       strategy.setVersionFieldName("version");
       strategy.setRestControllerStyle(true);//开启驼峰命名
       strategy.setControllerMappingHyphenStyle(true);//localhost:8080/hello_id_2
       mpg.setStrategy(strategy);
       mpg.execute();//执行
   }

4.配置类 package com.xhz.config;

@Configuration//配置类
@EnableTransactionManagement
@MapperScan("com.xhz.mapper")// 扫描我们的 mapper 文件夹
public class MyBatisPlusConfig {

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

    // 注册乐观锁插件  新版 3.4.0
    /*@Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return mybatisPlusInterceptor;
    }*/

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

    /*//  分页插件最新版
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
        return interceptor;
    }*/

    // 逻辑删除组件！  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);
   }
}

springbook整合mybatis_plus xml文件位置

如果xml文件在resources目录下

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

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

• 参考 跳转

    <build>
       <resources>
           <resource>
               <!-- xml放在java目录下-->
               <directory>src/main/java</directory>
               <includes>
                   <include>**/*.xml</include>
               </includes>
               <filtering>false</filtering>
           </resource>
           <resource>
               <directory>${basedir}/src/main/resources</directory>
               <includes>
                   <include>*.yml</include>
                   <include>*.yaml</include>
                   <include>*.properties</include>
                   <include>*.xml</include>
               </includes>
           </resource>
       </resources>
   </build>
   
#mybatis-plus配置
mybatis-plus.type-aliases-package=com.xhz.pojo
mybatis-plus.mapper-locations=classpath:/com/xhz/mapper/xml/*.xml