参考:
https://www.cnblogs.com/w1217/p/5541631.html
MyBatis框架——mybatis插入数据返回主键(mysql、oracle)
(1)mybaties的mysql方式
keyProperty="id" id为实体的属性
<!--添加用户信息 -->
<insert id="insert" parameterType="com.model.User">
<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">
select LAST_INSERT_ID()
</selectKey>
insert into tbl_user(user_name,user_pwd,user_level,user_phone)
values(#{user_name},#{user_pwd},#{user_level},#{user_phone})
</insert>
(2)mybaties的oracle方式
需要先创建一个名称为USER_ID_SEQ的序列 userId为实体的属性
利用USER_ID_SEQ.NEXTVAL 获得要插入数据的主键:
<insert id="insertUser" parameterType="com.danny.mybatis.po.User">
<selectKey keyProperty="userId" order="BEFORE" resultType="java.lang.Integer">
select USER_ID_SEQ.NEXTVAL as userId from DUAL
</selectKey>
insert into T_USER(userId,userName,birthday,sex,address) values (#{userId},#{userName},# {birthday},#{sex},#{address})
</insert>