idea MyBatis生成实体、xml

最新推荐文章于 2023-12-04 14:31:06 发布

爱敲代码的程序猿

最新推荐文章于 2023-12-04 14:31:06 发布

阅读量1.2k

点赞数

文章标签： mybatis intellij-idea xml

本文链接：https://blog.csdn.net/qq_36911154/article/details/125557694

版权

1、在pom.xml中添加org.mybatis.generator插件

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
        <plugin>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-maven-plugin</artifactId>
            <version>1.3.2</version>

        </plugin>
    </plugins>
</build>

2、在项目根目录创建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>
    <!-- 数据库驱动:选择你的本地硬盘上面的数据库驱动包-->
    <classPathEntry  location="/Users/lixin/.m2/repository/mysql/mysql-connector-java/5.1.46/mysql-connector-java-5.1.46.jar"/>
    <context id="mysqlTables" targetRuntime="MyBatis3">

        <property name="javaFileEncoding" value="UTF-8"/>
        <property name="autoDelimitKeywords" value="true"/>
        <property name="beginningDelimiter" value="`"/>
        <property name="endingDelimiter" value="`"/>
        <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>
        <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>

        <plugin type="org.mybatis.generator.plugins.RowBoundsPlugin"/>
        <plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>
        <plugin type="com.kech.starter.db.generator.LombokPlugin">
            <property name="superBuilder" value="true"/>
            <property name="superBuilder.toBuilder" value="true"/>
            <property name="allArgsConstructor" value="true"/>
        </plugin>

        <commentGenerator>
            <property name="addRemarkComments" value="true"/>
            <property name="suppressDate" value="true"/>
        </commentGenerator>

        <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
                        connectionURL="jdbc:mysql://192.168.8.110:3334/mall?useUnicode=true&amp;allowMultiQueries=true&amp;characterEncoding=utf8&amp;useAffectedRows=true&amp;useSSL=false"
                        userId="usr_test" password="Ylt_Test_2021">
            <property name="useInformationSchema" value="true"/>
        </jdbcConnection>

        <javaTypeResolver>
            <property name="useJSR310Types" value="true"/>
        </javaTypeResolver>

        <javaModelGenerator targetPackage="com.kech.business.repo.entity"
                            targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <!--<property name="trimStrings" value="true"/>-->
        </javaModelGenerator>

        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources/mybatis/kech">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>

        <javaClientGenerator targetPackage="com.kech.business.repo.mapper"
                             targetProject="src/main/java"
                             type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

        <table tableName="feedback" domainObjectName="Feedback">
            <generatedKey column="id" sqlStatement="mysql" identity="true"/>
            <columnOverride column="IS_DELETED"
                            javaType="com.kech.starter.db.code2enum.DeletedEnum"
                            typeHandler="com.kech.starter.db.type.CodeEnumTypeHandler"/>
            <columnOverride column="CATEGORY"
                            javaType="com.kech.business.enums.FeedbackCategoryEnum"
                            typeHandler="com.kech.starter.db.type.CodeEnumTypeHandler"/>
            <columnOverride column="STATUS"
                            javaType="com.kech.business.enums.FeedbackStatusEnum"
                            typeHandler="com.kech.starter.db.type.CodeEnumTypeHandler"/>
        </table>

    </context>
</generatorConfiguration>

3、打开idea的run