<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>
Ibatis插入后返回主键
最新推荐文章于 2017-06-13 22:21:04 发布