Ibatis安插后返回主键

Ibatis插入后返回主键

<insert id="insertPicture" parameterClass="TblPicture">
	insert into tbl_picture(picture_name,picture_desc)
	values(#picture_name#,#picture_desc#)
	<!-- MySQL
	<selectKey keyProperty="id" resultClass="int">
		select @@identity as id
	</selectKey>
	 -->
	 <!-- Oracle
	<selectKey keyProperty="id" resultClass="int">
  		SELECT TBL_PICTURE_SEQ.CURRVAL AS ID FROM DUAL 
   	</selectKey>
   	 -->
   	 <!-- PostgreSQL -->
   	 <selectKey keyProperty="id" resultClass="int">
  		SELECT currval('tbl_picture_id_seq'::regclass) as id
   	</selectKey>
</insert>