MyBatis新增时的序列主键

来源:互联网 发布:sql存储过程定义变量 编辑:程序博客网 时间:2024/06/05 07:40
<insert id="insert" parameterType="cn.ffcs.shequ.mybatis.domain.zzgl.crowd.Petitioner" >  <selectKey keyProperty="miId" resultType="long" order="BEFORE">select SEQ_ZZ_PETITIONERS.NEXTVAL from DUAL</selectKey>INSERT INTO T_ZZ_PETITIONERS (MI_ID,CI_RS_ID,IS_RESOLVE,IS_CONTROL,IS_THREE_CROSS)    VALUES (    #{miId,jdbcType=DECIMAL},#{ciRsId,jdbcType=DECIMAL},#{isResolve,jdbcType=VARCHAR},#{isControl,jdbcType=VARCHAR},#{isThreeCross,jdbcType=VARCHAR})  </insert>

0 0
原创粉丝点击