语源科技BlogJava-Eric's bloghttp://www.blogjava.net/asp/Eric's blogzh-cnThu, 07 May 2026 07:34:55 GMTThu, 07 May 2026 07:34:55 GMT60ibatis自动生成的主键http://www.blogjava.net/asp/archive/2007/05/27/120345.htmlEric's blogEric's blogSun, 27 May 2007 13:00:00 GMThttp://www.blogjava.net/asp/archive/2007/05/27/120345.htmlhttp://www.blogjava.net/asp/comments/120345.htmlhttp://www.blogjava.net/asp/archive/2007/05/27/120345.html#Feedback0http://www.blogjava.net/asp/comments/commentRss/120345.htmlhttp://www.blogjava.net/asp/services/trackbacks/120345.html
1<insert id="insertProduct-ORACLE" parameterClass="com.domain.Product">  
2<selectKey resultClass="int" keyProperty="id" >  
3SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL   
4</selectKey>  
5insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)   
6values (#id#,#description#)   
7</insert>  
8
SQL Server中：
1<insert id="insertProduct-MS-SQL" parameterClass="com.domain.Product">  
2insert into PRODUCT (PRD_DESCRIPTION)   
3values (#description#)   
4<selectKey resultClass="int" keyProperty="id" >  
5SELECT @@IDENTITY AS ID   
6</selectKey>  
7</insert> 


Eric's blog 2007-05-27 21:00 发表评论
]]>