Mybatis返回自增长主键

<insert id="insertCertificate" parameterType="com.xxx.entity.certificate.Certificate" keyProperty="id"
            useGeneratedKeys="true">
        insert into iot_certificate_info2
        <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
            select LAST_INSERT_ID()
        </selectKey>
       <trim prefix="(" suffix=")" suffixOverrides=",">
        ...........................

在insert into之后加入

  <selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
            select LAST_INSERT_ID()
  </selectKey>

还在插入语句之后返回自增长的id到实体类Certificate的id属性中

CertificateService.saveCertInDb(certObj);
 Integer certificateId = certObj.getId();
log.info("====== certificateId ======>{}",certificateId);