springboot 项目自动生成实体类，mapper类和sqlmapper.xml

pom.xml

 

<!--添加mybatis generator maven插件-->
    <plugin>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-maven-plugin</artifactId>
        <version>1.3.5</version>
        <configuration>
            <!--generatorConfig.xml位置-->
            <configurationFile>src/main/resources/mybatis-generator/generatorConfig.xml</configurationFile>
            <verbose>true</verbose>
            <overwrite>true</overwrite>
        </configuration>
        <executions>
            <execution>
                <id>Generate MyBatis Artifacts</id>
                <goals>
                    <goal>generate</goal>
                </goals>
                <phase>generate-sources</phase>
            </execution>
        </executions>
        <!--此处必须添加mysql驱动包-->
        <dependencies>
            <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.14</version>
            </dependency>

        </dependencies>
    </plugin>
</plugins>

然后建立在resources下建mybatis-generator包下建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">

<!-- 根据数据库表生成实体类及mapper -->
<generatorConfiguration>
    <!-- <properties resource="db.properties" /> -->
    <!--第一处更改-->
    <classPathEntry
            location="D:\MavenResp\mysql\mysql-connector-java\8.0.14\mysql-connector-java-8.0.14.jar" />
    <context id="mysql2Beans" targetRuntime="MyBatis3">
        <commentGenerator>
            <!-- 删除代码中带有 代码生成器的注释信息 -->
            <property name="suppressAllComments" value="true" />
            <!-- 是否去除自动生成的注释 true：是 ： false:否 -->
            <property name="suppressDate" value="true" />
        </commentGenerator>
        <!--第二处更改-->
        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://127.0.0.1:3306/sell?characterEncoding=utf-8&amp;useSSL=false&amp;serverTimezone=UTC"
                        userId="root" password="22915" />

        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>

        <!-- 生成模型的包名和位置 -->
        <!--第三处更改-->
        <javaModelGenerator targetPackage="com.imooc.sell3.entity"
                            targetProject="src\main\java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="false" />
            <!-- <property name="trimStrings" value="true" /> -->
        </javaModelGenerator>
        <!--sql-->
        <!--第四处更改-->
        <sqlMapGenerator targetPackage="mapper"
                         targetProject="src\main\resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
        <!--mapper类-->
        <!--第五处更改-->
        <javaClientGenerator targetPackage="com.imooc.sell3.mapper"
                             targetProject="src\main\java" type="XMLMAPPER">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!--第六处更改   tableName表名    domainObjectName实体类名-->
        <table schema="test" tableName="seller_info"
               domainObjectName="SellerInfo" enableCountByExample="false"
               enableUpdateByExample="false" enableDeleteByExample="false"
               enableSelectByExample="false" selectByExampleQueryId="false">
        </table>
    </context>
</generatorConfiguration>

如果xml

Alt+enter

然后启动

转载于:https://my.oschina.net/u/3114501/blog/3085189