在使用MyBatis做持久层时,insert语句默认是不返回记录的主键值,而是返回插入的记录条数;
如果业务层需要在插入数据的同时获取到自增主键的时候,可以采用以下方式
方法一、针对oracle数据库 Sequence主键的方式
<insert id="add" parameterType="com.LearnTrainDoc">
<selectKey keyProperty="id" resultType="java.lang.String" order="BEFORE">
select lp_learn_train_doc.nextval from dual
</selectKey>
insert into lp_learn_train_doc (id, learn_catagory_code, learn_catagory_name,
catagory_code, catagory_name, learn_doc_name,
upload_user, upload_time, doc_status,
remark, last_update)
values (#{id,jdbcType=INTEGER}, #{learnCatagoryCode,jdbcType=VARCHAR}, #{learnCatagoryName,jdbcType=VARCHAR},
#{catagoryCode,jdbcType=VARCHAR}, #{catagoryName,jdbcType=VARCHAR}, #{learnDocName,jdbcType=VARCHAR},
#{uploadUser,jdbcType=VARCHAR}, #{uploadTime,jdbcType=TIMESTAMP}, #{docStatus,jdbcType=VARCHAR},
#{remark,jdbcType=VARCHAR}, #{lastUpdate,jdbcType=TIMESTAMP})
</insert>
方法二、针对mysql数据库 自增主键的方式
<insert id="save"
useGeneratedKeys="true" keyColumn="id" keyProperty="id"
parameterType="com.LearnTrainDoc" >
insert into lp_learn_train_doc (id, learn_catagory_code, learn_catagory_name,
catagory_code, catagory_name, learn_doc_name,
upload_user, upload_time, doc_status,
remark, last_update)
values (#{id,jdbcType=INTEGER}, #{learnCatagoryCode,jdbcType=VARCHAR}, #{learnCatagoryName,jdbcType=VARCHAR},
#{catagoryCode,jdbcType=VARCHAR}, #{catagoryName,jdbcType=VARCHAR}, #{learnDocName,jdbcType=VARCHAR},
#{uploadUser,jdbcType=VARCHAR}, #{uploadTime,jdbcType=TIMESTAMP}, #{docStatus,jdbcType=VARCHAR},
#{remark,jdbcType=VARCHAR}, #{lastUpdate,jdbcType=TIMESTAMP})
<selectKey resultType="int" keyProperty="id" order="AFTER">
SELECT LAST_INSERT_ID()
</selectKey>
</insert>
切记:不要把Mybatis的insert方法返回值当成主键!!! 这个返回是是影响行数。
获取主键的时候需要从对象的getId()方法获取,相当于Mybatis再做完insert动作后把id又set到model对象中