Spring+struts2+hibernate框架整合

-- Create table create table ARTICLE ( APP_ARTICLE_ID VARCHAR2(16) not null, ARTICLE_CONTENT VARCHAR2(4000), ARTICLE_EDITOR VARCHAR2(32), ARTICLE_PICTURE VARCHAR2(256), DATE DATE, ARTICLE_TITLE VARCHAR2(256) ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 64 minextents 1 maxextents unlimited ); -- Add comments to the table comment on table ARTICLE is '文章数模'; -- Create/Recreate primary, unique and foreign key constraints alter table ARTICLE add constraint PK_ID primary key (APP_ARTICLE_ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create table create table EVALUATE ( APP_EVALUATE_ID VARCHAR2(20) not null, APP_ARTICLE_ID VARCHAR2(20), E_MAIL VARCHAR2(30), CONTENT VARCHAR2(4000), NAME VARCHAR2(40) ) tablespace USERS pctfree 10 initrans 1 maxtrans 255 storage ( initial 1 minextents 1 maxextents unlimited ); -- Create/Recreate primary, unique and foreign key constraints alter table EVALUATE add constraint P_ID primary key (APP_EVALUATE_ID) using index tablespace USERS pctfree 10 initrans 2 maxtrans 255 storage ( initial 64K minextents 1 maxextents unlimited ); -- Create sequence create sequence EVALUATE_SEQ minvalue 1 maxvalue 9999999999999999999999999999 start with 121 increment by 1 cache 20; -- Create sequence create sequence ARTICLE_SEQ minvalue 1 maxvalue 9999999999999999999999999999 start with 111 increment by 1 nocache;