Mybatis 怎么返回新增数据的id
问题描述:
业务中需要用到新插入数据的自增id,但默认的mybatis插入语句并没有返回,这时候你只需在mapper文件的insert 语句中添加这两个属性,自增id就会自动注入新增的对象中 keyColumn=“id” keyProperty="id"
解决方案:
<insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.macro.mall.model.AmsGroupBuyingOpenGroup">
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into ams_group_buying_open_group (group_buying_id, production_id, member_id,
group_number_now, group_number_limit, activity_status,
create_time, stop_time, user_name,4
update_time, backup1, backup2,
tag_delete)
values (#{groupBuyingId,jdbcType=INTEGER}, #{productionId,jdbcType=INTEGER}, #{memberId,jdbcType=BIGINT},
#{groupNumberNow,jdbcType=INTEGER}, #{groupNumberLimit,jdbcType=INTEGER}, #{activityStatus,jdbcType=INTEGER},
#{createTime,jdbcType=TIMESTAMP}, #{stopTime,jdbcType=TIMESTAMP}, #{userName,jdbcType=VARCHAR},
#{updateTime,jdbcType=TIMESTAMP}, #{backup1,jdbcType=VARCHAR}, #{backup2,jdbcType=VARCHAR},
#{tagDelete,jdbcType=VARCHAR})
</insert>