Mybatis添加记录时返回对应主键ID

来源:互联网 发布:电商大数据 豆瓣 编辑:程序博客网 时间:2024/05/16 08:28
<insert id="insertORACLE" parameterClass="product">   <selectKey resultClass="int" type="pre" property="Id" >      SELECT STOCKIDSEQUENCE.NEXTVAL AS VALUE FROM DUAL  </selectKey>   insert into PRODUCT (PRD_ID,PRD_DESCRIPTION) values (#id#,#description#) </insert>— Microsoft SQL Server IDENTITY Column Example --> <insert id="insertMSSQL" parameterClass="product">   insert into PRODUCT (PRD_DESCRIPTION)  values (#description#)  <selectKey resultClass="int" type="post" property="id" >    select @@IDENTITY as value </selectKey></insert><insert id="insertMYSQL" parameterClass="product">   insert into PRODUCT (PRD_DESCRIPTION)  values (#description#)  <selectKey resultClass="int" type="post" property="id" >    select LAST_INSERT_ID() as value </selectKey></insert>

0 0
原创粉丝点击