网上购物系统-数据库设计.docx

课程设计课程名称_数据库课程设计_题目名称_网上购物系统_学生学院_计算机学院_专业班级_ _学 号_学生姓名_ _指导教师_左亚尧 _2012年 1 月 16 日1.requirement analysis1.1. System name系统名称为网上购物系统1.2. Task summary结合使用jsp和javabean，编写一个在线商务购物系统。这个系统提供了一个客户和企业在线沟通的平台。用户可以浏览企业的产品和信息；通过注册成网站的用户，可以购买产品；并根据自己的需求添加删除和修改订单中商品的数量。管理者可以登录网站后台，管理商品信息，管理用户信息和处理订单。1.3. System functions这个系统具有前台和后台两部分功能。前台为客户提供了注册登录，查看商品，购买商品，处理订单的服务；后台可以添加商品，管理订单和管理用户。1.4. Function details1. 提供注册登录功能，使得用户可以通过注册登录获得购买商品的权限。2. 提供商品列表和某一商品展示的功能3.为登录用户提供购买功能4.管理员登录后，可以管理用户，管理订单和管理商品。2. overall design2.1. UML use case use case2.2. the basic bodelOnlineShoppinguseradminproductlistregister/loginbuy productsuser managerproduct manager3. Database design3.1. Table design3.1.1. table of productlistproductlist3.1.2. table of useruser3.1.3. table of orderlistorderlist3.1.4. table of adminadminlist3.2. EER ModelEER3.3. ER Diagram1orderlistownsnadminlistproductlistuseridusernamepassworduserphonemailiduseridpaywayidadminnameadminpasspidpnamepcomp4. System view4.1. login and register4.2. product list4.3. cart view4.4. register view4.5. admin operation list4.6. show users list5.impressions and experience本系统经过测试，能完成在网上购物系统的基本功能。设计过程中，遇到很多的问题，解决问题要多看书，多想老师的教授。实验之后发现自己对数据库的了解加深了，明白到数据库在一个系统中的重要地位。6. sql file for database- MySQL dump 10.13 Distrib 5.5.25, for Win32 (x86)- Host: localhost Database: shopdb- - Server version5.5.25/*!40101 SET OLD_CHARACTER_SET_CLIENT=CHARACTER_SET_CLIENT */;/*!40101 SET OLD_CHARACTER_SET_RESULTS=CHARACTER_SET_RESULTS */;/*!40101 SET OLD_COLLATION_CONNECTION=COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET OLD_TIME_ZONE=TIME_ZONE */;/*!40103 SET TIME_ZONE=+00:00 */;/*!40014 SET OLD_UNIQUE_CHECKS=UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET OLD_FOREIGN_KEY_CHECKS=FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET OLD_SQL_MODE=SQL_MODE, SQL_MODE=NO_AUTO_VALUE_ON_ZERO */;/*!40111 SET OLD_SQL_NOTES=SQL_NOTES, SQL_NOTES=0 */;- Table structure for table adminlist-DROP TABLE IF EXISTS adminlist;/*!40101 SET saved_cs_client = character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE adminlist ( id int(11) NOT NULL, adminname varchar(20) NOT NULL, adminpass varchar(20) NOT NULL, PRIMARY KEY (id) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = saved_cs_client */;- Dumping data for table adminlist-LOCK TABLES adminlist WRITE;/*!40000 ALTER TABLE adminlist DISABLE KEYS */;/*!40000 ALTER TABLE adminlist ENABLE KEYS */;UNLOCK TABLES;- Table structure for table orderlist-DROP TABLE IF EXISTS orderlist;/*!40101 SET saved_cs_client = character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE orderlist ( id varchar(20) NOT NULL, userid int(11) NOT NULL, status int(11) NOT NULL, subtime datetime NOT NULL, payway varchar(20) NOT NULL, tranway varchar(20) NOT NULL, address varchar(50) NOT NULL, PRIMARY KEY (id), KEY orderlist_ibfk_1 (userid), CONSTRAINT orderlist_ibfk_1 FOREIGN KEY (userid) REFERENCES user (userid) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = saved_cs_client */;- Dumping data for table orderlist-LOCK TABLES orderlist WRITE;/*!40000 ALTER TABLE orderlist DISABLE KEYS */;/*!40000 ALTER TABLE orderlist ENABLE KEYS */;UNLOCK TABLES;- Table structure for table productlist-DROP TABLE IF EXISTS productlist;/*!40101 SET saved_cs_client = character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE productlist ( pid varchar(10) NOT NULL, pname varchar(30) NOT NULL, pcomp varchar(30) NOT NULL, madew varchar(20) NOT NULL, madedate date NOT NULL, rprice float DEFAULT NULL, cprice float DEFAULT NULL, count int(11) DEFAULT NULL, description varchar(100) DEFAULT NULL, PRIMARY KEY (pid) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = saved_cs_client */;- Dumping data for table productlist-LOCK TABLES productlist WRITE;/*!40000 ALTER TABLE productlist DISABLE KEYS */;INSERT INTO productlist VALUES (34543,fdg,rttggf,hdgf,2013-01-16,435,435,56,fdgdsg),(3847,sdfsdf,dsfs,dsds,2001-01-03,34,12,34,fdgtryrth);/*!40000 ALTER TABLE productlist ENABLE KEYS */;UNLOCK TABLES;- Table structure for table user-DROP TABLE IF EXISTS user;/*!40101 SET saved_cs_client = character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE user ( userid int(11) NOT NULL, username varchar(20) NOT NULL, password varchar(20) NOT NULL, name varchar(20) DEFAULT NULL, phone varchar(20) DEFAULT NULL, email varchar(20) DEFAULT NULL, PRIMARY KEY (userid) ENGINE=InnoDB DEFAULT CHARSET=utf8;/*!40101 SET character_set_client = saved_cs_client */;- Dumping data for table user-LOCK TABLES user WRITE;/*!40000 ALTER TABLE user DISABLE KEYS */;INSERT INTO user VALUES (1,fisher,123,fisher,dfew,fwe);/*!40000 ALTER TABLE user ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;/*!4010