Mybatis插入时获取主键id

一。例子

xml

<insert id="insert" parameterType="com.wtoip.yuncore.entity.tech.SafeFile" useGeneratedKeys="true" keyProperty="id">
    insert into yun_safe_file (id, parent_id, name, 
      total_size, record_id, create_time, 
      create_name, path, status, 
      type,org_no,company_name,flag,org_id,user_type,file_id,user_id)
    values (#{id,jdbcType=BIGINT}, #{parentId,jdbcType=BIGINT}, #{name,jdbcType=VARCHAR}, 
      #{totalSize,jdbcType=BIGINT}, #{recordId,jdbcType=VARCHAR}, #{createTime,jdbcType=TIMESTAMP}, 
      #{createName,jdbcType=VARCHAR}, #{path,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, 
      #{type,jdbcType=VARCHAR},#{orgNo,jdbcType=VARCHAR},#{companyName,jdbcType=VARCHAR},1,#{orgId,jdbcType=VARCHAR}
      ,#{userType,jdbcType=VARCHAR},#{fileId,jdbcType=VARCHAR},#{userId,jdbcType=VARCHAR}
      )
      <selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id" >
          SELECT LAST_INSERT_ID()
      </selectKey>
  </insert>

 

controller 使用

            SafeFile safeFile = new SafeFile();
            safeFile.setParentId(Long.parseLong("1"));
            safeFile.setPath("333");
           int count =  safeFileDao.insert(safeFile);
           logger.info(count+""+"id="+safeFile.getId());