MyBatis (Oracle) How to use the primary key automatically plus 1 when insert

<insert id= "Insert" paramtype= "User" >

<seleckey keyproperty= "id" order= "before" resulttype= "int" >

Select User_sequence.nextval Form Dual

</selectKey>

</insert>

The above attributes describe:

keyproperty= "id": a property in a class

Order: Build Policy: (insert into before or after execution): default is After execution

Sequence in the User_sequence:oracle
To create a sequence:

Create sequence User_sequence

Start with 1

Increment by 1

Nomaxvalue

MinValue 1

Nocycle

Cache 10;

MyBatis (Oracle) How to use the primary key automatically plus 1 when insert