1.oracle插入数据后返回自增id的方法
执行完insert后,主键值包装在了参数对象里边,通过ArticleInfo.getArticleInfoId()获取:
<insert id="insert" parameterType="top.zdigi.entity.ArticleInfo">
<selectKey keyProperty="articleInfoId" resultType="java.lang.Integer" order="BEFORE">
select public.article_info_id_seq.nextval from dual
</selectKey>
insert into ARTICLE_INFO (ARTICLE_INFO_ID, TITLE, SUMMARY,
IS_TOP, PAGE_VIEW, CREATE_BY
)
values (#{articleInfoId,jdbcType=DECIMAL}, #{title,jdbcType=VARCHAR}, #{summary,jdbcType=VARCHAR},
#{isTop,jdbcType=DECIMAL}, #{pageView,jdbcType=DECIMAL}, #{createBy,jdbcType=TIMESTAMP}
)
</insert>
2.MySQL 插入数据后返回自增id的方法
1、insert按如下修改,主键值包装在了参数对象里边,通过ArticleInfo.getArticleInfoId()获取:
<insert id="insert&#