Eclipse 安装和使用mybatis generator插件自动生成代码

冷不防 2022-03-10 05:18 570阅读 0赞

*  Eclipse MyBatis Generator插件安装
 *  Eclipse 使用mybatis generator插件自动生成代码

## Eclipse MyBatis Generator插件安装 ##

1.进入Eclipse Marketplace  
【Help】 -> 【Eclipse Marketplace…】

2.搜索MyBatis Generator

点击【Install】即开始安装，安装完成后重启Eclipse  
3.查看插件  
【File】 -> 【New】-> 【Other…】

如下，即表示插件已安装成功  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZWd5MjE4_size_16_color_FFFFFF_t_70]

Eclipse 使用mybatis generator插件自动生成代码

1.  使用插件

选中添加generatorConfig文件的项目，右键new–>other

这里写图片描述  
![在这里插入图片描述][20190309174122608.png]  
项目目录结构描述  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZWd5MjE4_size_16_color_FFFFFF_t_70 1]  
生成的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:\eclipse-workspace\generator\mysql-connector-java-5.1.45.jar" />
        <context id="DB2Tables" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressTypeWarnings" value="true" />
                
                <property name="suppressAllComments" value="true" />
                
                <property name="suppressDate" value="true" />
            </commentGenerator>
    
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                connectionURL="jdbc:mysql://localhost/test4?useSSL=false" userId="root"
                password="xxx">
            </jdbcConnection>
    
            <javaModelGenerator targetPackage="com.demo.domain"
                targetProject="D:\eclipse-workspace\generator\src">
                <property name="enableSubPackages" value="false" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
            <sqlMapGenerator targetPackage="com.demo.mapper"
                targetProject="D:\eclipse-workspace\generator\src">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            <javaClientGenerator type="XMLMAPPER"
                targetPackage="com.demo.dao" targetProject="D:\eclipse-workspace\generator\src">
                <property name="enableSubPackages" value="true" />
            </javaClientGenerator>
    
            
            
            
            
            
            <table schema="general" tableName="user" domainObjectName="User">
                
                <property name="useActualColumnNames" value="false" />
                
                
                
                <columnOverride column="user_name" jdbcType="VARCHAR" />
            </table>
        </context>
    </generatorConfiguration>

2、使用方法  
生成语句文件:

> java -jar mybatis-generator-core-1.3.2.jar -configfile  
> generatorConfig.xml -overwrite

在该目录按住Shift键，右键鼠标选择"在此处打开命令窗口"，复制粘贴生成语句的文件代码即可。

domain类User内自动生成代码（Javabean）

看下效果图：  
![在这里插入图片描述][20190309175740793.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZWd5MjE4_size_16_color_FFFFFF_t_70]: /images/20220310/a60b19ff5e824a72b608cc938aa06d2f.png
[20190309174122608.png]: /images/20220310/c70fbd05f31f4b009051c7a86a599689.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2NoZWd5MjE4_size_16_color_FFFFFF_t_70 1]: /images/20220310/60547f1d1e094f45b54cc04c85bc929c.png
[20190309175740793.png]: /images/20220310/aaf9be13df9042f2b610e319fd725140.png