mybatis连接oracle 解决主键自增及插入数据后返回主键问题

自增 

#Oracle解决ID自增问题
为每各一个自增的表创建序列和触发器 注意替换[]中的表名

#创建序列
create sequence [ROLE_INFO]_SEQ increment by 1 start with 1 nomaxvalue nocycle cache 20;
#重置序列
ALTER SEQUENCE TEMPLATE_PROJECT_SEQ INCREMENT BY 200;
SELECT TEMPLATE_PROJECT_SEQ.NEXTVAL FROM DUAL;
ALTER SEQUENCE TEMPLATE_PROJECT_SEQ INCREMENT BY 1;

#创建触发器
CREATE OR REPLACE TRIGGER [ROLE_INFO]_TGR
 BEFORE INSERT ON [ROLE_INFO]
 FOR EACH ROW
DECLARE
 NEXT_ID NUMBER;
BEGIN
 SELECT [ROLE_INFO]_SEQ.NEXTVAL INTO NEXT_ID FROM DUAL;
 :NEW.ID := NEXT_ID;
END;

#具体执行SQL ------------------------------------------------------------------

create sequence ROLE_INFO_SEQ increment by 1 start with 1 nomaxvalue nocycle cache 20;
create sequence AUTH_INFO_SEQ increment by 1 start with 1 nomaxvalue nocycle cache 20;
create sequence INTERNAL_USERS_SEQ increment by 1 start with 1 nomaxvalue nocycle cache 20;

CREATE OR REPLACE TRIGGER ROLE_INFO_TGR
 BEFORE INSERT ON ROLE_INFO
 FOR EACH ROW
D