springboot mybatis 自动生成代码(maven+IntelliJ IDEA)


1.在pom文件中加入需要的依赖(mybatis-generator-core) 和 插件(mybatis-generator-maven-plugin)

<dependency>
    <groupId>org.mybatis.generatorgroupId>
    <artifactId>mybatis-generator-coreartifactId>
    <version>1.3.2version>
dependency>
<plugin>
    <groupId>org.mybatis.generatorgroupId>
    <artifactId>mybatis-generator-maven-pluginartifactId>
    <version>1.3.2version>
    
    <configuration>
       <configurationFile>src/main/resources/configXml/generatorConfig.xmlconfigurationFile>
        <verbose>trueverbose>
        <overwrite>trueoverwrite>    
    configuration>
plugin> 

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="D:\workProjects\springBootMybatis\src\main\resources\lib\mysql-connector-java-5.1.9.jar"/>
    <context id="MysqlTables" targetRuntime="MyBatis3">
        
        
        
        
        <commentGenerator>
            
            <property name="suppressAllComments" value="true" />
        commentGenerator>
        
        
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://localhost:3306/test_mybatis"
                        userId="root" password="123456">
        jdbcConnection>
        
        
        
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false" />
        javaTypeResolver>
        
        
        
        <javaModelGenerator targetPackage="com.example.springmybatis.entity"
                            targetProject="D:\workProjects\springBootMybatis\src\main\java">
            
            <property name="enableSubPackages" value="true" />
            
            <property name="trimStrings" value="true" />
        javaModelGenerator>
        
        
        
        <sqlMapGenerator targetPackage="mapper"
                         targetProject="D:\workProjects\springBootMybatis\src\main\resources">
            <property name="enableSubPackages" value="true" />
        sqlMapGenerator>
        
        
        <javaClientGenerator targetPackage="com.example.springmybatis.dao"
                             targetProject="D:\workProjects\springBootMybatis\src\main\java"
                             type="XMLMAPPER">
            <property name="enableSubPackages" value="true" />
        javaClientGenerator>
        
        
        
        
        <table  tableName="order_info" domainObjectName="OrderInfo"
                enableInsert="true" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false"
                enableSelectByExample="false" selectByExampleQueryId="false">
            
            
            
            
        table>
    context>
generatorConfiguration>

注意事项:

  •  mysql驱动jar包加载,location=“必须是绝对路径”

  • 配置文件中 context 节点下的内容,一定要按照以下顺序来(没有的可以不写,有的一定要按照顺序

  • 生成文件路径配置

  • 执行生成代码操作(IntelliJ IDEA) 涉及的命令:mybatis-generator:generate -e

  • 表结构与生成实体

如有什么不合适的地,烦请个位大佬指出纠正!