第一种写法,
<insert id="insert" parameterType="com.itmayiedu.entity.Gifts" useGeneratedKeys="true" keyProperty="giftsid" >
insert into gifts (giftsid,proId, giftsName
)
values (LAST_INSERT_ID(giftsid),#{proid,jdbcType=INTEGER},
#{giftsname,jdbcType=VARCHAR}
)
</insert>
第二种写法,获得自动增长ID
<selectKey resultType="int" order="AFTER" keyProperty="giftsid">
SELECT LAST_INSERT_ID()
</selectKey>
insert into gifts (giftsid,proId, giftsName
)
values (#{giftsid},#{proid,jdbcType=INTEGER},
#{giftsname,jdbcType=VARCHAR}
)