myibatis3 oracle 数据库自动生成自增id

 

 

 <insert id="insert_save" parameterType="Resources" >
 insert into sys_resource(id, name, type, url, parent_id, parent_ids, permission, available)
 values
     (sql_id.nextval, #{name,jdbcType=VARCHAR}, #{type}, #{url}, #{parentId}, #{parentIds}, #{permission}, #{available})
 
 </insert>

 

 

id: 自动增加

sql_id： 序列号

 

create sequence SQL_ID
minvalue 1
maxvalue 9999999999999999999999999999
start with 220
increment by 1
cache 20;