mybatis代码生成

冷不防 2023-02-22 07:53 13阅读 0赞

项目中使用mybatis代码生成工具生成mapper和entity；记录下步骤：

1、配置jdk环境

自行百度

2、MyBatis Generator数据库文件 config配置

<?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:\repository\mysql\mysql-connector-java\5.1.25\mysql-connector-java-5.1.25.jar"/>
        <context id="default" targetRuntime="MyBatis3">
    
            
            <commentGenerator>
                <property name="suppressDate" value="true" />
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="###" userId="###" password="###">
            </jdbcConnection>
            
            <javaModelGenerator targetPackage="com.entity" targetProject="D:\ideaResource\java">
                
                
    
                
                <property name="enableSubPackages" value="false"/>
    
                
                <property name="immutable" value="false"/>
    
                
                
    
                
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mapping" targetProject="###\resources">
                
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
    
            
            <javaClientGenerator targetPackage="com.dmall.intelligent.lock.mapper" targetProject="D:\ideaResource\iot-gateway\intelligent-lock-mapper\src\main\java" type="XMLMAPPER">
                <property name="enableSubPackages" value="false"/>
            </javaClientGenerator>
            
            <table tableName="表名" schema="数据库名"
                   domainObjectName="实体名" enableCountByExample="true"
                   enableUpdateByExample="true"
                   enableDeleteByExample="true"
                   enableSelectByExample="true"   selectByExampleQueryId="false"  >
                <columnOverride column="id" javaType="java.lang.Long"    jdbcType="BIGINT" />
            </table>
        </context>
    
    </generatorConfiguration>

3.下载maven 对应的jar

<dependency>
        <groupId>org.mybatis.generator</groupId>
        <artifactId>mybatis-generator-core</artifactId>
        <version>1.3.5</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.25</version>
    </dependency>

4、在cmd执行命令

java -jar mybatis-generator-core-1.3.5.jar绝对路径 -configfile xml文件路径 -overwrite