java mybatis mysql 插入数据后返回主键值

使用spring boot mybatis 插入一行数据返回主键的值

以添加ApplyRecord为例
VO类ApplyRecord.java

/**
 * 申报记录表
 */
public class ApplyRecordVO {

    /**
     * 申报Id
     */
    private Integer applyId;
	/**
     * 申报内容
     */
    private String applyContent;
    
	public Integer getApplyId() {
        return applyId;
    }

    public void setApplyId(Integer applyId) {
        this.applyId = applyId;
    }
    
	public String getApplyContent() {
        return applyContent;
    }

    public void setApplyContent(String applyContent) {
        this.applyContent = applyContent;
    }

}

Mapper

import com.vo.ApplyRecordVO;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * 申报记录
 */
public interface ApplyRecordMapper {


    /**
     * 用户申报
     * @param applyRecordVO
     * @return
     */
    @Insert("insert into apply_record (" +
            "applyContent)" +
            "values" +
            "({applyRecord.applyContent,jdbcType=VARCHAR})" )
    @Options(useGeneratedKeys = true, keyProperty = "applyId", keyColumn = "applyId")
    int addApplyRecord(ApplyRecordVO applyRecordVO);

Service

import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.transaction.interceptor.TransactionAspectSupport;

import java.beans.Transient;
import java.util.List;

@Slf4j
@Service
public class ApplyRecordService {

    @Autowired
    ApplyRecordMapper applyRecordMapper;

    /**
     * 提交申报记录-返回主键Id
     * @param applyRecordVO
     * @return
     */
    public Integer commitApplyRecord(ApplyRecordVO applyRecordVO){

        //定义返回值
        int applyId = 0;
        applyRecordRow = applyRecordMapper.addApplyRecord(applyRecordVO);
		applyId = applyRecordVO.getApplyId();
        
        return applyId ;
        
    }

}