When we use the Insert database, the large department ID is self-growing, it needs to return the ID, and then insert the related relational table. But sometimes the same problem can be thrown, such as the following scenario:
Start with int as ID self-increment, return related primary key value, but later change, change to string type, use UUID to assign value, but when Ibatis, still keep the following configuration:
<insert id= "insertinternet" parameterclass= "Dmgroupdo" > INSERT into Dm_group (id,name,status,u_id,members) VA Lues (#id #, #name #, #status #, #uId #, #members #) <selectkey keyproperty= "id" resultclass= "java.lang.String" > SELECT last_insert_id () as Value </selectKey> </insert>
As a result, once the Bean object is returned, the ID of the bean is called again, and the result is returned as a number, because Ibatis assigns the queried number type to the Bean's ID field.
Ibatis Selectkey Usage Precautions