-- Create sequence
create sequence LOGININFOR_INFOID_SEQ
minvalue 100
maxvalue 99999999
start with 1080
increment by 1
cache 20;
sql创建一个sequence ,或者在PL/SQL里面是这样的创建:
在代码里面这样调用:
LOGININFOR_INFOID_SEQ.Nextval
例如:
insert into sys_logininfor (info_id,user_name, status, ipaddr, login_location, browser, os, msg, login_time)
values (LOGININFOR_INFOID_SEQ.Nextval,#{userName}, #{status}, #{ipaddr}, #{loginLocation}, #{browser}, #{os}, #{msg}, sysdate)
效果: