1
<insert id="insertProduct-ORACLE" parameterClass="com.domain.Product">
2
<selectKey resultClass="int" keyProperty="id" >
3
SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
4
</selectKey>
5
insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
6
values (#id#,#description#)
7
</insert>
8
SQL Server中: 
2

3

4

5

6

7

8

1
<insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">
2
insert into PRODUCT (PRD_DESCRIPTION)
3
values (#description#)
4
<selectKey resultClass="int" keyProperty="id" >
5
SELECT @@IDENTITY AS ID
6
</selectKey>
7
</insert>

2

3

4

5

6

7
