ORA-00928 missing SELECT keyword

jiangjingxiaoxuan

浏览: 32623 次
性别:
来自: 北京

最近访客更多访客>>

雪狐ypc

janesjie

u012434336

json_liu

博主相关

博客

微博

相册

留言

关于我

文章分类

全部博客 (21)

社区版块

存档分类

insert parameterclass id

如网上大部分出现的类似，是因为列名上不能添加单引号，可是我仔细检查了一下并没有在列上加多余的单引号，因为我是用ibatis 配置的sql语句， <dynamic prepend=" ">，其中prepend的值就表示用什么符号，但是我用的是""，并没有多余的单引号，再细看发现我的""中没有空格，加上一个空格后，即" ",后程序正常运转，特在此分享给大家。

<insert id="PhotoAlbumsSQL.createAlbum" parameterClass="photoAlbums">
  insert into photoalbums(
   <dynamic prepend=" ">
    <isNotEmpty prepend="," property="albums_id">
    albums_id
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_name">
    albums_name
    </isNotEmpty>
    <isNotEmpty prepend="," property="create_tim">
    create_tm
    </isNotEmpty>
    <isNotEmpty prepend="," property="update_tim">
    update_tm
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_limits">
    albums_limits
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_cover">
    album_cover
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_category">
    album_category
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_desc">
    album_desc
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_type">
    albums_type
    </isNotEmpty>
    <isNotEmpty prepend="," property="creator">
    creator
    </isNotEmpty>
   </dynamic>
  ) values (
   <dynamic prepend=" ">
      <isNotEmpty prepend="," property="albums_id">
    #albums_id#
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_name">
    #albums_name#
    </isNotEmpty>
    <isNotEmpty prepend="," property="create_tim">
    #create_tim#
    </isNotEmpty>
    <isNotEmpty prepend="," property="update_tim">
    #update_tim#
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_limits">
    #albums_limits#
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_cover">
    #album_cover#
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_category">
    #album_category#
    </isNotEmpty>
    <isNotEmpty prepend="," property="album_desc">
    #album_desc#
    </isNotEmpty>
    <isNotEmpty prepend="," property="albums_type">
    #albums_type#
    </isNotEmpty>
    <isNotEmpty prepend="," property="creator">
    #creator#
    </isNotEmpty>
   </dynamic>
  )
</insert>