jspshop.sql

基于JAVAJSP的网上书店系统需要的下载 希望对大家有用

--建立自动增长序列号,INSERT 语句插入这个字段值为: 序列号的名称.NEXTVAL
create sequence admin_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立ad表
drop table ad;
create table ad(id number(6),url varchar2(100),wordlink varchar2(60),content varchar2(200),
		bs number(2));
create sequence ad_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立admin表
drop table admin;
create table admin(admin_id number(6),admin_name varchar2(20),admin_pass varchar2(40));
--建立basket表 注意是非数据类型 true false
drop table basket;
create table basket(basket_id number(6),hw_id varchar2(6),user_name varchar2(40),
		basket_count varchar2(6),basket_date date default Sysdate,basket_check varchar2(10),
		basket_admincheck  varchar2(10),hw_name varchar2(40),hw_cash varchar2(10),
		sub_number varchar2(40),daili varchar2(40));
create sequence basket_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立company表
drop table company;
create table company(id number(6),com_name varchar2(40));
create sequence company_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立dlpf表 user->dlpf_user
drop table dlpf;
create table dlpf(id number(6),dlpf_user varchar2(40),pass varchar2(40),tel varchar2(20),
		code varchar2(20),fax varchar2(20),company varchar2(40),mobile varchar2(20),
		type varchar2(20));
create sequence dlpf_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立guest表 date->guest_date
drop table guest;
create table guest(id number(6),name varchar2(20),mail varchar2(40),title varchar2(200),
		content varchar2(1000),guest_date varchar2(20));
create sequence guest_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立hw表 注意时间类型,是非类型 data->hw_data
drop table hw;
create table hw(hw_id number(6),sort_id number(6),nsort_id number(6),hw_name varchar2(40),
		hw_cash number(6,2),hw_content varchar2(2000),hw_content2 long,hw_views number(6),
		hw_buys number(6),hw_date date default Sysdate,hw_pic varchar2(40),chubsh varchar2(40),
		daili number(6,2),pifa number(6,2),zhuang varchar2(20),hw_sn varchar2(40),
		company varchar2(40),yeshu varchar2(6),hw_data date,kaiben varchar2(10),
		isbn varchar2(40),tuijian varchar2(10),jia varchar2(10));
create sequence hw_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立logo表
drop table logo;
create table logo(id number(6),banner varchar2(100),url varchar2(100));
create sequence logo_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立member表
drop table member;
create table member(user_id number(6),user_name varchar2(40),user_pass varchar2(40),
		user_mail varchar2(40),user_adds varchar2(100),user_tel varchar2(20),
		user_regtime date default Sysdate,user_regip varchar2(40),user_lasttime date,
		user_lastip varchar2(40),user_buymoney varchar2(10),user_postcode varchar2(20),
		user_namec varchar2(20),user_type varchar2(10));
create sequence member_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立modify表 modify->modify2 type->modify_type
drop table modify2;
create table modify2(id number(6),void varchar2(40),config varchar2(100),
		sn varchar2(40),modify_type varchar2(10));
create sequence modify2_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立news表
drop table news;
create table news(news_id number(6),newsclass_id varchar2(10),news_title varchar2(200),
		news_content long,news_date date default Sysdate);
create sequence news_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立newsclass表
drop table newsclass;
create table newsclass(newsclass_id number(6),newsclass_name varchar2(20));
create sequence newsclass_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立Nsort表
drop table Nsort;
create table Nsort(Nsort_id number(6),Nsort_name varchar2(20),sort_id number(6));
create sequence Nsort_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立ps表 date->ps_date time->ps_time
drop table ps;
create table ps(ID number(6),am_uid varchar2(20),title varchar2(100),msg number(6),
		ps_date date,ps_time date);
create sequence ps_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立pub表 date->pub_date time->pub_time
drop table pub;
create table pub(ID number(6),am_uid varchar2(20),title varchar2(100),msg varchar2(2000),
		pub_date date,pub_time date);
create sequence pub_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立sort表
drop table sort;
create table sort(sort_id number(6),sort_name varchar2(20));
create sequence sort_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立sub表
drop table sub;
create table sub(sub_id number(6),basket_id varchar2(6),user_name varchar2(40),
		sub_date date default Sysdate,sub_number varchar2(40),sub_check  varchar2(10),
		sub_to varchar2(40),sub_mail varchar2(40),sub_tel varchar2(20),
		sub_adds varchar2(100),sub_post varchar2(40),qian varchar2(20),
		other varchar2(400));
create sequence sub_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立System表
drop table system;
create table system(id number(6),name varchar2(20),mail varchar2(40),web varchar2(40),
		tel varchar2(20),oicq varchar2(10),sitename varchar2(40),fax varchar2(20),
		maddr varchar2(60),msn varchar2(40),mname varchar2(20),code varchar2(20),
		ymaddr varchar2(60),ymname varchar2(20),wxlname varchar2(20),wxlqq varchar2(20),
		wxlsite varchar2(40),wxlmail varchar2(40));
create sequence system_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;
--建立ts表
drop table ts;
create table ts(ts_id number(6),user_name varchar2(60),sub_number varchar2(40),ts_date date default Sysdate);
create sequence ts_auto increment by 1 start with 1 maxvalue 999999 cycle nocache;

insert into ad(id,url,wordlink,content,bs)values(ad_auto.NEXTVAL,'http://ershou.rucca.org','人大二手网','haha',1);
insert into admin(admin_id,admin_name,admin_pass) values(admin_auto.NEXTVAL,'admin','admin');
insert into hw(hw_id,sort_id,nsort_id,hw_name,hw_cash,hw_content,hw_content2,hw_views,hw_buys,
               hw_pic,chubsh,daili,pifa,zhuang,hw_sn,yeshu,hw_data,kaiben,isbn,tuijian,jia)values(
               hw_auto.NEXTVAL,1,1,'若吉亚',3000,'简单介绍一下','详细介绍',0,0,'pic/t208.jpg','unknown',
               2500,2000,'normal','unknown','400',to_date('2002-10-2','yy-mm-dd'),'16','不想','false',
               'false');
insert into logo(id,banner,url)values(logo_auto.NEXTVAL,'img/banner1.gif','http://ershou.rucca.org');
insert into logo(id,banner,url)values(logo_auto.NEXTVAL,'img/banner1.gif','http://ershou.rucca.org');
insert into Nsort(Nsort_id,Nsort_name,sort_id)values(Nsort_auto.NEXTVAL,'若吉亚',1);
insert into pub(ID,title,msg)values(pub_auto.NEXTVAL,'公告公告','郁闷');
insert into sort(sort_id,sort_name)values(sort_auto.NEXTVAL,'若吉亚');
insert into system(id,name,mail,web,tel,oicq,sitename,fax,maddr,msn,mname,code,ymaddr,ymname,wxlname,
                  wxlqq,wxlsite,wxlmail)values(system_auto.NEXTVAL,'ckstudio','[e-mail]',
                  'ckstudio','62517702','9411529','购物系统','62517725','账号','958484958495','jiang',
                  '10875','人民大学','哈哈','haha','5152964','haha','haha');