添加数据得到相应的ID

1,比如在添加商品是,id是数据库自增的,要得到添加商品的响应id,直接在mybatis的Mapper.xml里面添加两个字段就能直接得到相应的id

useGeneratedKeys="true" keyProperty="id"

  <insert id="insert" parameterType="com.zhiyu.pojo.Businesspro" useGeneratedKeys="true" keyProperty="id"  >
    insert into businesspro (id, logo, monthly, 
      loadday, information, applyeligibility, 
      needmater, fasttime, maxperiod, 
      introduce, applynum, makenum, 
     )
    values (#{id,jdbcType=INTEGER}, #{logo,jdbcType=VARCHAR}, #{monthly,jdbcType=VARCHAR}, 
      #{loadday,jdbcType=INTEGER}, #{information,jdbcType=VARCHAR}, #{applyeligibility,jdbcType=VARCHAR}, 
      #{needmater,jdbcType=VARCHAR}, #{fasttime,jdbcType=VARCHAR}, #{maxperiod,jdbcType=VARCHAR}, 
      #{introduce,jdbcType=VARCHAR}, #{applynum,jdbcType=INTEGER}, #{makenum,jdbcType=INTEGER}, 
     )
  </insert>

2,可以直接得相应的id

Integer id = businesspro.getId();