集成Mybatis通用Mapper以及代码生成器

深碍√TFBOYSˉ_ 2022-04-25 01:32 234阅读 0赞

为什么要学习Mybatis的通用Mapper，相信也不用我做太多介绍，总之他能简化我们开发过程中对数据库的单表操作。  
这里详细讲解一下Spring环境下配置Mybatis通用Mapper以及代码生成器的过程

1.  pom.xml中引入依赖
    
        
                    <dependency>
                        <groupId>tk.mybatis</groupId>
                        <artifactId>mapper</artifactId>
                        <version>3.3.8</version>
                    </dependency>
        
                    
                    <dependency>
                        <groupId>org.mybatis.generator</groupId>
                        <artifactId>mybatis-generator-core</artifactId>
                        <version>1.3.3</version>
                    </dependency>
2.  pom.xml中配置代码生成器插件
    
        <properties>
                
        
                
                <targetJavaProject>${basedir}/src/main/java</targetJavaProject>
                
                <targetMapperPackage>fei.mapper</targetMapperPackage>
                
                <targetModelPackage>fei.entity</targetModelPackage>
        
                
                <targetResourcesProject>${basedir}/src/main/resources</targetResourcesProject>
                <targetXMLPackage>fei.mapper</targetXMLPackage>
            </properties>
        
        		......
        
        	
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        
                        <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                        
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.21</version>
                        </dependency>
                        <dependency>
                            <groupId>tk.mybatis</groupId>
                            <artifactId>mapper</artifactId>
                            <version>3.3.8</version>
                        </dependency>
                    </dependencies>
                </plugin>
3.  编写代码生成器配置文件`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>
        	 
            <properties resource="classpath:generator.properties"/>
        
            <context id="Mysql" targetRuntime="MyBatis3Simple" defaultModelType="flat">
                <property name="beginningDelimiter" value="`"/>
                <property name="endingDelimiter" value="`"/>
        
                <plugin type="${mapper.plugin}">
                    
                    <property name="mappers" value="${mapper.Mapper}"/>
                    
                    <property name="forceAnnotation" value="true"/>
                    
                    <property name="caseSensitive" value="true"/>
                </plugin>
        
        		 
                <jdbcConnection driverClass="${jdbc.driver}" connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}">
                </jdbcConnection>
        
                
                <javaModelGenerator targetPackage="${targetModelPackage}" targetProject="${targetJavaProject}"/>
        
                <sqlMapGenerator targetPackage="${targetXMLPackage}" targetProject="${targetResourcesProject}"/>
        
                <javaClientGenerator targetPackage="${targetMapperPackage}" targetProject="${targetJavaProject}" type="XMLMAPPER" />
        
        		
                <table tableName="%" >
                    <generatedKey column="user_id" sqlStatement="Mysql" identity="true"/>
                </table>
        
            </context>
        </generatorConfiguration>
4.  resources根目录下定义需要加载的配置文件`generator.properties`
    
        jdbc.driver=com.mysql.jdbc.Driver
        jdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8
        jdbc.username=root
        jdbc.password=1111
        mapper.plugin = tk.mybatis.mapper.generator.MapperPlugin
        mapper.Mapper =fei.dao.BaseMapper
    
    注意我的`fei.dao.BaseMapper`继承了`extends Mapper<T>, MySqlMapper<T>`，前面配置了所有自动生成的mapper接口都继承这个接口
5.  然后将原来mybatis-batis.xml文件中的
    
        
            <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
                
                <property name="basePackage" value="fei.mapper" />
            </bean>
    
    改成
    
        
            <bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
                
                <property name="basePackage" value="fei.mapper" />
            </bean>
6.  最后测试启动  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoaWppdWppdTMz_size_16_color_FFFFFF_t_70]  
    没有报错，应该就在指定位置可以看到自动生成的实体类，Mapper接口，Mapper.xml文件
    
    如自动帮我们生成的实体类
    
        @Table(name = "customer")
        public class Customer { 
            @Id
            @Column(name = "cust_id")
            private Integer custId;
        
            @Column(name = "cust_name")
            private String custName;
        
            @Column(name = "cust_profession")
            private String custProfession;
        
            @Column(name = "cust_phone")
            private String custPhone;
            ......

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NoaWppdWppdTMz_size_16_color_FFFFFF_t_70]: /images/20220210/fec85ad001334a3fab40094922485782.png