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>