mybatis:自增长主键
1. useGeneratedKeys="true" keyProperty="bdxh"
<insert id="insert" parameterType="com.test.entity.app.ks.gc.EntityKsGcSfxxbd" useGeneratedKeys="true" keyProperty="bdxh"> INSERT INTO t_ks_gc_sfxxbd ( lsh, kskm, ksxtbh, sfzmhm, ksysfzmhm, zp, kssj, Ksy2sfzmhm, kchp, ksxl, code, message ) VALUES ( #{lsh}, #{kskm}, #{ksxtbh}, #{sfzmhm}, #{ksysfzmhm}, #{zp}, #{kssj}, #{Ksy2sfzmhm}, #{kchp}, #{ksxl}, #{code}, #{message} ) </insert>
2. selectKey
<insert id="insert" parameterType="com.test.entity.app.ks.EntityKsGc"> <selectKey keyProperty="gcxh" resultType="int" order="BEFORE" statementType="PREPARED"> select LAST_INSERT_ID() </selectKey> INSERT INTO t_ks_gc ( gcxh, bdxh, lsh, sfzmhm, xm, ksrq, dlr, bcyykscs, kskm, kscx, kscc, kchp, kssj, jssj, sjzt, kscj, ksjg ) VALUES ( #{gcxh}, #{bdxh}, #{lsh}, #{sfzmhm}, #{xm}, #{ksrq}, #{dlr}, #{bcyykscs}, #{kskm}, #{kscx}, #{kscc}, #{kchp}, #{kssj}, #{jssj}, #{sjzt}, #{kscj}, #{ksjg} ) </insert>
若是本人原创文章,请标明:本文来自博客园,作者:huiy_小溪,转载请注明原文链接:https://www.cnblogs.com/huiy/p/13284319.html。
反之,请标明原创作者,文章链接,所属平台。