MS SqlServer:
1 <insert id="Insert" parameterClass="Person"> 2 insert into PERSON 3 (PER_FIRST_NAME, PER_LAST_NAME, 4 PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) 5 values 6 ( #FirstName#, #LastName#, 7 #BirthDate#, #WeightInKilograms#, #HeightInMeters#) 8 <selectKey property="Id" type="post" resultClass="int"> 9 select CAST(@@IDENTITY as int) as value 10 </selectKey> 11 </insert>
MySql:
1 <insert id="Insert" parameterClass="Person"> 2 insert into PERSON 3 (PER_FIRST_NAME, PER_LAST_NAME, 4 PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) 5 values 6 ( #FirstName#, #LastName#, 7 #BirthDate#, #WeightInKilograms#, #HeightInMeters#) 8 <selectKey property="Id" type="post" resultClass="int"> 9 select @@IDENTITY as value 10 </selectKey> 11 </insert>