网上古玩商店系统的设计与实现(毕业论文说明书12000字,程序代码,SQL2005数据库)
摘要
网络在各行各业的发展战略中占据了重要的位置，成为商家不可分割的部分。商品的宣传已不只局限于电视与报纸，网络已成为商家展示自己的另一个舞台。商家建立网站，将商家各方面的宣传与服务展现于网络中，通过网络更可实现如网上购物、信息查寻等功能，这些在改变我们原有经营方式与经营理念的同时，也为商家带来了更高的效益。因此，对于商家来说，拥有一个属于自己的网站是至关重要的。
本论文研究了一种基于数据关联规则的网上古玩商店系统。其开发主要包括后台数据库的建立、后台管理以及前台页面的Web设计。系统使用Microsoft公司以C#为核心语言的ASP.NET开发工具，利用微软提供的IIS 6.0建立运行环境，再结合SQL Server 2000建立数据连接关系。利用其提供的各种组件，在短时间内建立数据库，对数据库进行分析与建立ASP.NET页面，不断改进，直到功能基本实现的可行系统。
本系统主要运用了系统开发生命周期法(System Development Life Cycle 简称SDLC)和结构化方法(Structured Approach)来阐述该系统的开发过程，将计算机作为管理决策的支持手段，融入日常业务的各个环节，使得管理更加规范，同时也能够更好的为顾客服务，该系统大大提高了工作效率，能为公司带来更好的社会效益和经济效益。本系统采用ASP.NET和SQL Server 2000为开发工具，具有扩展性。
在此，我真诚的感谢对我的毕业设计进行耐心指导的 老师，以及对我的论文完成给予帮助的各位老师和同学。
关键字：软件生命周期法；信息系统开发；浏览器/服务器； 动态网站
ABSTRACT
Follow the technology of the computer in the enterprise and deep application day by day of all trades and professions, the concept internet has been deeply taken up people’s heart. Today , the internet takes an very important part in the development tactics of all trades and professions, became a part of an company which can not be partition off. The merchandise has not only limited in TV set and newspaper. The internet has became another stage which company can display themselves. Company set up web site, and make propaganda and service of all aspects of company, display on the internet. Though internet we can achieve buying products on the internet, searching message and so on. Those have changed old way of management and idea of management, meanwhile those also bring more yield for company. So, for the business company, have a web site which is belong to themselves is very important.
I studied one kind of system of shopping online based on related-data rule. Its developments mainly include database setting-up, back-stage management and web design of the foreground pages. The system uses ASP.NET developing instrument, which taking C# as key language of Microsoft Company, exploit IIS 5.0 offered by Microsoft as running environment, and then combine with SQL server 2000 to establish the database. At first, utilize its various kinds of packages offered to set up the database within short time. Then, I analyzed database and made pages with ASP.NET, improved constantly, until basic functions of the system were realized.
The system mainly utilize the Structrued Approach of System Development Life Cycle method to expound the performance history of Department Store MIS,computer as important administrative decision supporter.Which will make the business technological process more standard and rational,raise working effiencicy,and bring us greater management and economic benefit.The system adopts ASP.NET and SQL Server 2000 as the development tool,so it is extensible.
Thanks to my tutor,Teacher wang bao qi.He gives me earnest direct to this paper,as well as other teachers and my fellow students.
key words: Software life cycle method; Information System Developing; B/S ; Dynamic website
系统采用了敏捷开发的思想，对整个系统分成了3个大模块：前台交易模块、数据库及持久层的设计、后台管理模块。各个模块又进行了一步的细分，如前台交易模块又分为查询、拍卖等；数据库采用了sql server；使得系统具有易用性、个性化、跨平台等特点；同时又保证交易数据的安全、稳定、快速和完整；使其运行得高速、安全、稳定。
目录
1引言 4
1.1研究背景 4
1.2目前网上购物在国内外发展现状 4
1.3 本文主要研究目的和内容 5
1.3.1研究的目的和意义 5
1.3.2 本文研究内容 6
2 .NET及其技术简介 7
2.1.NET技术简介 7
2.2 ASP.NET介绍 8
2.3 .NET的数据库访问 9
2.4 可行性分析 10
2.5 系统运行环境 11
3 系统概要设计 12
3.1 总体功能 12
3.2 E-R图 13
4 系统详细设计 13
4.1 后台数据库设计 13
4.1.1 SQL SERVER 2000 介绍 13
4.1.2 数据库表结构 14
4.2 处理流程设计 17
4.2.1 系统操作流程 17
4.2.2 数据增加流程 17
4.2.3 数据修改流程 18
4.3.4 数据删除流程 19
4.3 系统模块设计 20
4.3.1 首页 20
4.3.2 注册会员 22
4.3.3 后台登陆 24
4.3.4 后台订单管理 25
5 系统调试与测试 27
5.1 程序调试 27
5.2 程序的测试 27
5.2.1 测试的重要性及目的 27
5.2.2 测试的步骤 29
5.2.3 测试的主要内容 29
6 结论 30
6.1 系统评价 30
6.2 安全性问题 31
致谢 31
参考文献 32
|
