摘 要
伴随着计算机技术在各行各业日益广泛和深入的应用，网络的概念早已深入人心。网络在各行各业的发展战略中占据了重要的位置，成为商家不可分割的部分。商品的宣传已不只局限于电视与报纸，网络已成为商家展示自己的另一个舞台。商家建立网站，将商家各方面的宣传与服务展现于网络中，通过网络更可实现如网上购物、信息查寻等功能，这些在改变我们原有经营方式与经营理念的同时，也为商家带来了更高的效益。因此，对于商家来说，拥有一个属于自己的网站是至关重要的[1]。
本论文研究了一种网上购物系统。其开发主要包括后台数据库的建立、前台页面的Web设计。系统使用Microsoft公司以C#为核心语言的ASP.NET开发工具，再结合SQL建立数据连接关系。利用其提供的各种组件，在短时间内建立数据库，对数据库进行分析与建立ASP.NET页面，不断改进，直到功能基本实现的可行系统[2]。
本系统融入日常业务的各个环节，使得管理更加规范，同时也能够更好的为顾客服务，该系统大大提高了工作效率，为公司带来了更好的社会效益和经济效益。
关键字 信息系统开发/浏览器,服务器/动态网站/SQL
ABSTRACT
Accompanied by computer technology in all walks of life increasingly widespread and in-depth applications, the concept of networks has win support among the people. Network in all walks of life development strategy occupies an important position, become an integral part of business. The propaganda of goods has not only confined to television and newspapers, the network has become the business to display self another stage. Merchants to set up a website, will promote all aspects of business and services displayed on the network, through the network can be realized as more online shopping, information search functions, these changes in our original mode of operation and management concepts at the same time, but also for business resulting in higher efficiency. Therefore, the businessman, owning a website belonging to self is crucial.
This paper studies a kind of online shopping system. Its development mainly includes the backstage database the establishment, downstage page design Web. System uses Microsoft company to C # as the core ASP.NET language development tools, combined with Access to establish data connection. The use of its various components, in a short period of time to establish the database, the database analysis and the establishment of ASP.NET page, continue to improve, until the basic function of the realization of the feasible system.
This system integrated into the daily business of each link, make the management more standardized, but also to better service to customers, the system greatly improves the work efficiency, in order to bring better social benefit and economic benefit. The system uses ASP.NET and Access as the developing tool, the extensibility of.
Here, I sincerely thank for my graduation design for patient guidance teacher Kang Guolei, as well as on my thesis to help teachers and students.
Keywords： Information system，Browser / server，dynamic website,SQL
摘 要 1
ABSTRACT 2
第1章 绪论 3
1.1 Internet简介 3
1.2 电力网站简介 4
1.2.1 电力网站功能 4
1.2.2 电力网站优势与劣势 5
1.2.3 电力网站开发特色 5
第2章 电力网站整体需求分析 7
2.1 电力网站的安全需求分析 7
2.1.1物理安全与防火墙设置 7
2.1.2 身份认证与访问控制 7
2.1.3 SQL注入攻击的防范 8
2.2 电力网站数据库需求分析 9
2.3 电力网站用户需求分析 10
2.4 电力网站开发与运行环境需求分析 11
2.4.1 Microsoft Visual studio 2005 11
2.4.2 SQL Server 2005 12
第3章 总体设计 15
3.1 功能需求 15
3.1.1叙述功能 15
3.1.2 电力管理系统主要包括 15
3.2 数据库设计ER-图 16
3.3 数据库列表 17
3.3.1登陆表 17
3.3.2 村子信息表 18
3.3.2 户主信息表 18
3.3.3 员工业务表 18
3.3.4 员工信息表 19
第4章 电力管理系统实现 20
4.1 MVC结构 20
4.1.1 MVC图 20
4.1.2 系统类关系图 21
4.2 登录功能实现 21
4.2.1 登录界面 21
4.2.2 登陆功能代码 22
4.3 用户信息维护 29
4.4 村子信息维护窗体 30
4.5 户主查询 30
4.6户主信息维护 31
4.7收费 31
第5章结果测试及部署 33
5.1 结果测试 33
5.1.1 单元测试 33
5.1.2 黑盒测试 33
5.1.3 白盒测试 34
5.1.4 模块测试 34
5.1.5 集成测试 35
5.1.6 系统测试与维护 36
5.2. 部署 36
5.2.1 硬件配置 37
5.2.2软件配置 37
结束语 38
致 谢 39
参考文献 40
附 录 41
