網(wǎng)上購(gòu)物系統(tǒng)-數(shù)據(jù)庫(kù)設(shè)計(jì)

1、.課程設(shè)計(jì)課程名稱_數(shù)據(jù)庫(kù)課程設(shè)計(jì)_題目名稱_網(wǎng)上購(gòu)物系統(tǒng)_學(xué)生學(xué)院_計(jì)算機(jī)學(xué)院_專業(yè)班級(jí)_ _學(xué) 號(hào)_學(xué)生姓名_ _指導(dǎo)教師_左亞堯 _2012年 1 月 16 日1.requirement analysis1.1. System name系統(tǒng)名稱為網(wǎng)上購(gòu)物系統(tǒng)1.2. Task summary結(jié)合使用jsp和javabean，編寫一個(gè)在線商務(wù)購(gòu)物系統(tǒng)。這個(gè)系統(tǒng)提供了一個(gè)客戶和企業(yè)在線溝通的平臺(tái)。用戶可以瀏覽企業(yè)的產(chǎn)品和信息；通過(guò)注冊(cè)成網(wǎng)站的用戶，可以購(gòu)買產(chǎn)品；并根據(jù)自己的需求添加刪除和修改訂單中商品的數(shù)量。管理者可以登錄網(wǎng)站后臺(tái)，管理商品信息，管理用戶信息和處理訂單。1.3. System

2、 functions這個(gè)系統(tǒng)具有前臺(tái)和后臺(tái)兩部分功能。前臺(tái)為客戶提供了注冊(cè)登錄，查看商品，購(gòu)買商品，處理訂單的服務(wù)；后臺(tái)可以添加商品，管理訂單和管理用戶。1.4. Function details1. 提供注冊(cè)登錄功能，使得用戶可以通過(guò)注冊(cè)登錄獲得購(gòu)買商品的權(quán)限。2. 提供商品列表和某一商品展示的功能3.為登錄用戶提供購(gòu)買功能4.管理員登錄后，可以管理用戶，管理訂單和管理商品。2. overall design2.1. UML use case use case2.2. the basic bodelOnlineShoppinguseradminproductlistregister/logi

3、nbuy 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 Diagram1orderlistownsnadminlistproductlistuseridusernamepassworduserphonem

4、ailiduseridpaywayidadminnameadminpasspidpnamepcomp4. 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本系統(tǒng)經(jīng)過(guò)測(cè)試，能完成在網(wǎng)上購(gòu)物系統(tǒng)的基本功能。設(shè)計(jì)過(guò)程中，遇到很多的問(wèn)題，解決問(wèn)題要多看書，多想老師的教授。實(shí)驗(yàn)之后發(fā)現(xiàn)自己對(duì)數(shù)據(jù)庫(kù)的了解加深了，明白到數(shù)據(jù)庫(kù)在一個(gè)系統(tǒng)中的重要地位

5、。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=CO

6、LLATION_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_MO

7、DE=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

8、 ( 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 KEY

9、S */;/*!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) NO

10、T 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 CHARSE

11、T=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 product

12、list;/*!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 f

13、loat 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 DISABL

14、E 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

15、 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

16、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 */;INSE

17、RT 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