MyBatis主键回填
<!--
useGeneratedKeys:开启主键回填
keyProperty:主键回填到对象中的那个属性
-->
<insert id="addUser" useGeneratedKeys="true" keyProperty="id">
insert into t_user (name,password) value (#{name},#{password});
</insert>
<!--
<selectKey></selectKey>
keyProperty:主键回填到对象的哪个属性
resultType:主键返回属性的数据类型
order:在插入完成之后或之后进行主键回填
-->
<insert id="addUser1">
<selectKey keyProperty="id" resultType="int" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
insert into t_user (name,password) value (#{name},#{password});
</insert>