oracle sequences在sql中取值

来源：互联网发布：更新驱动软件下载编辑：程序博客网时间：2024/06/07 00:50

1、oracle的sequence

2、从临时表中去sequences的值，例子：

<<insert id="insNoticeInfo"parameterType="com.vsc.zsxt.dao.model.TNoticeInfo">>
       <<selectKey resultType="BigDecimal"keyProperty="tzjlid"order="BEFORE"> >
           select SEQ_TZJLID.NEXTVAL as tzjlid from dual
       <</selectKey>>
   insert into T_NOTICE_INFO (TZJLID, TZRZJLX, TZRZJHM,
     TZRSJHM, TZLB, TZMC, WYYW,
     WYNY, TZHFBZ,DYBZ, DXYW, DXNY,
     DXFSZT,DXFSSJ,DXFSCS,MTMSGID,TZCKZT, DELFLG, INSUID,
     INSDT, INSIP, UPDUID,
     UPDDT, UPDIP)
   values (#{tzjlid},#{tzrzjlx,jdbcType=CHAR}, #{tzrzjhm,jdbcType=VARCHAR},
     #{tzrsjhm,jdbcType=CHAR}, #{tzlb,jdbcType=CHAR},#{tzmc,jdbcType=VARCHAR}, #{wyyw,jdbcType=CHAR},
     #{wyny,jdbcType=VARCHAR}, #{tzhfbz,jdbcType=CHAR},#{dybz,jdbcType=CHAR}, #{dxyw,jdbcType=CHAR},#{dxny,jdbcType=VARCHAR},
     #{dxfszt,jdbcType=CHAR},#{dxfssj,jdbcType=TIMESTAMP},#{dxfscs,jdbcType=CHAR},#{mtmsgid,jdbcType=CHAR},#{tzckzt,jdbcType=CHAR},
     #{delflg,jdbcType=CHAR}, #{insuid,jdbcType=VARCHAR},
     #{insdt,jdbcType=TIMESTAMP}, #{insip,jdbcType=VARCHAR},#{upduid,jdbcType=VARCHAR},
     #{upddt,jdbcType=TIMESTAMP}, #{updip,jdbcType=VARCHAR})
<</insert>>

3、直接去sequences的nextval，例子：

<<insert id="insertTPlanSchrange"parameterType="com.vsc.zsxt.dao.model.TPlanSchrange">>
    insert intoT_PLAN_SCHRANGE (DKID, XXBH, SQ,
     XXDM, XXMC, DKJD, SSJW,
     DELFLG, INSUID, INSDT,
     INSIP, UPDUID, UPDDT,
     UPDIP)
    values(SEQ_DKJDID.nextval,#{xxbh,jdbcType=DECIMAL}, #{sq,jdbcType=CHAR},
     #{xxdm,jdbcType=CHAR}, #{xxmc,jdbcType=VARCHAR},#{dkjd,jdbcType=VARCHAR}, #{ssjw,jdbcType=VARCHAR},
     #{delflg,jdbcType=CHAR}, #{insuid,jdbcType=VARCHAR},#{insdt,jdbcType=TIMESTAMP},
     #{insip,jdbcType=VARCHAR}, #{upduid,jdbcType=VARCHAR},#{upddt,jdbcType=TIMESTAMP},
     #{updip,jdbcType=CHAR})
<</insert>>

0 0