springboot如何引入mybatis和mybatisplus

奔跑的蜗牛FelixChioa

已于 2022-12-13 19:03:09 修改

阅读量4.7k

点赞数 2

分类专栏： Springboot 文章标签： java spring boot 后端

于 2021-07-07 17:31:17 首次发布

本文链接：https://blog.csdn.net/FeilxChioa/article/details/118552799

版权

Springboot 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

一.SpringBoot引入mybatis

Oracle数据源:

1.在pom.xml中添加myBatis和oracle数据库依赖.

<!-- 添加MyBatis依赖 -->
<dependency>
  		<groupId>org.mybatis.spring.boot</groupId>
  		<artifactId>mybatis-spring-boot-starter</artifactId>
  		<version>1.3.2</version>
</dependency>
<dependency>
  		<groupId>com.oralce.ojdbc</groupId>
  		<artifactId>ojdbc8</artifactId>
  		<version>19.3.0.0</version>
</dependency>
<dependency>
  		<groupId>cn.easyproject</groupId>
  		<artifactId>orai18n</artifactId>
  		<version>12.1.0.2.0</version>
</dependency>

2.在application.yml中配置数据源和mybatis的相关配置

spring:
  session:
    timeout: 1800
  datasource:
    driver-class-name: oracle.jdbc.OracleDriver
    url:  jdbc:oracle:thin:@96.x.x.x:1521:xxx
    username: xxx
    password: xxx
    hikari:
      maximum-pool-size: 10
      max-lifetime: 1770000

mybatis: 
	# 指定别名设置的包为所有entity 
	type-aliases-package: com.xxx.felix.springdemo.entity 
	configuration: map-underscore-to-camel-case: true # 驼峰命名规范 
	mapper-locations: classpath:mapper/*.xml

logging:
	config:logback-spring.xml
	level:
		com.xxx.felix.springdemo.dao: trace

mysql数据源:

1.在pom.xml中添加myBatis和mysql数据库依赖.

<dependency>
  	<groupId>org.mybatis.spring.boot</groupId>
  	<artifactId>mybatis-spring-boot-starter</artifactId>
  	<version>1.3.2</version>
</dependency>
		
<dependency> 
	<groupId>mysql</groupId> 
	<artifactId>mysql-connector-java</artifactId> 
	<scope>runtime</scope> 
</dependency>

2.在application.yml中配置数据源和mybatis的相关配置

server: 
  port: 8081
  servlet:
    context-path: /xxxx/xxx

spring:
  session:
    timeout: 1800
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url:  jdbc:mysql://127.0.0.1:3306/db_xxx?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&maxReconnects=10
    username: feifei
    password: xxx
    hikari:
      maximum-pool-size: 10

mybatis:
  type-aliases-package: com.xxx.felix.springdemo.entity
  mapper-locations: classpath:/mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true

logging:
  config: logback-spring.xml
  level:
   com.icbc.felix.springdemo.dao: trace

二.SpringBoot引入mybatisplus

1.mybatisplus简介

MyBatis-Plus（简称 MP）是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。是MyBatis的好基友^_^

2.mybatisplus2的引入方式

2.1在pom.xml中添加MyBatis-plus和相关数据库依赖

        <!-- 添加MyBatisplus依赖 -->
	    <dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>2.2.0</version>
		</dependency>
		<dependency>
  		    <groupId>com.oralce.ojdbc</groupId>
  		    <artifactId>ojdbc6</artifactId>
  		    <version>11.2.0.3</version>
	    </dependency>
	    <dependency>
  		    <groupId>cn.easyproject</groupId>
  		    <artifactId>orai18n</artifactId>
  		    <version>12.1.0.2.0</version>
	    </dependency>

2. 2在application.yml中配置数据源和mybatis-plus的基础配置

spring:
  session:
    timeout: 1800
  datasource:
    driver-class-name: oracle.jdbc.OracleDriver
    url:  jdbc:oracle:thin:@96.x.x.x:1521:xxx
    username: xxx
    password: xxx

mybatis-plus:
  # 如果是放在src/main/java目录下 classpath:/com/yourpackage/*/mapper/*Mapper.xml
  # 如果是放在resource目录 classpath:/mapper/*Mapper.xml
  mapper-locations: classpath:/mapper/*Mapper.xml
  #实体扫描，多个package用逗号或者分号分隔
  typeAliasesPackage: com.xxx.felix.springdemo.entity
  global-config:
    #主键类型  0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID";
    id-type: 0
    #字段策略 0:"忽略判断",1:"非 NULL 判断"),2:"非空判断"
    field-strategy: 2
    #驼峰下划线转换
    db-column-underline: true
    #刷新mapper 调试神器
    refresh-mapper: true
    #数据库大写下划线转换
    #capital-mode: true
    # Sequence序列接口实现类配置
    #key-generator: com.baomidou.mybatisplus.incrementer.OracleKeyGenerator
    #逻辑删除配置（下面3个配置）
    logic-delete-value: 1
    logic-not-delete-value: 0
    sql-injector: com.baomidou.mybatisplus.mapper.LogicSqlInjector
  configuration:
    #配置返回数据库(column下划线命名&&返回java实体是驼峰命名)，自动匹配无需as（没开启这个，SQL需要写as： select user_id as userId）
    map-underscore-to-camel-case: true
    cache-enabled: false
    #配置JdbcTypeForNull, oracle数据库必须配置
    jdbc-type-for-null: 'null'
    #mybatis的sql语句在标准控制台中输出
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

2.3.引入MyBatisPlusConfig,支持分页指定mapper.xml文件的扫描路径

package com.xxx.felix.springdemo.config;

import com.baomidou.mybatisplus.plugins.PaginationInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("com.xxx.felix.springdemo.mapper")
public class MyBatisPlusConfig {

    /*
     * 分页插件，自动识别数据库类型
     * 多租户，请参考官网【插件扩展】
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }


}

2.4.代码自动生成:使用MyBatisPlusGenertor工程下的MainApp生成对应的mapper.xml,mapper层，service层，service.impl层和ctl层代码.因为是旧版本，这里略掉。

3.mybatisplus3的引入方式

mybatisplus3是原来2的版本升级，许多api接口都做了改动，不太理解为什么要这样做，感觉对开发者不太友好。

3.1在pom.xml中添加MyBatis-plus和相关数据库依赖

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	
	<modelVersion>4.0.0</modelVersion>	
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.2.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	
	<groupId>com.xxx.felix</groupId>
	<artifactId>springdemoplus2</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>
	<name>springdemoplus2</name>
	<description>Demo project for Spring Boot</description>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
        <maven-jar-plugin.version>2.6</maven-jar-plugin.version>
		<module.name>springdemoplus2</module.name>
		<failOnMissingWebXml>false</failOnMissingWebXml>
	</properties>
	<!--spring-boot-->
	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<optional>true</optional>
		</dependency>
		<!--spring-boot-->

		
		<!-- 添加MyBatis-plus依赖 -->
		<dependency>
			<groupId>com.baomidou</groupId>
			<artifactId>mybatis-plus-boot-starter</artifactId>
			<version>3.5.1</version>
		</dependency>
		
		<!-- 代码生成器 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-generator</artifactId>
            <version>3.5.1</version>
        </dependency>
		
		<dependency> 
			<groupId>mysql</groupId> 
			<artifactId>mysql-connector-java</artifactId> 
			<scope>runtime</scope>
		</dependency>
		
		<!--velocity-->
		<dependency>
		    <groupId>org.apache.velocity</groupId>
		    <artifactId>velocity-engine-core</artifactId>
		    <version>2.3</version>
		</dependency>
		
		 <!-- FreeMarker 模板引擎 -->
        <dependency>
            <groupId>org.freemarker</groupId>
            <artifactId>freemarker</artifactId>
            <version>2.3.31</version>
        </dependency>
		
		<!--swagger-->
		<dependency>
		    <groupId>io.swagger</groupId>
		    <artifactId>swagger-annotations</artifactId>
		    <version>1.6.3</version>
		</dependency>

		<dependency>
		    <groupId>org.projectlombok</groupId>
		    <artifactId>lombok</artifactId>
		</dependency>
		<!-- <dependency>
  			<groupId>com.oracle.ojdbc</groupId>
  			<artifactId>ojdbc8</artifactId>
  			<version>19.3.0.0</version>
		</dependency>
		
		<dependency>
  			<groupId>cn.easyproject</groupId>
			<artifactId>orai18n</artifactId>
			<version>12.1.0.2.0</version>
		</dependency> -->
		
		<!-- <dependency>
			<groupId>org.slf4j</groupId>
			<artifactId>slf4j-log4j12</artifactId>
			<version>1.7.5</version>
		</dependency> -->
		 
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<fork>true</fork><!-- 如果没有改配置，devtools无法生效 -->
				</configuration>
			</plugin>
		</plugins>
	</build>

</project>

3. 2在application.yml中配置数据源和mybatis-plus3的基础配置

server: 
  port: 8789
  servlet:
    context-path: /icbc/gzfh

spring:
  session:
    timeout: 1800
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url:  jdbc:mysql://127.0.0.1:3306/db_xxx?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&maxReconnects=10
    username: xxx
    password: xxx
    hikari:
      maximum-pool-size: 10

mybatis-plus:
  # 如果是放在src/main/java目录下 classpath:/com/yourpackage/*/mapper/*Mapper.xml
  # 如果是放在resource目录 classpath:/mapper/*Mapper.xml
  mapper-locations: classpath:/mapper/*Mapper.xml
  #实体扫描，多个package用逗号或者分号分隔
  typeAliasesPackage: com.icbc.felix.springdemo.entity
  global-config:
    db-config:
      #主键类型  0:"数据库ID自增", 1:"用户输入ID",3:"全局唯一ID (数字类型唯一ID)", 4:"全局唯一ID UUID";
      id-type: ASSIGN_ID
      #数据库大写下划线转换
      #capital-mode: true
      # Sequence序列接口实现类配置
      #key-generator: com.baomidou.mybatisplus.incrementer.OracleKeyGenerator
      #逻辑删除配置（下面3个配置）
      logic-delete-field: deleted
      logic-delete-value: 1
      logic-not-delete-value: 0
  configuration:
    #配置返回数据库(column下划线命名&&返回java实体是驼峰命名)，自动匹配无需as（没开启这个，SQL需要写as： select user_id as userId）
    map-underscore-to-camel-case: true
    cache-enabled: false
    #配置JdbcTypeForNull, oracle数据库必须配置
    jdbc-type-for-null: 'null'
    #mybatis的sql语句在标准控制台中输出
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  
logging:
  config: logback-spring.xml
  level:
   com.xxx.felix.springdemo.mapper: trace

3.3 分页和乐观锁的支持，需要注册插件

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.OptimisticLockerInnerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;

@Configuration
public class MyBatisPlusConfig {

    /*
     * 注册分页插件
     * 多租户，请参考官网【插件扩展】
     * 
     */
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();        
        // 分页插件
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        // 乐观锁插件
        interceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return interceptor;
    }

3.4 自动代码生成工具，亲测可用!(注意在pom.xml中需要引入代码生成器和模板引擎)

话不多说，上代码

import java.util.Collections;

import com.baomidou.mybatisplus.annotation.FieldFill;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.generator.FastAutoGenerator;
import com.baomidou.mybatisplus.generator.config.OutputFile;
import com.baomidou.mybatisplus.generator.config.rules.DateType;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;
import com.baomidou.mybatisplus.generator.engine.VelocityTemplateEngine;
import com.baomidou.mybatisplus.generator.fill.Column;

public class AutoGenerator {
    //自动生成模式
    public static void main(String[] args) {
        //1、配置数据源
        FastAutoGenerator.create("jdbc:mysql://127.0.0.1:3306/db_xxx?serverTimezone=UTC&useSSL=false&useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false&maxReconnects=10", "数据库用户名", "数据库密码")
                //2、全局配置
                .globalConfig(builder -> {
                    builder.author("FelixChioa") // 设置作者名
                            .outputDir(System.getProperty("user.dir") + "/src/main/java")   //设置输出路径：项目的 java 目录下
                            .commentDate("yyyy-MM-dd hh:mm:ss")   //注释日期
                            .dateType(DateType.TIME_PACK)   //定义生成的实体类中日期的类型 TIME_PACK=LocalDateTime;ONLY_DATE=Date;
                            .fileOverride()   //覆盖之前的文件
                            .enableSwagger()   //开启 swagger 模式
                            .disableOpenDir();   //禁止打开输出目录，默认打开
                })
                //3、包配置
                .packageConfig(builder -> {
                    builder.parent("com.xxx.felix.springdemo") // 设置父包名
                            .moduleName("")   //设置模块包名
                            .entity("entity")   //pojo 实体类包名
                            .service("service") //Service 包名
                            .serviceImpl("service.impl") // ***ServiceImpl 包名
                            .mapper("mapper")   //Mapper 包名
                            .xml("mapper")  //Mapper XML 包名
                            .controller("controller") //Controller 包名
                            .other("utils") //自定义文件包名
                            .pathInfo(Collections.singletonMap(OutputFile.mapperXml, System.getProperty("user.dir") + "/src/main/resources/mapper"));    //配置 mapper.xml 路径信息：项目的 resources 目录下
                })
                //4、策略配置
                .strategyConfig(builder -> {
                    builder.addInclude("shop", "") // 设置需要生成的数据表名
                            .addTablePrefix("t_", "c_") // 设置过滤表前缀

                            //4.1、Mapper策略配置
                            .mapperBuilder()
                            .superClass(BaseMapper.class)   //设置父类
                            .enableBaseResultMap()
                            .enableBaseColumnList()
                            .formatMapperFileName("%sMapper")   //格式化 mapper 文件名称
                            .enableMapperAnnotation()       //开启 @Mapper 注解
                            .formatXmlFileName("%sMapper")//格式化 Xml 文件名称

                            //4.2、service 策略配置
                            .serviceBuilder()
                            .formatServiceFileName("%sService") //格式化 service 接口文件名称，%s进行匹配表名，如 UserService
                            .formatServiceImplFileName("%sServiceImpl") //格式化 service 实现类文件名称，%s进行匹配表名，如 UserServiceImpl

                            //4.3、实体类策略配置
                            .entityBuilder()
                            //.enableLombok() //开启 Lombok
                            .disableSerialVersionUID()  //不实现 Serializable 接口，不生产 SerialVersionUID
                            .logicDeleteColumnName("deleted")   //逻辑删除字段名
                            .naming(NamingStrategy.underline_to_camel)  //数据库表映射到实体的命名策略：下划线转驼峰命
                            .columnNaming(NamingStrategy.underline_to_camel)    //数据库表字段映射到实体的命名策略：下划线转驼峰命
                            .addTableFills(
                                    new Column("create_time", FieldFill.INSERT),
                                    new Column("modify_time", FieldFill.INSERT_UPDATE)
                            )   //添加表字段填充，"create_time"字段自动填充为插入时间，"modify_time"字段自动填充为插入修改时间
                            .enableTableFieldAnnotation()       // 开启生成实体时生成字段注解

                            //4.4、Controller策略配置
                            .controllerBuilder()
                            .formatFileName("%sController") //格式化 Controller 类文件名称，%s进行匹配表名，如 UserController
                            .enableRestStyle();  //开启生成 @RestController 控制器
                })
                //5、模板
                .templateEngine(new VelocityTemplateEngine())
                /*
                    .templateEngine(new FreemarkerTemplateEngine())
                    .templateEngine(new BeetlTemplateEngine())
                */
                
                //6、执行
                .execute();
    }
}

觉得不错就动动小手点个赞吧！

生活不易，作者除了平时当码工以外还在兼职卖些手办，感兴趣的朋友可以看看哟，谢谢！

watermark,type_d3F5LXplbmhlaQ,shadow_50,text_Q1NETiBA5aWU6LeR55qE6JyX54mbRmVsaXhDaGlvYQ==,size_20,color_FFFFFF,t_70,g_se,x_16

奔跑的蜗牛FelixChioa

关注

2
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
springboot如何引入mybatis和mybatisplus

MyBatis-Plus（简称 MP）是一个 MyBatis 的增强工具，在 MyBatis 的基础上只做增强不做改变，为简化开发、提高效率而生。是MyBatis的好基友^_^
复制链接

扫一扫

专栏目录