ORA-00928 missing SELECT keyword

最新推荐文章于 2022-04-25 00:36:13 发布

liyixuanjiangjingxia

最新推荐文章于 2022-04-25 00:36:13 发布

阅读量3.2k

点赞数

文章标签： insert parameterclass id

本文链接：https://blog.youkuaiyun.com/liyixuanjiangjingxia/article/details/84054861

版权

如网上大部分出现的类似，是因为列名上不能添加单引号，可是我仔细检查了一下并没有在列上加多余的单引号，因为我是用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>