mybati插入数据后获取主键id问题

Question

问题遇到的现象和发生背景

 <insert id="addRetiredPersonBasicInfo" useGeneratedKeys="true" keyProperty="id"
            parameterType="cn.chinaunicom.modular.sdss.model.DisposableExpenditureVO">

        insert into shh_retired_person_basic_info(org_id, company_name, personal_number, national_identifier,
                                                  emp_name, retire_type, create_by, create_time, update_by, update_time)
        values (#{basicInfo.orgId}, #{basicInfo.orgName}, #{basicInfo.empNumber}, #{basicInfo.nationalIdentifier},
                #{basicInfo.empName}, #{basicInfo.type}, #{basicInfo.createBy}, #{basicInfo.createTime},
                #{basicInfo.updateBy}, #{basicInfo.updateTime})
    </insert>
```sql

返回是null，然后百度解决办法是 去掉 @Param("basicInfo")注解，但是去掉之后报错

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'basicInfo' in 'class cn.chinaunicom.modular.sdss.model.DisposableExpenditureVO'

应该如何解决呢？

Answer 1

去掉 @Param("basicInfo")注解，xml里面 也得去掉 basicInfo. ；就是 #{basicInfo.orgId} 改成 #{orgId}，其他字段一样