Download address: download.csdn.net/download/qq…
Project introduction
Java online book mall, project based on MVC design pattern, using BS structure source code + documents + PPT
System specifications
- Topic selection
The topic is to design the book e-commerce management system, and the data includes books and members. The book data includes book number, book name, category, chief editor, publisher, price, discount; Member data includes member account number, member name, address, telephone, email, grade. It mainly realizes the functions of browsing books, putting them into shopping cart, placing orders and evaluating. It is applied to the general process of customers buying books online.
- Demand analysis
2.1 Service description of the database system (including users, main functions, system boundaries or limitations)
Users: Users include regular tourists and members. Regular tourists can register as members. Tourists can only browse, while members can add to shopping cart, buy books and evaluate.
Main functions:
① Registration function: ordinary tourists can register as members, so as to place orders and other functions.
② Shopping cart function: Members can add the books they are interested in to the shopping cart during browsing, and the shopping cart will record the information of the corresponding books. After that, they can place orders in the shopping cart.
③ Ordering function: members can place orders directly to their favorite books in the process of browsing books, or add books to the shopping cart first, and then place orders from the shopping cart interface.
④ Evaluation function: members can evaluate the order after placing an order.
System boundary or limitation: members can place orders directly, place orders by adding to shopping cart, and evaluate operations.
2.2 Main Business Logic (or Rules)
Ordinary tourists first register as members, then browse the books they are interested in, place an order directly or place an order after adding to the shopping cart, and finally members evaluate the order.
2.3 Data Dictionary
Including: data item, data structure, data flow, data storage, procedures
Data items:
1. Data item name: userID
Description: Id for identifying a member
Aliases: Member account
Type: nvachar
Location: Membership information
- Data item name: username
Description: Identifies the name of the member
Alias: Member name
Type: nvachar
Location: Membership information
3. Data item name: address
Description of the data item: address of the member
Alias: Address
Type: nvachar
Location: Membership information
4. Data item name: phone
Description: Phone number of a member
Aliases: telephone
Type: nvachar
Location: Membership information
5. Data item name: Email
Description: Email address of a member
Aliases: mailbox
Type: nvachar
Location: Membership information
6. Data item name: level
Meaning of the data item: Membership level
Aliases: Levels
Type: nvachar
Location: Membership information
7. Data item name: ISBN
Description of the data item: Book NUMBER
Alias: Book number
Type: nvachar
Location: shopping cart information, book information, order information
8. Data item name: bookname
Description: Indicates the name of the book
Alias: book name
Type: nvachar
Location: shopping cart information, book information, order information
9. Name of data item: quantity
Description: Number of books
Aliases: quantity
Types: int
Location: shopping cart information, order information
10. Data item name: bookprice
Description: Unit price of a book
Alias: Unit price
Type: money
Location: shopping cart information, book information, order information
11. Data item name: TotalPrice
Description of the data item: Total book price
Alias: Total price
Type: money
Location: shopping cart information, order information
12. Data item name: category
Description: Category of the book
Aliases: categories
Type: nvachar
Location: Book information
13. Data item name: author
Description: Chief editor of the book
Alias: Chief Editor
Type: nvachar
Location: Book information
13. Data item name: press
Description of the data item: Publisher of the book
Alias: Publishing House
Type: nvachar
Location: Book information
14. Data item name: discount
Description of the data item: Discount for book purchase
Alias: Discount
Type: nvachar
Location: Book information
15, Data item name: Ordered
Description of the data item: Indicates the order number
Alias: Order number
Types: int
Location: Order information
16, data item name: orderDate
Description of the data item: Order date
Aliases: dates
Type: datetime
Location: Order information
Data structure:
1, data structure name: ORDER
Meaning: Members can place orders directly or by adding to shopping cart
Data composition: Order number + book name + quantity + unit price + total price + date
2, data structure name: BOOK
Description: Information about books
Data composition: book number + book name + category + chief editor + publishing house + price + discount
3. Data structure name: SHOPPING
Description: Members add to shopping cart
Data composition: book number + book name + quantity + unit price + total price
4. Data structure name: USER
Description: Member information
Data composition: member account number + member name + address + phone number + email address + level
The data flow:
1. Data flow name: Place orders directly
Instructions: Members order directly
Source of data stream: Membership
Data flow direction: order management system
Data composition: Order number + book name + quantity + unit price + total price + date
2. Data flow name: shopping cart order
Note: Members place orders by adding to shopping cart
Source of data flow: Shopping cart
Data flow direction: order management system
Data composition: book number + book name + quantity + unit price + total price
3. Data flow name: Registered member
Note: Ordinary visitors register to become members
Source of data stream: Tourists
Data flow direction: membership management system
Data composition: member account number + member name + address + phone number + email address + level
4. Data flow name: Browse books
Description: General visitors or members browse book information
Source of data stream: tourists or members
Data flow to: library management system
Data composition: book number + book name + category + chief editor + publishing house + price + discount
Applicable scenarios:
Graduation thesis, course design, company project reference
Run a screenshot
Focus on [program generation to do source sharing] public number to get more free source code!!
