Implementation of mybatis Oracle autoincrement sequence

The code of mybatis Oracle autoincrement sequence is as follows:

Resulttype = "int" returns an int type

Keyproperty assigns the return value to the property of the object in the parametertype, that is, s in the xxxxx class_ ID attribute

Returns the sequence ID, which can be left blank if not required

Let's take a look at mybatis configuring the self growth of Oracle's primary key

Mysql, sqlserver and other databases have their own primary key self growth, such as auto_ The function of increment can be used directly

Usegeneratedkeys = "true", such as the following configuration

Oracle cannot. The self growth of Oracle primary key is realized through sequence, so this method is not allowed. You need to use:

1. First find out the ID through sequence, and then insert it

2. Directly insert sequence Nextval, as follows