SpringBoot集成Myabtis

太过爱你忘了你带给我的痛 2022-09-05 00:10 71阅读 0赞

## 二、SpringBoot集成Myabtis ##

### 2.1. pom 依赖 ###

<dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.2</version>
            </dependency>
            
        
           <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${ mysql.version}</version>
            </dependency>
        
           <dependency>
                 <groupId>com.oracle</groupId>
                 <artifactId>ojdbc6</artifactId>
                 <version>${ oracle.version}</version>
             </dependency>

注：数据库任选其一即可

### 2.2. yml配置 ###

mybatis:
      configuration:
        map-underscore-to-camel-case: true
        # 控制台日志配置
        log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
      mapper-locations: classpath:mappers/*.xml

### 2.3. 启动类+扫描mapper包注解 ###

package com.gblfy;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan(basePackages = "com.gblfy.mapper")
    public class DemoApplication { 
    
        public static void main(String[] args) { 
            SpringApplication.run(DemoApplication.class, args);
        }
    }

## 三、集成Mybatis Generator ##

适配Mysql和Oracle

### 3.1. 插件集成 ###

官网链接：[https://mybatis.org/generator/running/runningWithMaven.html][https_mybatis.org_generator_running_runningWithMaven.html]

<build>
            <plugins>
                
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <verbose>true</verbose>
                        
                        <overwrite>true</overwrite>
                    </configuration>
                    <dependencies>
                        
                        <dependency>
                            <groupId>com.oracle</groupId>
                            <artifactId>ojdbc6</artifactId>
                            <version>${ oracle.version}</version>
                        </dependency>
                        
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>${ mysql.version}</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>

### 3.2. 新建generatorConfig.xml文件 ###

在resources目录下面  
内容如下：

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
        <context id="testTables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
            </commentGenerator>
            
            
            
            <jdbcConnection driverClass="oracle.jdbc.driver.OracleDriver"
                            connectionURL="jdbc:oracle:thin:@192.168.0.12:1521:orcl"
                            userId="scoptt"
                            password="scoptt">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.gblfy.mall.pojo"
                                targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.gblfy.mall.mapper"
                             targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.gblfy.mall.dao"
                                 targetProject="src/main/java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
            
            
            <table schema="" tableName="sys_user"></table>
    
            
        </context>
    </generatorConfiguration>

注：[Mybatis Generator 配置详解][Mybatis Generator]

### 3.3.运行插件生成代码 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgxNjczOA_size_16_color_FFFFFF_t_70]  
或者载命令行执行以下命令：

mvn mybatis-generator:generate

[https_mybatis.org_generator_running_runningWithMaven.html]: https://mybatis.org/generator/running/runningWithMaven.html
[Mybatis Generator]: https://gblfy.blog.csdn.net/article/details/104879681
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MDgxNjczOA_size_16_color_FFFFFF_t_70]: /images/20220829/792457960aea4ede8a7d422bd99f2916.png