原文地址 http://roc08.iteye.com/blog/1172710
sql server和mysql都可以设置主键自增&＃xff0c;而oracle主键是没有自增属性的&＃xff0c;可以通过如下两种方式实现&＃xff1a;
1、建立序列通过触发器实现 创建序列 Java代码
- CREATE SEQUENCE MESSAGEID MINVALUE 1 MAXVALUE START WITH 1 INCREMENT BY 1 NOCACHE;
Java代码
- CREATE OR REPLACE TRIGGER ID_TRIGGER
- BEFORE INSERT ON box FOR EACH ROW DECLARE newId NUMBER(18,0);
- BEGIN SELECT MESSAGEID.nextval INTO newId FROM dual; :new.Id :&＃61; newId;
- END;
Java代码
- CREATE SEQUENCE MESSAGEID MINVALUE 1 MAXVALUE START WITH 1 INCREMENT BY 1 NOCACHE;
Java代码
- SELECT MESSAGEID.nextval FROM dual;
Java代码
- INSERT INTO box(id,name) VALUES(MESSAGEID.nextval,"sa")
京公网安备 11010802041100号