SpringBoot整合Mybatis以及自动生成代码

比眉伴天荒 2023-07-10 14:29 2阅读 0赞

先总揽下项目结构  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA_size_16_color_FFFFFF_t_70]

## 一、整合mybatis ##

1.  引入pom依赖：

<dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.1</version>
            </dependency>
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.10</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
            </dependency>

1.  基础配置，修改配置文件application.properties

#MySQL
    spring.datasource.type= com.alibaba.druid.pool.DruidDataSource
    spring.datasource.url= jdbc:mysql://127.0.0.1:3306/vhr
    spring.datasource.username=root
    spring.datasource.password=1111
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver
    #MyBatis
    #注意：一定要对应mapper映射xml文件的所在路径
    mybatis.mapper-locations= classpath:mapper/**/*Mapper.xml
    # 注意：对应实体类的路径
    mybatis.type-aliases-package= com.chouxiaozi.micro.model

1.  启动类配置扫描路径 @MapperScan

@SpringBootApplication
    /*对应mybatis接口mapper类的包路径*/
    @MapperScan(basePackages = "com.chouxiaozi.micro.mapper")
    public class MicroApplication { 
    
        public static void main(String[] args) { 
            SpringApplication.run(MicroApplication.class, args);
        }
    
    }

1.  等配置完自动生成代码后再测试

## 二、整合自动生成代码generator ##

1.  引入pom依赖

<dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.2</version>
            </dependency>

<build>
            <plugins>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        
                        <configurationFile>${ basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>${ mysql.version}</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>
        </build>

1.  resource下增加配置文件generatorConfig.xml

<?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="MybatisGenerator" targetRuntime="MyBatis3">
      	
      	<property name="javaFileEncoding" value="UTF-8" />
      	
      	
      	<plugin type="org.mybatis.generator.plugins.CaseInsensitiveLikePlugin" />  
      	
      	
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin" />
        
    	
    	<commentGenerator>
    		<property name="suppressDate" value="true" />
    		<property name="suppressAllComments" value="true" />
    		<property name="addRemarkComments" value="true"/> 
    	</commentGenerator> 
            
         
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
    			connectionURL="jdbc:mysql://127.0.0.1:3306/vhr?useUnicode=true&characterEncoding=utf-8"
    			userId="root"
    			password="1111" />
    
    	
    	<javaModelGenerator targetPackage="com.chouxiaozi.micro.model" targetProject="src/main/java">
    		
    		<property name="enableSubPackages" value="false" />
    		
    		<property name="trimStrings" value="true" />
    		
    		<property name="constructorBased" value="false"/>
    	</javaModelGenerator>
        
        
        <sqlMapGenerator targetPackage="/mapper"  targetProject="src\main\resources" />
        
        
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.chouxiaozi.micro.mapper" targetProject="src\main\java" />
    
    	
     	
    	  <table schema="" tableName="menu" domainObjectName="Menu" >
    		  
    	  </table>
      </context>
    </generatorConfiguration>

1.  idea可以直接通过下面这种方式生成  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200303150245319.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200303135248952.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NodWFpODYyNA==,size_16,color_FFFFFF,t_70