oracle新特性自增,mybatis自定义sql保存数据时返回自增id
@Options(useGeneratedKeys = true,keyColumn = "id",keyProperty = "id")
@InsertProvider(type = SqlProviderUtil.class, method = "provideSaveSql")
Long save(@Param("saveMap") Map<String, Object> saveMap);
oracle新特性可以创建自增序列
create table GEN_MDM_CUSTOMER_APPLY
(
ID NUMBER generated as identity
constraint PK_SYS_GEN_MDM_CUSTOMER_APPLY
primary key,
)
这时mybatis保存时会将id自动保存在saveMap里。