如题所述
对äºæ¯æèªå¨çæ主é®çæ°æ®åº(å¦SQL Server)ï¼å¯ä»¥éç¨ä»¥ä¸æ¹å¼
<insert id="xxx" parameterType="yyy" useGeneratedKeys="true" keyProperty="id">
....
</insert>
对äºä¸æ¯æèªå¨çæ主é®(å¦Oracle)ï¼å¯ä»¥éç¨ä»¥ä¸æ¹å¼
<insert id="xxx" parameterType="yyy">
<selectKey keyProperty="id" resultType="long" order="BEFORE">
select my_seq.nextval from dual
</selectKey>
....
</insert>
<insert id="xxx" parameterType="yyy" useGeneratedKeys="true" keyProperty="id">
....
</insert>
对äºä¸æ¯æèªå¨çæ主é®(å¦Oracle)ï¼å¯ä»¥éç¨ä»¥ä¸æ¹å¼
<insert id="xxx" parameterType="yyy">
<selectKey keyProperty="id" resultType="long" order="BEFORE">
select my_seq.nextval from dual
</selectKey>
....
</insert>
温馨提示:答案为网友推荐,仅供参考