mybatis自动生成sql变量及批量insert限制

来源:互联网 发布:java防止页面脚本注入 编辑:程序博客网 时间:2024/03/29 17:18

原因 是mybatis的这个useGeneratedKeys属性的问题,

写成了这样就不报错了
<insert id="addWxMessage" parameterType="java.util.List"
useGeneratedKeys="false">


详细配置如下:

<!-- 添加微信发布文章信息 -->
<insert id="addWxMessage" parameterType="java.util.List"useGeneratedKeys="false">
insert into t_wx_article(id, title, categoryid, wxid,
author, content,
hits, likes, imageurl,
addtime,
istop,
isrecommand, ishot, iscolor, status) 
selectseq_wx_article.nextval, A.* from (
<foreach collection="list"  item="item" index="index"  separator=" UNION ALL ">
select 
#{item.title,jdbcType=VARCHAR} title,
'000000' categoryid,
#{item.wxId,jdbcType=NUMERIC} wxId,
#{item.author,jdbcType=VARCHAR} author,
#{item.content,jdbcType=VARCHAR} content, 0 hits,
0 likes,
#{item.imageUrl,jdbcType=VARCHAR} imageurl,
sysdate addtime,
0 istop, 0 isrecommand, 0 ishot,
0 iscolor,
0 status 
from dual
</foreach>
) A
</insert>


自定义id,内存生成的id

<!-- 添加微信发布文章信息 -->
<insert id="addWxMessage" parameterType="java.util.List" useGeneratedKeys="false"> 
    <selectKey keyProperty="groupid" order="BEFORE" resultType="long">
        <![CDATA[SELECT seq_wx_article.nextval FROM dual]]>
    </selectKey>

insert into t_wx_article(id, groupid, title, categoryid, wxid,
author, content,
hits, likes, imageurl,
addtime,
istop,
isrecommand, ishot, iscolor, status) 
select seq_wx_article.nextval, A.* from (
<foreach collection="list"  item="item" index="index"  separator=" UNION ALL ">
select 
#{groupid},
#{item.title,jdbcType=VARCHAR} title,
'000000' categoryid,
#{item.wxId,jdbcType=NUMERIC} wxId,
#{item.author,jdbcType=VARCHAR} author,
#{item.content,jdbcType=VARCHAR} content, 0 hits,
0 likes,
#{item.imageUrl,jdbcType=VARCHAR} imageurl,
sysdate addtime,
0 istop, 0 isrecommand, 0 ishot,
0 iscolor,
0 status 
from dual
</foreach>
) A
</insert>