随着Internet上商品零售额的迅速增长，许多中小型企业开始考虑建立自己的电子商务站点，通过Internet，即使是小公司也可能接触到世界上任何地方的客户；在Internet上浏览的人会发现在线订购商品比其他任何方法都方便得多；一旦电子商务站点启动并运行起来，获取订单处理的成本与设置实体店铺的成本相比，实际上接近于零。本系统实现了一般电子商务所具备的功能，如商品浏览、用户登录注册、网上与购物、结算、后台数据库管理等，利用这些功能可以对体育用品销售信息进行较好的管理。xcy网上体育用品商城的使用者主要是客户和销售管理者，对于客户来说，实现的功能包括客户浏览体育用品（搜索查询），存放选中的商品的购物车，最后产结算；对于销售管理者来说，需要对客户的信息，体育用品的信息，以及销售的信息进行管理。

关键词：购物车；体育用品管理；订单管理；客户管理；搜索查询

Desig of XCY onlinesporting goodsstore

AbstractWith the turnover of commodity retail sales fast increasing over the Internet, urges a lot of middle and small enterprises to think the Electronic Commerce platform and founding themselves Websites. Building the Electronic Commerce website has a lot of superiorities. Such as a small company can contact with the customers whoever come from any countries. The person browsing on the Internet will discover that ordering a commodity on line is much more convenience than any other methods. Once the Electronic Commerce website works, the cost of handling order approaches zero compared with entity shop.This system has some general Electronic Commerce functions. For example, browsing commodity over the internet, user registration, On-line shopping, settlement, data management, makes use of these functions to be able to manage information of the flower.The on-line fresh flower sale system’s users mainly are the customers and sale manages. The customer’s functions include the customer browsing fresh flower (search), the commodity shopping cart which depositing selects, finally producing the order form. The sale manages’ functions including manage the information such as the customers, the flower and the sales.With the rapidgrowth of Internetonretail sales,many small and medium enterprisesbegin toconsider the establishment ofe-commerce sites,through their ownInternet,evensmall companies may alsocontactto any place in the worldfor customers;visitpeople on Internetwill findonline orderinggoodsthan any othermethods aremuch more convenient;once the electroniccommerce siteup and running,comparedto obtainorder processingcosts andset theentityshop costs,is actually close to zero.This system can realize the general e-commerce functions, such as commoditybrowsing, user login, online shopping, settlement, and the background database management, use of these functions can be a better management of sporting goods sales information.XCYonline sports mall of the main users of the customers and sales managers,for customers, realizethe function including customer browsing sports goods(search), storageof selected goods shopping cart, finally producing settlement;for sales managers, the need for customer information, sports information, and sales information management.

Key words: Sales management, shopping cart;sportsmanagement;order management;customer management;search queries

目 录

1引言11.1网上购物11.2网上购物的优点21.3基础知识31.4系统软硬件配置要求32系统特色及方案选择43系统需求分析与流程设计53.1系统功能需求分析53.2系统流程分析64数据库设计74.1 系统E-R图74.2数据库表设计85用户管理权限116系统设计与编码实现116.1用户登录与注册116.2注销146.3下订单156.4系统主界面166.5前台商品分类显示166.6系统后台登录主页176.7体育用品管理186.8 体育用品交易187性能测试与分析197.1系统测试的定义207.2系统测试的目的与意义207.3系统测试的重要性207.4系统测试的方法207.5系统运行情况217.6系统测试结果21结 论22参考文献23致 谢24声 明25