阅读背景:

oracle mybatis insert返回自动生成的主键_yjw1007020425的博客

来源:互联网 
<insert id="insertVideoBase" parameterType="com.paic.icore.agr.farmer.farmerinfo.model.VideoBaseModel">
    <selectKey keyProperty="videoBaseId" order="BEFORE" resultType="java.lang.String">
      select SYS_GUID() as videoBaseId from DUAL
    </selectKey>
    insert into AIMS_VIDEO_BASE(
    VIDEO_BASE_ID,
    VIDEO_ROOM_ID,
    STATUS,
    USER_ID,
    CASE_NO,
    VIDEO_APP_DATE,
    VIDEO_START_DATE,
    VIDEO_END_DATE,
    VIDEO_ROOM_NUMBER,
    ORGANIZER_JOIN_URL,
    ORGANIZER_TOKEN,
    ATTENDEE_JOIN_URL,
    ATTENDEE_TOKEN,
    CREATED_DATE,
    UPDATED_DATE,
    CREATED_USER,
    UPDATED_USER
    )
    values (
    #{
   <insert id="insertVideoBase" parameterTy



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: