制作一个简单的电子商务网站.doc

姓名：黄雪花 学号： 200610401143电子商务大作业 第 25 页 共 25 页作 业 要 求制作一个简单的电子商务网站，具有以下功能： 1) 能进行用户注册、登录。用户信息保存在数据库中。 2) 能对商品信息进行维护：增加、删除、修改。商品信息保存在数据库中。 3) 实现简单的购物车功能，能对所选择的商品进行列表显示，并对价格进行统计。 纸质报告要求： 1) 实现过程说明 2) 数据库设计说明 3) 运行效果 4) 主要源代码 一、创建用户注册、登录。用户信息保存在数据库中 1) 创建数据库表 在 MySQL 中创建一个名为homeworks 的数据库，并在该数据库中创建一张名为User的表格。 字段名 数据类型 是否主键 字段名 数据类型 是否主键 LoginName VARCHAR(20) Yes Password VARCHAR(20) No FirstName VARCHAR(45) No LastName VARCHAR(45) No EmailAddress VARCHAR(45) No 2) 安装所需的第三方软件包 在 testapp/WEB-INF 新建lib 目录，并将以下需要的第三方软件包拷贝到lib 目录下：jstl.jar、standard.jar、mysql-connector-java-5.0.7-bin.jar。 3) 配置 JDBC 数据源 web.xml页面类容如下： javax.servlet.jsp.jstl.sql.dataSource jdbc:mysql:/localhost:3306/homeworks?user=root&password=root,com.mysql.jdbc.Driver Servlet and JSP Examples. Servlet and JSP Examples Test Test A test Servlet test.ServletTest Test /Test 4) 建立和信息录入相关的 JSP 页面 Index.jsp：网站首页 Search in User Database Welcome to my website home page if you are a member please click login if not then click on the registration register.jsp：用于注册用户信息的录入。 User Entry Form Registered User Interface Please enter information about a user below: Login Name: $fn:escapeXml(loginNameError) Password: $fn:escapeXml(passwordError) First Name: $fn:escapeXml(firstNameError) Last Name: $fn:escapeXml(lastNameError) Email Address: $fn:escapeXml(emailAddressError) (Use format ) validate.jsp：用于验证录入的用户信息 程序代码如下： store.jsp：用于将录入的信息保存到数据库中。 程序代码如下： SELECT * FROM User WHERE LoginName = ? INSERT INTO User (LoginName, Password, FirstName, LastName, EmailAddress) VALUES(?, ?, ?, ?, ?) UPDATE User SET Password = ?, FirstName = ?, LastName = ?, EmailAddress = ?, WHERE LoginName = ? SELECT * FROM User WHERE LoginName = ? confirmation.jsp：用于显示已保存到数据的信息。 程序代码如下： User Info Stored This is the information stored in the homeworks database: $fn:escapeXml(column.key): $fn:escapeXml(column.value) 二、用户登陆 login.jsp注册用户登陆界面 Search in User Database Registered users Landing Interface login Name: Password: Find.jsp在数据库中检索登陆界面所录入的信息 SELECT loginName,Password FROM User WHERE loginName LIKE ? AND Password LIKE ? ORDER BY loginName List.jsp显示用户登陆界面 Result Sorry, no user were found. Welcome to the user: $fn:escapeXml(row.loginName) Next You could management books information 三、商品信息 在数据库homeworks中建立表books其内容如下： 字段名 数据类型 是否主键 Name VARCHAR(45) Yes Price VARCHAR(20) No Bookindex 书籍管理首页 Search in User Database Management Books Information IF you want to add books infomation and updata please check AddBook IF you want to Management books infomation please check Management Addbooks.jsp 添加书籍与修改页面信息： User Entry Form Please add or updata book informations: Name: $fn:escapeXml(NameError) Price: $fn:escapeXml(PriceError) validate1.jsp用于验证录入的书籍信息 show.jsp将录入的书籍信息保存道数据库中 SELECT * FROM books WHERE Name = ? INSERT INTO books (Name, Price) VALUES(?, ?) UPDATE books SET Price = ? WHERE Name = ? SELECT * FROM books WHERE Name = ? Success.jsp显示书籍信息添加成功 Search in User Database Now time is: Add or updata the success of books information search.jsp查找数据库中已保存的信息 SELECT * FROM books WHERE Name LIKE ? AND Price LIKE ? ORDER BY Name List1.jsp：用于显示查询到的所有数据。 Result Sorry, no books were found. The following homeworks were found: Name Price Delete Detail $fn:escapeXml(row.Name) $fn:escapeXml(row.Price) detail delete.jsp删除数据库中保存的数据 DELETE FROM books WHERE Name = ? 四、购物车 catalog.jsp 文件用于显示所有可供购买商品的列表、购物车内当前的物品和价格信息 Product Catalog Product Catalog Please select a book from our catalog to read more about it and decide if you like to purchase a copy: $fn:escapeXml() Your shopping cart contains the following items: $fn:escapeXml() $ Total: $ product.jsp 用于显示当前商品的详细信息，并包将该商品加入购物车的链接 product.jsp产品信息 Product Description $fn:escapeXml() $fn:escapeXml(product.descr) Add this book to the shopping cart 购物车中相关的JVAV程序 ProductBean.java 用于描述商品信息 package test; import java.io.*; /* * This class represents a product. It holds information about the * products name, description and price. All setter methods have * package scope, since they are only used by the the CatalogBean. * * author Hans Bergsten, Gefion software * version 2.0 */ public class ProductBean implements Serializable private String id; private String name; private String descr; private float price; /* * Returns the product id. * * return the product id */ public String getId() return id; /* * Returns the product name. * * return the product name */ public String getName() return name; /* * Returns the product description. * * return the product description */ public String getDescr() return descr; /* * Returns the product price. * * return the product price */ public float getPrice() return price; /* * Sets the product id. * * param id the product id */ void setId(String id) this.id = id; /* * Sets the product name. * * param name the product name */ void setName(String name) = name; /* * Sets the product description. * * param descr the pro