dada第一版本.sql.txt

刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下

#以下是“达达网上购书中心”项目第一版本所需的SQL脚本程序
#将其复制到Mysql数据库控制台中
#创建所需要的数据库和表

#删除数据库DB_DADA
drop database DB_DADA;

#创建数据库DB_DADA，设置可处理中文字符集
create database DB_DADA character set utf8;

#使用数据库DB_DADA
use DB_DADA;

#删除表TAB_CATELOG
drop table TAB_CATELOG;

#创建表TAB_CATELOG
create table TAB_CATELOG(
    id    	bigint    	
		primary key    auto_increment,
    name  	varchar(10)	
);

#向表TAB_CATELOG插入3条记录
insert into TAB_CATELOG(name)
values('计算机');

insert into TAB_CATELOG(name)
values('文学');

insert into TAB_CATELOG(name)
values('小说');

#删除表TAB_BOOKINFO
drop table TAB_BOOKINFO;

#创建表TAB_BOOKINFO
create table TAB_BOOKINFO(
    id    	bigint    	
		primary key    auto_increment,
    name  	varchar(20),
    author      varchar(20),
    publisher   varchar(20),
    price	 double,
    catelog     bigint 
                references     TAB_CATELOG(id) 	
);

#向表TAB_BOOKINFO插入25条记录
insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通Struts','孙卫琴','人民邮电',39,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通Spring','孙卫琴','人民邮电',53,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通Hibernate','孙卫琴','机械工业',45,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通AJAX','梁明','机械工业',29,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通AspectJ','赵强','机械工业',39,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通Eclipse','梁明','机械工业',53,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通JDO','梁明','电子工业',45,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('精通SQL','何肃','电子工业',29,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('Hibernate应用开发完全手册','李钟','电子工业',59,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('Spring应用开发完全手册','李钟','电子工业',59,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('Eclipse应用开发完全手册','李钟','清华大学',59,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('Struts应用开发完全手册','李钟','清华大学',59,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('VB数据库系统开发完全手册','王明','清华大学',59,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('Delphi数据库系统开发完全手册','王明','清华大学',48,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('JSP数据库系统开发完全手册','王明','北京大学',79,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('C#数据库系统开发完全手册','刘斌','北京大学',39,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('C++数据库系统开发完全手册','刘斌','北京大学',49,1);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('西游记','吴承恩','世界华语',77,2);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('三国','罗贯中','世界华语',99,2);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('故宫','林一达','世界华语',45,2);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('长江','苏中和','世界华语',66,2);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('生活','张三','中国青年',39,3);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('学习','李四','中国青年',49,3);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('娱乐','王五','中国青年',19,3);

insert into TAB_BOOKINFO(name,author,publisher,price,catelog)
values('休闲','钱二','中国青年',30,3);

#删除客户基本信息表
drop table TAB_USERINFO;

#客户基本信息表
create table TAB_USERINFO(
    id           bigint         
		 primary key auto_increment,
    username     varchar(10),       
    password     varchar(10),
    realname     varchar(20),
    tel          varchar(15),
    address      varchar(30),
    email        varchar(30) 
);

#删除订单信息表
drop table TAB_ORDER;

#创建订单信息表
create table TAB_ORDER(
    id           bigint         
		 primary key auto_increment,
    realname     varchar(20),     
    payway	 varchar(20),
    totalPrice   double,
    orderStatus  varchar(20),
    time	 date
);