SpringBoot整合Mybatis generator

最新推荐文章于 2025-02-13 21:23:28 发布

最爱不过土豆泥

最新推荐文章于 2025-02-13 21:23:28 发布

阅读量255

点赞数

分类专栏： Spring

本文链接：https://blog.csdn.net/qq_40707685/article/details/104684722

版权

Spring 专栏收录该内容

4 篇文章

订阅专栏

配置mybatis generator

文档

pom.xml dependencies按照自己的来搭配

 <plugin>
          <groupId>org.mybatis.generator</groupId>
          <artifactId>mybatis-generator-maven-plugin</artifactId>
          <version>1.4.0</version>
           <dependencies>
            <dependency>
              <groupId>org.hsqldb</groupId>
              <artifactId>hsqldb</artifactId>
              <version>2.3.4</version>
            </dependency>
          </dependencies>
        </plugin>

创建文件 /src/main/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>
    <!--  <classPathEntry location="/Program Files/IBM/SQLLIB/java/db2java.zip" /> 不需要配置-->

    <context id="DB2Tables" targetRuntime="MyBatis3">
        <jdbcConnection driverClass="COM.ibm.db2.jdbc.app.DB2Driver"
                        connectionURL="jdbc:db2:TEST"
                        userId="db2admin"
                        password="db2admin">
        </jdbcConnection>  <!--数据库连接 包 url  用户名 密码-->

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

        <javaModelGenerator targetPackage="com.nickless.blog.model" targetProject="src/main/java"> <!--目标的包 和地址-->
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" /><!--是否需要空格-->
        </javaModelGenerator>

        <sqlMapGenerator targetPackage="mapper"  targetProject="src/main/resources"><!-- xml 文件-->
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <javaClientGenerator type="XMLMAPPER" targetPackage="com.nickless.blog.model"  targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <table schema="DB2ADMIN" tableName="ALLTYPES" domainObjectName="Customer" > <!--表结构 命名规范-->
            <property name="useActualColumnNames" value="true"/><!--返回名称是否为驼峰-->
            <generatedKey column="ID" sqlStatement="DB2" identity="true" /><!--自动生成key并返回-->
            <columnOverride column="DATE_FIELD" property="startDate" /><!--列重命名-->
            <ignoreColumn column="FRED" />
            <columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" />
        </table>

    </context>
</generatorConfiguration>

控制台输入 (生成model和mapper)

mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate

让spring boot找到mapper application配置 @mapperScan(basePackages=“mybatis.type-aliases-package=com.nickless.blog.mapper”)文档
application.properties 配置

mybatis.type-aliases-package=com.nickless.blog.model
mybatis.mapper-locations=classpath:mapper/*.xml