网上书店管理系统（详细代码）

rem------------------------------------------------------------------- rem-------------------网上书店系统数据库脚本-------------------------- rem-------------------脚本 0061392script.sql清单---------------------- rem------------------------------------------------------------------- rem-------------------功能：建立与网上书店相关的信息------------------ rem-------------------作者：------------------------------------------ rem-------------------学号：------------------------------------------ rem-------------------首次创建时间：2009年4月24日--------------------- rem-------------------最后修改时间：2009年5月3日---------------------- rem------------------------------------------------------------------- rem-------------------删除表------------------------------------------ drop table Tb_BookInfor; drop table Tb_SaleItem; drop table Tb_Express; drop table Tb_Employee; drop table Tb_Member; drop table Tb_ShopingList; rem-------------------表的建立---------------------------------------- rem------------------------------------------------------------------- rem-------------------图书信息表-------------------------------------- rem------------------------------------------------------------------- Create table Tb_BookInfor( Barcode char(10) not null, --图书编号 BookName varchar2(30) not null, --图书名称 Author varchar2(30) not null, --作者姓名 Bookconcern varchar2(30) not null, --出版社 PublishDate date not null, --出版时间 UnitPrice numeric(7,2) not null, --售价 KindName varchar2(30) not null, --图书种类 Count int not null, --图书数量 Synopsis varchar2(200) null, --简介 constraint PK_BookInfor primary key(Barcode) --主码Barcode ); rem------------------------------------------------------------------- rem-------------------图书信息表数据---------------------------------- rem------------------------------------------------------------------- insert into Tb_BookInfor values('B000000001','操作系统','吴斌','电子工业出版社','01-5月-2008','40','计算机',25,''); insert into Tb_BookInfor values('B000000002','数据库系统原理','王珊','电子工业出版社','11-8月-2005','32','计算机',10,''); insert into Tb_BookInfor values('B000000003','欧美文学欣赏','郭沫若','清华出版社','23-7月-2002','48','文化',4,''); insert into Tb_BookInfor values('B000000004','奥林匹克发展史','姚明','机械工业出版社','05-6月-2004','30','体育',6,''); insert into Tb_BookInfor values('B000000005','音乐鉴赏','吴雅玲','中国铁道出版社','12-11月-2006','25','音乐',7,''); insert into Tb_BookInfor values('B000000006','交响乐欣赏','尚乐文','科学出版社','01-5月-2007','20','音乐',15,''); insert into Tb_BookInfor values('B000000007','黑洞形成','霍金','电子工业出版社','01-5月-2008','40','科普',8,''); insert into Tb_BookInfor values('B000000008','蓝猫三千问','宋波','科学出版社','08-1月-2009','12','少儿',4,''); insert into Tb_BookInfor values('B000000009','电子线路基础','周忠宝','电子工业出版社','07-6月-2004','40','电子',14,''); insert into Tb_BookInfor values('B000000010','电路板合成原理','周忠宝','电子工业出版社','08-12月-2005','50','电子',10,''); rem------------------------------------------------------------------- rem-------------------快递公司信息表---------------------------------- rem------------------------------------------------------------------- create table Tb_Express( ExpressID char(5) not null, --快递公司编号 ExpressName varchar2(30) not null, --快递公司名称 TelephoneNo varchar2(15) not null, --电话 constraint pk_ExpressID primary key(ExpressID) --主码ExpressID ); rem------------------------------------------------------------------- rem-------------------快递公司表数据---------------------------------- rem------------------------------------------------------------------- insert into Tb_Express values('KD001','申通快递','0791-7602154'); insert into Tb_Express values('KD002','圆通快递','0001-75326541'); insert into Tb_Express values('KD003','中通快递','0654-15975321'); rem-------------------------------------------------------------------- rem-------------------员工表------------------------------------------- rem-------------------------------------------------------------------- Create table Tb_Employee( EmployeeNo char(5) not null, --员工编号 EmployeeName char(10) not null, --员工姓名 Sex char(2) check(sex in('男','女')) not null, --员工性别 Password varchar2(20) not null, --员工密码 Salary int not null, --薪水 TelephoneNo varchar2(15) null, --电话 Address varchar2(50) null, --员工住址 constraint PK_Employee primary key(EmployeeNo) --主码EmployeeNo ); rem-------------------------------------------------------------------- rem-------------------员工表数据--------------------------------------- rem-------------------------------------------------------------------- insert into Tb_Employee values('E0001','李宁甫','男','1238452456',4800,'15170453789','南京市北京'); insert into Tb_Employee values('E0002','王世光','男','1645651541',3600,'15170455678','上海市南京'); insert into Tb_Employee values('E0003','归红梅','女','1232145456',5000,'15170456099','武汉市青山'); insert into Tb_Employee values('E0004','李远深','男','1239875456',5600,'15976890988','南昌市经济技术开发区'); rem-------------------------------------------------------------------- rem-------------------会员表------------------------------------------- rem-------------------------------------------------------------------- Create table Tb_Member( MemberNo char(5) not null, --会员编号 MemberName varchar2(30) not null, --会员姓名 PassWord varchar2(20) not null, --密码 grade integer null, --等级 Sex char(2) check(sex in('男','女')) not null, --性别 Email varchar2(30) not null, --电子邮箱 Address varchar2(50) not null, --地址 TelephoneNo varchar2(15) not null, --电话 constraint PK_Member primary key(MemberNo) --主码MemberNo ); rem-------------------------------------------------------------------- rem-------------------会员表数据--------------------------------------- rem-------------------------------------------------------------------- insert into Tb_Member values('00001','李小强','356789','1','男','lxq@163.com', '上海市','021-34567897'); insert into Tb_Member values('00002','胡振生','789098','0','男','hzs@163.com', '天津市','022-6485888'); insert into Tb_Member values('00003','刘伟成','679089','0','男','lwc@126.com', '武汉市','027-7806788'); insert into Tb_Member values('00004','王世荣','797443','0','男','wsr@gmail.com', '南京市','025-73566527'); insert into Tb_Member values('00005','易继声','358999','1','男','yjs@yahoo.com', '南昌市','025-83754948'); insert into Tb_Member values('00006','李武威','675778','0','男','lww@126.com', '重庆市','023-25457799'); insert into Tb_Member values('00007','曾丽丽','858457','0','女','zll@yahoo.com', '赣州市','0797-8794354'); insert into Tb_Member values('00008','刘赣山','893599','0','男','lgs@163.com', '武汉市','027-256633237'); insert into Tb_Member values('00009','武亦芬','895435','0','女','wyf@126.com', '武汉市','027-098388438'); insert into Tb_Member values('00010','贾艳艳','353556','0','女'