代码
- <insert id="insertProduct-ORACLE" parameterClass="com.domain.Product">
- <selectKey resultClass="int" keyProperty="id" >
- SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
- </selectKey>
- insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
- values (#id#,#description#)
- </insert>
SQL Server中：
代码
- <insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">
- insert into PRODUCT (PRD_DESCRIPTION)
- values (#description#)
- <selectKey resultClass="int" keyProperty="id" >
- SELECT @@IDENTITY AS ID
- </selectKey>
- </insert>