Mybatis 3.1.1 insert function

Question

I work Mybatis 3.1.1 and Postgresql 9.2. I Have Class Student (id, name). I want to insert a new record in the database and get its Id.

my code is

Student s=new Student();
s.setName("javagc");
studentMapper.insertSelective(s);

but s.getId() is null.

Can anybody help me?

score 0 · Accepted Answer · edited May 23 '17 at 11:50

Which database are you using?

It should work on MySql, as mentioned in these questions; Get the id of last inserted record in mybatis, How to obtain last insert id in Oracle using MyBatis?

I could not be able to make it work on my Oracle DB. So I manually took the current value of the sequence after the insertion.

<insert id="insertSelective" parameterType="myObject">
        <selectKey keyProperty="seq_id" order="AFTER" resultType="int">
              SELECT mySchema.myTable_seq.currval FROM dual
        </selectKey>
            INSERT INTO mySchema.myTable . . . 
</insert>

Mybatis 3.1.1 insert function

1 Answers1