Mybatis自动生成实体&mapper接口&mapper

短命女 2022-04-16 04:25 332阅读 0赞

## 1.工具内的目录结构 ##

code：生成的代码存放在此目录
    lib：打包文件需要的jar包
    gerenatorConfig.xml：配置文件
    mybatis-generator-1.3.2.jar：自动生成实体&mapper接口&mapper必须的jar包
    mysql-connector-java-5.1.34.jar：连接数据库的jar包
    run.bat：自动生成代码的批处理文件

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70]

## 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="mysql-connector-java-5.1.34.jar"/>
    <context id="my" targetRuntime="MyBatis3">
        <property name="javaFileEncoding" value="UTF-8"/>
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
    	
    		
    	<jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://127.0.0.1:3306/way"
                        userId="test"
    					password="test">
        </jdbcConnection>
    	
    	
        <javaModelGenerator targetPackage="com.mask.model"
                            targetProject="D:\07tool\MyBatisGenerator\demo\code">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
    	
    	
        <sqlMapGenerator targetPackage="com.mask.dao"
                         targetProject="D:\07tool\MyBatisGenerator\demo\code">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
    	
    	
        <javaClientGenerator targetPackage="com.mask.mapper"
                             targetProject="D:\07tool\MyBatisGenerator\demo\code" type="XMLMAPPER">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>
    
    
    	
    	<table tableName="t_user" domainObjectName="TUser" alias="tu"
               enableCountByExample="false" enableUpdateByExample="false"
               enableDeleteByExample="false" enableSelectByExample="false"
               selectByExampleQueryId="false">
    		<generatedKey column="id" sqlStatement="JDBC" identity="true"/>
        </table>
    
    </context>
    </generatorConfiguration>

文章中注释的地方即为需要修改的地方。需要注意的，如果有多张表的话，需要写多个`<table></table>`

<table tableName="t_user" domainObjectName="TUser" alias="tu"
           enableCountByExample="false" enableUpdateByExample="false"
           enableDeleteByExample="false" enableSelectByExample="false"
           selectByExampleQueryId="false">
    	<generatedKey column="id" sqlStatement="JDBC" identity="true"/>
    </table>

## 3.自动生成代码 ##

执行run.bat文件即可自动生成代码。  
执行结果：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70 1]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70 2]

这样就可以自动生成实体类，mapper了。

工具下载地址：[https://download.csdn.net/download/mask002/10789684][https_download.csdn.net_download_mask002_10789684]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70]: /images/20220416/b57104e951714be4a36533cf511335f7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70 1]: /images/20220416/c8f93b76f6454048b7602d88857b2d04.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21hc2swMDI_size_16_color_FFFFFF_t_70 2]: /images/20220416/4478cb339c3c4482be5d9c2812ae6881.png
[https_download.csdn.net_download_mask002_10789684]: https://download.csdn.net/download/mask002/10789684