音像出租,销售管理系统设计与实现
The Design and Implement of Disc Rent Management
System
摘要
音像出租,销售管理系统是典型的信息管理系统,其开发主要包括
后台数据库的建立和维护以及前端应用程序的开发两个方面.对于前者
要求建立数据一致性和完整性强,数据安全性好的数据库.而对于后者
则要求应用程序功能完备,易使用等特点。
随着计算机技术的高速发展,人们对计算机的依赖性越来越强,特
别是用计算机开发的数据库以及数据管理系统在生活应用中表现得更
为突出,为此开发此租赁,出售系统。通过使用音像租赁,出售管理系
统,使音像租赁店的租赁管理工作系统化、规范化、自动化、简易化、
智能化,系统包括系统用户管理,音像信息管理、音像类别管理、音像
偿还管理,销售管理、客户管理,数据备份、其它设定等模块。实现了
对音像制品的添加、查找、编辑、删除以及出租,出售的基本功能,对
已出租音像制品的查询、结帐等功能,对、用户的添加、删除、查询等
基本功能。从而达到提高音像管理效率的目的。
系统界面简单实用,操作容易上手,能够实现音像出租,销售管理
的基本功能,适合中小型音像出租店铺的使用
关键词: 管理系统,数据库,模块,音像出租,销售
Abstract
Audio and video rental management system is typical of the
information management system. Front-end application
development mainly includes the creation and establishment
of the database. For the former, it is not only have powerful data
integrity and consistency but also the data security is good. For
the latter,it must have perfect functions and easily to use.
With the computer technology of rapid development, the people
of the increasing reliance on computer, In particular, the
database and data management system in the application of life
even more outstanding performance, so the lease management comes.
Through the use of audio and video rental management system, make
the works standardization, automation, simple, intelligence. The
system includes audio and video information management,
audio-video rental management, Member management, user
management, the set modules and so on. It realized the basic
functions; include additions, search, edit, delete and lease. It
improved the efficiency of the job.
System interface is simple and practical and easy to get
started, to achieve the management of audio-visual rental and
basic functions, suitable for small and medium-sized audio-video
rental shops to use.
Keywords: management system, database, module, disc rent
I
目录
第一章 引言....................................................................................................................1
1.1 管理信息系统的发展与用户需求分析 .........................................................1
1.2 开发环境简介...........................................................................................2
1.2.1 Visual Studio 2005....................................................................2
1.2.2 HTML(Hyper Text Markup Language)..........................................4
1.2.3 基于 ASP.NET 技术的系统结构模型...............................................4
1.2.4 ADO.NET 访问数据库的原理 ...................................................5
1.3 SQL server 2000 数据库简介 ......................................................................6
1.3.1 什么是数据库......................................................................................6
1.3.2 SQL Server 2000 作为数据库服务器的优点 .................................7
1.3.3 SQL Server 2000 数据库组件构架的基本组成 .............................8
第二章 总体设计..........................................................................................................9
2.1 总体模块设计
[1]
...............................................................................................9
2.2 业务流程图....................................................................................................10
2.2.1 登录模块流程....................................................................................10
2.2.2 音像信息管理模块流程 ...................................................................11
2.2.3 音像偿还管理模块............................................................................12
2.2.4 客户信息管理模块............................................................................12
2.3 数据库概念结构设计
[2]
................................................................................12
2.4 数据库逻辑结构设计
[5]
..............................................................................14
第三章 详细设计..........................................................................................................17
3.1 系统登录窗口.................................................................................................17
3.2 系统主界面....................................................................................................21
3.3 音像信息管理界面........................................................................................25
3.4 音像类别信息.................................................................................................27
3.5 音像销售界面.................................................................................................30
3.6 音像偿还管理................................................................................................32
第四章 系统测试..........................................................................................................36
4.1 软件测试的基本方法....................................................................................36
4.1.1 黑盒测试............................................................................................36
4.1.2 白盒测试............................................................................................37
4.2 本系统的黑盒测试.........................................................................................37
4.2.1 界面初始化的黑盒测试 ....................................................................37