mybatis使用oracle插入数据返回主键问题

Question

<insert id="saveTagLibrary" parameterType="tagLibrary">
<selectKey resultType="java.lang.Integer" keyProperty="ID" order="BEFORE">
SELECT IBOKEE_COMM_TAG_LIBRARY_SEQ.nextval AS Id FROM DUAL
</selectKey>
insert into IBOKEE_COMM_TAG_LIBRARY(ID,TAG_NAME,STATISTICS) values(IBOKEE_COMM_TAG_LIBRARY_SEQ.nextval,#{tagName},#{statistics})
</insert>
请问我这个有什么问题吗，返回后对象中的主键仍然为null

Answer 1

把下面哪几行放到sql后面试试
<selectKey resultType="java.lang.Integer" keyProperty="ID" order="BEFORE">
SELECT IBOKEE_COMM_TAG_LIBRARY_SEQ.nextval AS Id FROM DUAL
</selectKey>