mybatis-generator使用Maven Plugin生成mapper

阳光穿透心脏的1/2处 2023-10-17 09:57 7阅读 0赞

一开始我是打算用继承通用mapper来解决用手打（或者复制）一系列mapper重复代码的繁琐问题，后来在操作过程中发现bug太多而且填完一个坑又出现另一个坑最后放弃了通用mapper。

现在改成用mybatis-generator来自动生成mapper相关代码，还是挺好用的。

--------------------

一、新建一个maven项目，勾上mysql与mybatis

![这里写图片描述][SouthEast]

2、把pom.xml的自动生成的原插件替换以下

<plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>

<plugins>
    
                
                
                
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <executions>
                        <execution>
                            <id>Generate MyBatis Artifacts</id>
                            <goals>
                                <goal>generate</goal>
                            </goals>
                        </execution>
                    </executions>
                    <configuration>
                        <verbose>true</verbose>
                        <overwrite>true</overwrite>
                        
                        
                        
                        
                    </configuration>
                    <dependencies>
                        <dependency>
                            <groupId>mysql</groupId>
                            <artifactId>mysql-connector-java</artifactId>
                            <version>5.1.21</version>
                        </dependency>
                        <dependency>
                            <groupId>org.mybatis.generator</groupId>
                            <artifactId>mybatis-generator-core</artifactId>
                            <version>1.3.2</version>
                        </dependency>
                        <dependency>
                            <groupId>org.mybatis</groupId>
                            <artifactId>mybatis</artifactId>
                            <version>3.4.0</version>
                        </dependency>
                    </dependencies>
                </plugin>
            </plugins>

二、在application.properties中加入数据库的配置

spring.datasource.url=jdbc:mysql://localhost:3306/test
    spring.datasource.username=root
    spring.datasource.password=root
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver

三、在resources下建立一个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="my" targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="false"/>
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/test" userId="root"
                            password="root"/>
            
            <javaModelGenerator targetPackage="com.model"
                                targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="com.mapper"
                             targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator targetPackage="com.mapper"
                                 targetProject="src/main/java" type="XMLMAPPER">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
    
            
            
            
            <table tableName="user" domainObjectName="User"
                   enableCountByExample="false" enableUpdateByExample="false"
                   enableDeleteByExample="false" enableSelectByExample="false"
                   selectByExampleQueryId="false">
            </table>
    
        </context>
    </generatorConfiguration>

四、双击ALT键，弹出maven，如图点击即可自动生成（你也可以用命令行来操作maven）

![这里写图片描述][SouthEast 1]

成功后可以看到所有东西都帮你建好了。  
![这里写图片描述][SouthEast 2]

你再去把mapper不需要的方法删除即可。

[SouthEast]: https://img-blog.csdn.net/20170105103944798?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaDI5NTkyODEyNg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
[SouthEast 1]: https://img-blog.csdn.net/20170105105508258?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaDI5NTkyODEyNg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast
[SouthEast 2]: https://img-blog.csdn.net/20170105105722168?watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvaDI5NTkyODEyNg==/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast