MyBatis中保存数据如何获取数据库的自增id

MyBatis中保存数据如何获取数据库的自增id

1、需要指定如下
useGeneratedKeys=“true” keyColumn=“id” keyProperty=“id”

<insert id="insertConflictAlarm" useGeneratedKeys="true" keyColumn="id" keyProperty="id" parameterType="com.youzidata.airport.entity.ConflictAlarm">
    INSERT INTO conflict_alarm(conflict_type, sector, conflict_voice_id, conflict_info, error_alarm,
                               alarm_status, alarm_chk_user, cr_date)
    VALUES (#{conflict_type}, #{sector}, #{conflict_voice_id}, #{conflict_info}, #{error_alarm},
            #{alarm_status}, #{alarm_chk_user}, #{cr_date})
</insert>

2、然后会将自增id保存到对象中

conflictAlarmDao.insertConflictAlarm(conflictAlarm);

3、然后就可以通过get方法进行获取

int id = conflictAlarm.getId();