SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
values (#id#,#description#)
insert into PRODUCT (PRD_DESCRIPTION)
values (#description#)
SELECT @@IDENTITY AS ID
insert into PRODUCT(PRD_DESCRIPTION)
values (#description#)
SELECT LAST_INSERT_ID()
iBatis自动生成的主键返回主键
iBatis自动生成的主键
很多数据库支持自动生成主键的数据类型。不过这通常(并不总是)是个私有的特性。
SQL Map 通过
Oracle)和后生成两种类型(如 MS-SQL Server)。下面是两个例子
<
!—Oracle SEQUENCE Example -->
SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
insert into PRODUCT (PRD_ID,PRD_DESCRIPTION)
values (#id#,#description#)
insert into PRODUCT (PRD_DESCRIPTION)
values (#description#)
SELECT @@IDENTITY AS ID
insert into PRODUCT(PRD_DESCRIPTION)
values (#description#)
SELECT LAST_INSERT_ID()


热门课程培训
热门培训机构
