五分钟带你玩转mybatis（四）spring boot获取mybatis插入自增id（mysql）

  

   

    

     

    
    

     

          <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);
     
    
   

    

     

    
    

     

              }
     
    
   

    

     

    
    

     

          }
     
    
  
 

文章来源: baocl.blog.csdn.net，作者：小黄鸡1992，版权归原作者所有，如需转载，请联系作者。

原文链接：baocl.blog.csdn.net/article/details/84978838