oracle 自增列 create table order ( OrderNO number, primary key(OrderNO), ); //建表 CREATE SEQUENCE order_pk START WITH 1 INCREMENT BY 1 MAXVALUE 1E30 NOCYCLE NOCACHE;//创建序列 CREATE TRIGGER order_list_pk//触发器 BEFORE INSERT ON order//在插入此表时 FOR EACH ROW//为每一条记录 BEGIN select order_pk.nextval into :new.OrderNO from dual; END; /
import java.util.*; public class CountInstances extends Thread{ public void run(){ for(;;){ System.out.println(new Date().toLocaleString()); try{ Thread.sleep(5000); } catch(Exception e){ e.printStackTrace(); } } } public static void main(String arguments []){ new CountInstances().start(); } }
还有第一题要用SQL语句的..
oracle 自增列
create table order
(
OrderNO number,
primary key(OrderNO),
); //建表
CREATE SEQUENCE order_pk START WITH 1 INCREMENT BY 1 MAXVALUE 1E30 NOCYCLE NOCACHE;//创建序列
CREATE TRIGGER order_list_pk//触发器
BEFORE INSERT ON order//在插入此表时
FOR EACH ROW//为每一条记录
BEGIN
select order_pk.nextval
into :new.OrderNO
from dual;
END;
/
import java.util.*;
public class CountInstances extends Thread{
public void run(){
for(;;){
System.out.println(new Date().toLocaleString());
try{
Thread.sleep(5000);
}
catch(Exception e){
e.printStackTrace();
}
}
}
public static void main(String arguments []){
new CountInstances().start();
}
}