springboot获取mybatis插入自增id（mysql）

 

首先按照以下语法编写，主要加入了keyProperty="id" useGeneratedKeys="true"。

<insert id="insertPersonManage" keyProperty="id" useGeneratedKeys="true">
       insert into organization_manager_info(
       orgId, appointStatus, empId, mantPeriod, isOrgRight, isOrgIndeRight,isPostRight,isPostIndeRight,
       isManagerRight, isMangerIndeRight, isTransferRight, isTransferIndeRight,detail, addPeople )values(
       #{orgId},#{appointStatus} , #{empId}, #{mantPeriod}, #{isOrgRight}, #{isOrgIndeRight},#{isPostRight},#{isPostIndeRight},
       #{isManagerRight} ,#{isMangerIndeRight} , #{isTransferRight}, #{isTransferIndeRight},#{detail}, #{addPeople})
    </insert>

keyProperty="id" useGeneratedKeys="true"

然后在入参的VO中获取就可以了

public void insertPersonManage(OrganizationManagerInfoBO organizationManagerInfoBo){
        personInChargeManage.insertPersonManage(organizationManagerInfoBo);
        //获取自增ID
        Long id = organizationManagerInfoBo.getId();
        //如果直接生成的正常状态 那么在日志表生成一条新记录
        if(FROMAL.equals(organizationManagerInfoBo.getAppointStatus())){
            OrganizationManagerInfoBO logOrganizationManagerInfoBo = new OrganizationManagerInfoBO();
            //原表数据转换到日志表中
            BeanUtils.copyProperties(organizationManagerInfoBo,logOrganizationManagerInfoBo);
            logOrganizationManagerInfoBo.setOrgManagerInfoId(id);
        }
    }