在insert标签加两个属性 "useGeneratedKeys"与"keyProperty"其中后者的值对应pojo的id变量名
<insert id="insUser" useGeneratedKeys="true" keyProperty="id" parameterType="user">
</insert>
在insert内标签内添加语句"keyProperty"的值对应pojo的id变量名
<insert id="add" parameterType="order">
<selectKey resultType="java.lang.Integer" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID()
</selectKey>
insert into
t_order
(member_id,orderDate,orderType,orderStatus,setmeal_id)
values
(#{memberId},#{orderDate},#{orderType},#{orderStatus},#{setmealId})
</insert>