zl程序教程

您现在的位置是:首页 >  后端

当前栏目

mybatis:自增长主键

mybatis 主键 增长
2023-09-27 14:20:18 时间

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>

image

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>

image