jsp+oracle新网站，数据库汇总。

内容数据表

create table web_content(id number(4),  type varchar2(50),title varchar2(500), content long,input date default sysdate);

create sequence web_seq
start with 1
increment by 1
minvalue 1
maxvalue 9999
nocache
nocycle;

insert into web_content(id,type,content) values (web_seq.nextval,'main','<p>1982年始创于台湾，1992年进驻点,范围涵盖了主要的口岸以及内陆城市；总部设立在上海；拥有极其富有业务经验的业务团队。并于1999年通过ISO9002认证；FIATA/IATA成员。</p>')
联系人数据表


CREATE TABLE web_contact( 
  id number(3) PRIMARY KEY,
  branch varchar2(50),
  contact long,
  picture varchar2(70)
);
create sequence web_seq_contact  
start with 1  
increment by 1  
minvalue 1  
maxvalue 999
nocache  
nocycle;
仓储分布数据表
CREATE TABLE web_warehouse( 
  id number(3) PRIMARY KEY,
  branch varchar2(50),
  content long,
  picture varchar2(70),
show varchar2(70)
);

CREATE TABLE web_warehouse_en( 
  id number(3) PRIMARY KEY,
  branch varchar2(50),
  content long,
  picture varchar2(70),
show varchar2(70)
);





其自增数据是web_seq