MyBatis Add new data to get the self-increment primary key

MyBatis corresponds to MySQL

<InsertID= "Insert"ParameterType= "Com.timestech.wsgk.web.model.SysOrg"Usegeneratedkeys= "true">--------------to get the self-increment ID of the entity class in the service insert INTO BJLT. Sys_org (ID, NAME, p_id, P_name, REMARK, Levels, STATUS, Create_time, create_id, Create_name, Update_tim E, update_id, Update_name, Tree_path, RESERVE1, RESERVE2, RESERVE3, RESERVE4, RESERVE5, Is_root, Is_buil t_in) VALUES (#{id,jdbctype=decimal}, #{name,jdbctype=varchar}, #{pid,jdbctype=decimal}, #{pname,jdbctype=v Archar}, #{remark,jdbctype=varchar}, #{levels,jdbctype=decimal}, #{status,jdbctype=decimal}, #{createTime,jdbcType =date}, #{createid,jdbctype=varchar}, #{createname,jdbctype=varchar}, #{updatetime,jdbctype=date}, #{updateId,       Jdbctype=varchar}, #{updatename,jdbctype=varchar}, #{treepath,jdbctype=varchar}, #{reserve1,jdbctype=varchar}, #{reserve2,jdbctype=varchar}, #{reserve3,jdbctype=varchar}, #{reserve4,jdbctype=varchar}, #{reserve5,jdbcType= VARCHAR}, #{isroot,jdbctype=decimal}, #{isbuiltin,jdbctype=decimal}) </Insert>

MyBatis corresponds to Oracle

<InsertID= "Insert"ParameterType= "Com.timestech.wsgk.web.model.SysOrg" >      <SelectkeyKeyproperty= "id"Resulttype= "_long"Order= "Before">-------------------Get Oracle's self-increment sequence and assign values before addingSELECT BJLT. Sys_org_sequence. Nextval from DUAL</Selectkey> insert INTO BJLT. Sys_org (ID, NAME, p_id, P_name, REMARK, Levels, STATUS, Create_time, create_id, Create_name, Update_tim E, update_id, Update_name, Tree_path, RESERVE1, RESERVE2, RESERVE3, RESERVE4, RESERVE5, Is_root, Is_buil t_in) VALUES (#{id,jdbctype=decimal}, #{name,jdbctype=varchar}, #{pid,jdbctype=decimal}, #{pname,jdbctype=v Archar}, #{remark,jdbctype=varchar}, #{levels,jdbctype=decimal}, #{status,jdbctype=decimal}, #{createTime,jdbcType =date}, #{createid,jdbctype=varchar}, #{createname,jdbctype=varchar}, #{updatetime,jdbctype=date}, #{updateId,       Jdbctype=varchar}, #{updatename,jdbctype=varchar}, #{treepath,jdbctype=varchar}, #{reserve1,jdbctype=varchar}, #{reserve2,jdbctype=varchar}, #{reserve3,jdbctype=varchar}, #{reserve4,jdbctype=varchar}, #{reserve5,jdbcType= VARCHAR}, #{isroot,jdbctype=decimal}, #{isbuiltin,jdbctype=decimal}) </Insert>

MyBatis Add new data to get the self-increment primary key