1. 需求 及准备
需求:当我们需要返回插入数据的id
准备:id 设置为自增
2.实现过程
方式1:
<insert id="testMybatisReturnId" useGeneratedKeys="true" keyProperty="id" parameterType="user" > insert into t_mybitiesid (name,descr) values (#{name},#{descr}); </insert> |
效果:
方式2:
<insert id="testMybatisReturnId" parameterType="user" >
<selectKey resultType="java.lang.Long" order="AFTER" keyProperty="id">
SELECT LAST_INSERT_ID()
</selectKey>
insert into t_mybitiesid (name,descr) values (#{name},#{descr});
</insert>