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