让mybatis generator插件生成的mapper.xml 插入语句中自动返回主键

最新推荐文章于 2024-11-02 11:17:54 发布

原创最新推荐文章于 2024-11-02 11:17:54 发布 · 1.6k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#mybatis #java

java 同时被 3 个专栏收录

27 篇文章

订阅专栏

服务器

10 篇文章

订阅专栏

mysql

9 篇文章

订阅专栏

让mybatis generator插件生成的mapper.xml 插入语句中自动返回主键：

加入一行代码即可，id为表的主键字段名:


<?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>

    <context id="DB2Tables"    targetRuntime="MyBatis3">
        <commentGenerator>
            <property name="suppressDate" value="true"/>
            <property name="suppressAllComments" value="true"/>
        </commentGenerator>
        <!--数据库链接地址账号密码-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://192.168.xxx.xxx:3307/dbb?useSSL=true"
                        userId="test"
                        password="123456">
        </jdbcConnection>
        <javaTypeResolver>
            <property name="forceBigDecimals" value="false"/>
        </javaTypeResolver>
        <!--生成Model类存放位置-->
        <javaModelGenerator targetPackage="com.xxx.test.client.entity.model" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
            <property name="trimStrings" value="true"/>
        </javaModelGenerator>
        <!--生成映射文件mapper.xml存放位置-->
        <sqlMapGenerator targetPackage="mapper" targetProject="src/main/resources">
            <property name="enableSubPackages" value="true"/>
        </sqlMapGenerator>
     
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.xxx.test.client.mapper" targetProject="src/main/java">
            <property name="enableSubPackages" value="true"/>
        </javaClientGenerator>

       <table tableName="sys_task" domainObjectName="SysTaskPojo" enableCountByExample="true" enableUpdateByExample="true"
        enableDeleteByExample="true" enableSelectByExample="true" enableDeleteByPrimaryKey="true" >
           <!--指定主键，插入时自动返回主键-->
           <generatedKey column="id" sqlStatement="JDBC" identity="true"></generatedKey>
       </table>

</context>
</generatorConfiguration>