Mybatis-逆向工程-注解

Mybatis-注解:

http://computerdragon.blog.51cto.com/6235984/1399742

源码改造:mybatis-generator-core-1.3.2.jar

文件:generatorConfig-base.xml

    <table tableName="pd_integral_log">
            <!-- <generatedKey column="id" sqlStatement="SELECT LAST_INSERT_ID()"/> -->
            <generatedKey column="id" sqlStatement="JDBC"/>
            
        </table>
sqlStatement配置:(参考:http://www.mybatis.org/generator/configreference/generatedKey.html)
第一种方式:sqlStatement="JDBC" 生成结果:useGeneratedKeys="true" keyProperty="id"
  
<insert id="insert" parameterType="mapper.PdIntegralLogDO" useGeneratedKeys="true" keyProperty="id" >
    <set >
      <include refid="set" />
    </set>
  </insert>
第二种方式: sqlStatement="SELECT LAST_INSERT_ID()   (每种类型的数据库对应的设置不用,具体参考:http://www.mybatis.org/generator/configreference/generatedKey.html)
生成结果:
 <insert id="insert" parameterType="mapper.PdIntegralLogDO" >
    <selectKey resultType="java.lang.Long" keyProperty="id" order="BEFORE" >
      SELECT LAST_INSERT_ID()
    </selectKey>
    <set >
      <include refid="set" />
    </set>
  </insert>
 
原文地址:https://www.cnblogs.com/wanhua-wu/p/6971558.html