mybatis添加时如何获得主键值

来源:互联网 发布:秦安观点 网络强国 编辑:程序博客网 时间:2024/06/05 04:24

第一种写法,

<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})


原创粉丝点击