mybatis入门(1)——selectKey
在使用mybatis insert时,使用id自增有时需要返回最新插入的id;
<insert id="insert" parameterType="com.zmh.projectoa.model.Users">
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
SELECT LAST_INSERT_ID()
</selectKey>
insert into users (username, password, realname,
department_id, position_id, is_del,
last_login_time, create_time, update_time
)
values (#{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}, #{realname,jdbcType=VARCHAR},
#{departmentId,jdbcType=INTEGER}, #{positionId,jdbcType=INTEGER}, #{isDel,jdbcType=VARCHAR},
#{lastLoginTime,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{updateTime,jdbcType=TIMESTAMP}
)
</insert>
order:如果是before的话,先执行SELECT LAST_INSERT_ID(),再执行insert
如果是after,先执行insert,再执行SELECT LAST_INSERT_ID()
单独执行SELECT LAST_INSERT_ID()只会返回0