College of Computer Science and Information
Course Design Report
Course Name: Introduction to Databases
Specialty: Networking
Class: ====
No.: =====
Name: Yan Juan
Title: Online Book Buying System
Instructor: Xiao Shufen
June 2011
This is the first time that I have tried to design an online book buying system for my students.
Title: Online Book Buying System
Instructor: Xiao Shufen
June 2011
Table of Contents
I. Background Sources of Course Design 3
II. Survey and Prospect of Online Book Buying System 4
III. Design Ideas of Online Book Buying 4
1. Workflow of Frontend System 5
2, background system workflow 6
Four, the contents of the online bookstore work process 6
V, database design 7
1, data items 7
2, data structure 8
3, the design of relational schema 8
4, the design of the view 9
Fixth, the online book purchase E-R diagram 10
Six, the source program of the system 15
VII, the system evaluation and experience 20
I, the background of the course design source
1, in fact, write this course design written in a hurry, immediately other can be examined, this want to find a male topic to challenge themselves, and then still because of the time required, so choose a relatively easy to our lives. Close
2, with the development of society now, the network has become a large market trading platform, many people due to time needs or all aspects of the reasons for online shopping as a form of consumption, sometimes we have to spend a long time in the bookstore to look for a book, and sometimes can not be found, I remember a time in the filial piety college library to look for a book of tutorials on probability theory, spent a long long time ah, so I know it very well. So I know, I still feel that it is easier and more convenient to buy books online.
3, there are many students in the class are engaged in online shopping, I just want to use their own expertise to learn this knowledge, their own information, to do a good job of this course design.
Two, the online book system survey and prospects
People like to read books to expand their knowledge horizons, but in the actual life of the book buying process people have encountered a lot of trouble, such as book buyers, picking the book is difficult to move the book heavy, etc., so it is convenient and fast network book purchase has become a very potential way of purchasing books and consumption. In the information age, e-commerce has become an important and indispensable part of our real life, and at the same time, it has changed our life in a special way. According to the results of the survey, the main purpose of Internet users to obtain information accounted for 53.1%. At present, China's online shopping group, the vast majority of young people, most of them are stable income, high cultural level of young and middle-aged people, online consumption has increasingly become an important way of consumption in their lives, they have become the most potential future online consumers.
Three, online book design ideas
First of all, the online book system sounds like a very complicated program, because there are many, many books, there are many, many people to buy, but in fact, we can simply be divided into two modules, so that we can be well understood, online bookstores are mainly consists of the foreground members of the management module and the background of the administrator module consists of two parts.
The foreground function module is mainly used to realize the member registration, login, modify personal information, categorized view of the bibliographic information, book purchase, management of the shopping cart, checkout, view various terms of service and other functions.
The backstage management module is mainly used to realize the management of the backstage managers on the members, commodities, logistics, orders and system management and other functions.
1, the front-end system workflow
First of all, when our users log on to this site, at the beginning will appear to allow you to log on, if it is your members, you can log on directly, if you are not a member, you have to register an account.
1, when you are a member, you can view your services, such as the last time you collect what books, as well as the types of books you like, you can look at the first few times you buy the book in the case, in the case of personal information can be modified, modify passwords, etc., you can also view their own online transactions, look at their own books to buy the book situation, as well as look at the book on the case of what books, it can be returned to the cart to facilitate their own purchases, the shopping cart, and so on. You can put it back in the shopping cart to make it easier for you to buy it.
2, when you are a non-member, you have to register first, fill in their basic information, when you fill in, you are one of the members, you can also be the same to the members to find their own books, relatively speaking, more convenient.
3. There are also people who don't register, but just come in to browse the site to see if they need to buy some books.
2, background system workflow
Background system workflow is mainly used to realize the background management personnel of members, goods, logistics, orders and system management functions, he has to register members of the statistics, as well as shopping and other aspects of content management
Four, online bookstore work process
1, the administrator information, including Data items are: administrator number, administrator account, administrator password.
2, member information, including data items are: member account number, member password, member nickname, member E-mail, member level (administrator settings).
3, book information, including data items are: book number, book name, author, publisher number, date of publication, book category number, book introduction.
((1) publisher information, including data items are: publisher number, publisher name.
(2) Book category information, including data items are: book category number, book category name.)
4, book orders, including data items are: member account number, the date of the order, delivery address, delivery address zip code, name of the consignee, consignee contact information, delivery method number, total cost, book name, the volume of cases now sold.
5, shopping cart, including data items are: member account, the name of each book, the market price of each book, the price of each book site, the number of each book, the price of each book, the total price of books.
V. Database Design
1. Data items
Data items
Data item
Data item name Data type Length Alias Range of values
Membership No. Character type 15 Membership No.
Name Text type 20 Membership Name
Password Text type 20 Membership Password
Phone Character type 12 Phone number of the member
Address Text type 50 Address of the member
Commodity number Character type 15 Number of the commodity
Type Text type 10 Type of the commodity
Name Text type 20 Name of the commodity
Price Integer 6 Price of the commodity
Profile Text type 500 Profiles of the commodity
Picture Picture type Picture of the product
Cart number Character type 10 The number of the cart
Quantity of the product Integer 10 The quantity of the purchased product
Order number Character type 15 The order generated when shopping
Order date Time type 10 The time of the purchase of the product
2. Data structure
System Requirements Data Structure
Data Structure Name Meaning Description Composition
Members Record the basic information of members Member number, name, password, phone number, address
Merchandise Record the information of the merchandise provided by the seller Merchandise number, type, name, price, brief description, picture
Ordering Record the information of member's purchasing Member number, merchandise number, order number, order date
Shopping cart Record the information of member's purchasing Member number, merchandise number, order number, order date<
Shopping Cart Store the products that members need to buy Member number, product number, shopping cart number, number of products
3. Relational Pattern Design
Members
Data Item Name Data Type Length Alias Whether Null Primary or Foreign Key
Membership Number Character 15 Membership Number No Primary Key
Name Text 20 Name No
Password Text Type 20 Password No
Phone Character Type 12 Phone No
Address Text Type 50 Address No
Goods
Data Item Name Data Type Length Alias Whether Null Primary Foreign Key
Goods Number Character Type 15 Goods Number No Primary Key
Type Character Type 15 Type No
Name Character 20 Name No
Price Integer 10 Price No
Profile Text 500 Profile
Picture Image 100 Picture
Ordering
Data Item Name Data Type Length Alias Whether Null Primary or Foreign
Membership Number Character 15 Membership No Foreign Key Primary Key
Commodity number Character type 10 Commodity number No Foreign key
Order number Character type 10 Order number No
Order date Date type 10 Order date No
Shopping cart
Data item name Data type Length Alias Whether null Primary or foreign key
Membership number Character type 15 Membership number No Primary key
Commodity number Character type 15 Commodity number No
Cart number Character type 15 Cart number No
Commodity quantity Integer 6 Commodity quantity No
4. Design of view
Search commodity view
Data item name Data type Length Alias Whether null
Name Character type 10 Name No
Type Character 10 Type No
Price Integer 10 Price No
Synopsis Text Type 4 Synopsis No
Six, Online Book Buying E-R Diagram
No Yes
Online Bookstore System Business Process:
Online Bookstore Frontend Management Functional Structure Diagram:
Six, System's Source Program
ackage cart;
import java.util.Vector;
public class Cart {
Vector v = new Vector();
String act = null;
String item = null;
private void addItem(String id) {
v.addElement(id);
}
private void removeItem(String id) {
v. removeElement(id);
}
public void setItem(String id) {
item = id;
}
public void setAct(String s) {
act = s;
}
public String[] getItems() {
String[] s = new String[v.size()];
v.copyInto(s);
return s;
}
public void processRequest() {
if (act.equals("add"))
addItem(item);
else if (act.equals("remove"))
removeItem( item);
// reset at the end of the request
reset();
}
// reset
private void reset() {
act = null;
item = null;
}
public void clearAll(){
v.removeAllElements();
}
}
Realistic page information, prompts, and other actions designed:
package spage;
import java.sql.*;
public class ShowPage
{
private String str = "";
//Display the page with the page number p (user)
public String printPage(ResultSet rs, int p, int size)
{
str = "";
//position the access cursor to the location of the first record to be displayed for the page with page number p
try {
for(int k=0;k<(p-1 )*size;k++)
rs.next();
}
catch(SQLException e) { }
for(int iPage=1; iPage<=size; iPage++) {
str += printRow(rs,iPage,p);
try {
if(!rs.next()) break;
}
catch(Exception e) { }
}
return str;
}
// Display a single row (user)
public String printRow( ResultSet rs ,int i,int p)
{
String temp = "";
try {
int id=rs.getInt( "userid");
temp+="<tr align='center' bgcolor='#FFFAF7'>";
temp+="<td><a href='javaScript:seeUser("+id+")' & gt; "+rs.getString("name")+"</a></td>";
temp+="<td> "+rs.getString("sex")+"</td>";
temp+="<td > "+rs.getString("phone")+"</td>";
temp+="<td> "+rs.getString("address")+"</td>";
temp += "<td>. <a href='updateuser.jsp?updateid="+id+"'>modify</a></td>";
temp += "<td><a href='dealdeleteuser.jsp?delid = "+id+"'>delete</a></td>";
temp += "</tr>";
}
catch(SQLException e) { }
return temp;
}
// Display the page with page number p (book)
public String bookPage(ResultSet rs, int p, int size,boolean f)
{
str = "";
// Locate the access cursor to the page with page number p to be be displayed
try {
for(int k=0;k<(p-1)*size;k++)
rs.next();
}
catch(SQLException e) { }
for(int iPage=1; iPage<=size; iPage++) {
str += bookRow(rs,iPage,p,f);
try {
if(!rs.next()) break;
}
catch( Exception e) { }
}
return str;
}
//Display a single row (book)
public String bookRow( ResultSet rs ,int i,int p,boolean f)
{
if(!rs.next()) break;
catch(! p> {
String temp = "";
try {
int id=rs.getInt("bookid");
temp+="<tr align='center'>";
temp+="<td& gt;<a href='detail.jsp?detailid="+id+"'> "+rs.getString("bookname")+"</a></td>";
temp+="<td> "+rs. getString("author")+"</td>";
temp+="<td> "+rs.getString("pubhouse")+"</td>";
temp+="<td> "+rs. getString("price")+"</td>";
if(f)
{
temp+="<td> "+rs.getString("salenum")+"</td>";
temp+= "<td><a href='updatebook.jsp?updateid="+id+"'>modify</a></td>";
temp+="<td><a href=' dealdeletebook.jsp?delid="+id+"'>delete</a></td>";
}
else
temp+="<td><a href='dealcart.jsp? dealid="+id+"&act=add'>add to cart</a></td>";
temp += "</tr>";
}
catch(SQLException e) { }
return temp;
}
public String orderPage(ResultSet rs, int p, int size,boolean f)
{
str = "";< /p>
// Position the access cursor to the location of the first record to be displayed on the page with page number p
try {
for(int k=0;k<(p-1)*size;k++)
rs.next();
}
catch( SQLException e) { }
for(int iPage=1; iPage<=size; iPage++) {
str += orderRow(rs,iPage,p,f);
try {
if(!rs.next()) ResultSet rs ,int i,int p,boolean f)
{
String temp = "";
try {
String orderid=rs.getString("orderid");
temp+="" <tr align='center'>";
temp+="<td><a href='detailorder.jsp?detailid="+orderid+"'> "+orderid+"</a></td >";
temp+="<td> "+(rs.getString("orderdate")).substring(0,10)+"</td>";
temp+="<td> "+rs.getString(" orderstate")+"</td>";
if(f)
{
temp += "<td> <a href='javaScript:seeUser("+rs.getString("userid")+")'& gt; "+rs.getString("username")+"</a></td>";
temp += "<td><a href='dealdeleteorder.jsp?delid="+orderid+"'> ;delete</a></td>";
}
temp+="</tr>";
}
catch(SQLException e) { }
return temp;
}
Seven, the system evaluation and experience
1, to understand a lot of knowledge about the online book purchase program, to write this course design, I have read about the introduction of online book purchase, I found that I do not know whether this design is too simple or what happened, the Internet appeared a lot of this kind of version, there are updated, maybe we are not yet a very good understanding of the program of database design.
2, to write the database E-R diagram, found that it is difficult to draw ah, but also to connect the line segments to connect, think in the drawing of the above spent a lot of time
3, must first understand the data situation, to be familiar with the basic operation of the online book purchase, in the beginning of the study, it is best to go to try the online book purchase, I went to click on my own personal online book purchase network, and then only to start writing! The course design.