如何获取新增数据自增后的ID

在dao.xml文件的添加语句中嵌套查询自增ID

   <selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id"> 
 	 	SELECT LAST_INSERT_ID() AS id 
 	</selectKey> 

示例:

 <insert id="insert" parameterType="com.pinyougou.pojo.TbGoods" >
 
  	<selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id">
  		select last_insert_id() as id
  	</selectKey>
  	
    insert into tb_goods (id, seller_id, goods_name, 
      default_item_id, audit_status, is_marketable, 
      brand_id, caption, category1_id, 
      category2_id, category3_id, small_pic, 
      price, type_template_id, is_enable_spec, 
      is_delete)
    values (#{id,jdbcType=BIGINT}, #{sellerId,jdbcType=VARCHAR}, #{goodsName,jdbcType=VARCHAR}, 
      #{defaultItemId,jdbcType=BIGINT}, #{auditStatus,jdbcType=VARCHAR}, #{isMarketable,jdbcType=VARCHAR}, 
      #{brandId,jdbcType=BIGINT}, #{caption,jdbcType=VARCHAR}, #{category1Id,jdbcType=BIGINT}, 
      #{category2Id,jdbcType=BIGINT}, #{category3Id,jdbcType=BIGINT}, #{smallPic,jdbcType=VARCHAR}, 
      #{price,jdbcType=DECIMAL}, #{typeTemplateId,jdbcType=BIGINT}, #{isEnableSpec,jdbcType=VARCHAR}, 
      #{isDelete,jdbcType=VARCHAR})
  </insert>