MyBatis gets the self-increment primary key when inserting (1: Write SQL. 2: Annotated @generatedvalue)

MyBatis getting the self-increment primary key when inserting

Method has two

Method 1:

<insert id= "Insert" parametertype= "person" usegeneratedkeys= "true" keyproperty= "id" >
Insert into person (NAME,PSWD) VALUES (#{name},#{pswd})
</insert>

Method 2:

<insert id= "Insert" parametertype= "person" >
<selectkey keyproperty= "id" resulttype= "long" >
Select LAST_INSERT_ID ()
</selectKey>
Insert into person (NAME,PSWD) VALUES (#{name},#{pswd})
</insert>

The entity id attribute before insertion is 0;

The entity id attribute after insertion is the self-increment ID after saving;

@generatedvalue

MyBatis gets the self-increment primary key when inserting (1: Write SQL. 2: Annotated @generatedvalue)