本科学生毕业论文
论文题目：学 院：年 级：专 业：姓 名：学 号：指导教师： 图书借阅管理系统的设计与实现
计算机学院 2008级
计算机科学与技术 周经辉 20084001 刘勇
2012 年5月12日
摘要
随着时代的发展，计算机的硬件环境也日益成熟，作为信息载体的计算机在社会各个领域的应用已经越来越广，并逐渐取代传统的手工操作，通过计算机进行信息处理不仅能够提高信息处理的效率，而且在经济开销方面也是非常乐观的，因此信息处理已成为当今社会必不可缺的处理方式。于是信息处理开始流行起来，以焕然一新的事务处理理念深受各界青睐。而本图书借阅管理系统就是信息处理的一种应用。
本系统的设计是在Visual Studio 2005平台上运用.NET技术和SQL SERVER数据库访问来实现的。针对当前图书管理的发展情况，论文首先介绍了图书借阅管理系统的有关背景与意义，并对本系统做了简单的介绍，同时分析了系统中所用到的B/S、C/S结构框架的特点。接着对系统的可行性进行了分析，然后对系统的需求进行了明确的规划。最后对系统的主要数据库、界面、应用程序的设计与实现作了较为详细的讲解。
本文分析了系统中用到的开发框架和SQL SERVER的特点，并对系统的主要页界面和数据库进行了详细的设计。实现的主要功能有：图书管理，用户管理，借阅管理、综合管理等等。
关键词
图书管理；图书借阅；.NET；SQL SERVER
I
Abstract
With the development of The Times, the computer hardware environment also increasingly mature, as information carrier in all areas of society computer application has been more and more widely, and gradually replace the traditional manual operation, through the computer to carry on the information processing can not only improve the efficiency of information processing, and in economic costs also very optimistic, and therefore the information processing in today's society has become indispensable to the treatment. So the information processing began to pop up to all new transaction processing idea deeply from all walks of life to favor. But this library management system is an application of the information processing.
This system is designed in the Visual Studio 2005 platform using the.net technology and SQL SERVER database access to fulfill. In view of the current development of library management, this paper first introduces the library management system of the relevant background and significance, and do this system simply introduces and analyses the system used in the B/S, C/S structure characteristics of the frame. Then analysis the feasibility of system, and making a clear plan for it. In the end, making a more detailed explanation for system's main database, interface, the design and realization of the application.
This paper analyzes the system used in the development framework and SQL SERVER, and the characteristic of the system's main page interface and database design in detail. Of the realization of the main functions are: the books management, user management, lending management and comprehensive management and so on.
Key words
The books management; Books lending; .NET; SQL SERVER
II
目录
摘要 ............................................................................................................................................ I Abstract ................................................................................................................................... II
前言 ........................................................................................................................................... 1 第一章 绪论 ............................................................................................................................. 2
1.1 课题背景 .................................................................................................................... 2 1.2 课题意义及目的 ........................................................................................................ 2 1.3 图书借阅管理系统的简介 ........................................................................................ 3 1.4 系统设计思想 ............................................................................................................ 3
1.4.1 总体设计思想 ................................................................................................. 3 1.4.2 详细设计思想 ................................................................................................. 3 1.5 本章小结 ..................................................................................................................... 4 第二章 可行性分析 ................................................................................................................. 5
2.1 技术可行性 ................................................................................................................ 5 2.2 运行可行性 ................................................................................................................ 5 2.3 经济可行性 ................................................................................................................ 5 2.4 本章小结 .................................................................................................................... 6 第三章 需求分析 ..................................................................................................................... 7
3.1图书借阅管理系统需求分析 ..................................................................................... 7
3.1.1图书借阅管理系统功能需求 .......................................................................... 7 3.1.2图书借阅管理系统功能划分 .......................................................................... 8 3.1.3功能描述 .......................................................................................................... 9 3.2系统数据分析与数据描述 ....................................................................................... 10 3.3外部接口需求 ........................................................................................................... 10
3.3.1用户界面 ........................................................................................................ 10 3.3.2硬件接口 ........................................................................................................ 10 3.3.3软件接口 ........................................................................................................ 11
3.3.4故障处理 ........................................................................................................ 11 3.4性能需求与软件属性需求 ....................................................................................... 11 3.5本章小结 ................................................................................................................... 11 第四章 系统总体设计 ........................................................................................................... 12
4.1图书借阅管理系统开发架构简介 ........................................................................... 12
4.1.1 B/S架构简介 ................................................................................................ 12 4.1.2 C/S架构简介 ................................................................................................ 12 4.2 系统模块总体设计 .................................................................................................. 12 4.3 数据库设计 .............................................................................................................. 14 4.4 本章小结 .................................................................................................................. 16 第五章 详细设计与实现 ....................................................................................................... 17
5.1 运行平台设置 .......................................................................................................... 17 5.2 数据库的连接 .......................................................................................................... 17 5.3 系统主界面设计 ...................................................................................................... 18 5.4 后台功能模块设计与实现 ...................................................................................... 20
5.4.1 登录模块 ....................................................................................................... 20 5.4.2 图书管理模块 ............................................................................................... 20 5.4.3 借还管理模块 ............................................................................................... 24 5.4.4 人员管理模块 ............................................................................................... 27 5.4.5 综合管理模块 ............................................................................................... 29 5.5 本章小结 .................................................................................................................. 30 第六章 系统测试 ................................................................................................................... 31
6.1 软件测试 .................................................................................................................. 31 6.2 本系统测试 .............................................................................................................. 31
6.2.1 高级管理员权限测试 ................................................................................... 32 6.2.2 普通管理员权限测试 ................................................................................... 32 6.3 本章小结 .................................................................................................................. 33 结论 ......................................................................................................................................... 34 参考文献 ................................................................................................................................. 35