投票系统 strut2 +hibernate

CREATE TABLE VOTE_SUBJECT ( VS_ID NUMBER(10) NOT NULL, VS_TITLE VARCHAR2(200 BYTE), VS_TYPE NUMBER(6) ) TABLESPACE SYSTEM PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX C ON VOTE_SUBJECT (VS_ID) LOGGING TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL; ALTER TABLE VOTE_SUBJECT ADD ( CONSTRAINT C PRIMARY KEY (VS_ID) USING INDEX TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 )); CREATE TABLE VOTE_USER ( VU_USER_ID NUMBER NOT NULL, VU_USER_NAME VARCHAR2(20 BYTE), VU_PASSWORD VARCHAR2(20 BYTE), VU_STATUS NUMBER(6), VU_VERSION NUMBER(10) ) TABLESPACE SYSTEM PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX D ON VOTE_USER (VU_USER_ID) LOGGING TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL; ALTER TABLE VOTE_USER ADD ( CONSTRAINT D PRIMARY KEY (VU_USER_ID) USING INDEX TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 )); CREATE TABLE VOTE_OPTION ( VO_ID NUMBER(10) NOT NULL, VO_OPTION VARCHAR2(100 BYTE), VS_ID NUMBER(10), VO_ORDER NUMBER(10), VOTE_SUBJECT NUMBER, VO_COUNT INTEGER ) TABLESPACE SYSTEM PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX B ON VOTE_OPTION (VO_ID) LOGGING TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL; ALTER TABLE VOTE_OPTION ADD ( CONSTRAINT B PRIMARY KEY (VO_ID) USING INDEX TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 )); CREATE TABLE VOTE_ITEM ( VI_ID NUMBER(10) NOT NULL, VO_ID NUMBER(10), VS_ID NUMBER(10), VU_USER_ID NUMBER, POSTER_ID NUMBER ) TABLESPACE SYSTEM PCTUSED 40 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) LOGGING NOCOMPRESS NOCACHE NOPARALLEL MONITORING; CREATE UNIQUE INDEX A ON VOTE_ITEM (VI_ID) LOGGING TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT ) NOPARALLEL; ALTER TABLE VOTE_ITEM ADD ( CONSTRAINT A PRIMARY KEY (VI_ID) USING INDEX TABLESPACE SYSTEM PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 )); ALTER TABLE VOTE_ITEM ADD ( CONSTRAINT OOOOOOOOO FOREIGN KEY (VU_USER_ID) REFERENCES VOTE_USER (VU_USER_ID) ON DELETE CASCADE); ALTER TABLE VOTE_ITEM ADD ( CONSTRAINT BBBBBBBB FOREIGN KEY (VS_ID) REFERENCES VOTE_SUBJECT (VS_ID) ON DELETE CASCADE); ALTER TABLE VOTE_ITEM ADD ( CONSTRAINT AAAAAA FOREIGN KEY (VO_ID) REFERENCES VOTE_OPTION (VO_ID) ON DELETE CASCADE);