ibatis 回到sql server和mysql主键自增值

分类: IT文章 • 2024-01-05 18:11:54

ibatis 返回sql server和mysql主键自增值
用ibatis 返回sqlserver主键自增值

<selectKey resultClass="int" keyProperty="id" type="post" >  
	 select @@IDENTITY as value  
</selectKey>

返回mysql主键自增值

<selectKey resultClass="long" keyProperty="id">
	SELECT LAST_INSERT_ID()
</selectKey>