[摘要]
本系统采用基于浏览器/服务器模式将软件分成浏览器(前台)和服务器端(后台)。前台程序采用Microsoft公司的ADO.NET技术来访问SQL SERVER数据库,后台通过编写一些存储过程来减少前台数据处理量,并进行数据存储和数据处理。本系统能对图书实行分类管理,并能按Web登录用户实行三级权限管理:读者、图书操作员员和图书管理员。
本系统分图书管理和信息查询修改两大功能模块。其中图书管理功能分为购入新书、借阅图书、归还图书、注销图书;信息查询修改则包括图书信息查询修改和登陆者信息查询修改等。
[关键词]图书管理;数据库;ASP.NET; 浏览器/服务器;存储过程;
[Abstract]
The system based on B/S is divided into browser and server. The front end access SQL SERVER database using Microsoft's ADO.NET technology, the back end store and process data from the front end through the preparation of a number of stored procedures. The system implements the classified management on books and three-tier Web Rights Management on Logged-on user; the 3 roles are reader, operator and administrator.
There are two major functional modules: library management and information inquiry and modification. Library management functions are divided into adding books ,borrowing books, returning books and writing off books; Information inquiry and modification are divided into querying and updating the information of books and users.
[Key Words] book management; database; ASP.NET;B/S; stored procedure;
目 录
任务书
摘要
Abstract
1 综述....................................................1
1.1 课题背景...........................................1
1.1.1 概述.............................................1
1.1.2 历史.............................................1
1.1.3 现状.............................................1
1.1.4 发展趋势.........................................2
1.2 课题提出...........................................2
1.3 开发工具........... ...............................2
1.4 系统文件结构.......................................3
2 需求分析 ...............................................4
2.1 系统开发目的.......................................4
2.2 系统功能要求.......................................4
2.3 系统界面要求.......................................4
2. 4 系统性能要求......................................4
3 系统总体设计.............................................5
3.1 任务概述................... ............. .........5
3.2 总体结构............... ........... ...............5
3.3 框架结构....................... ...................7
3.4 接口设计...........................................7
3.5 数据库设计................... .....................9
3.6 出错处理.................. ........................15
3.7 安全保密设计................... ...................15
3.8 维护设计...................... ....................15
4 系统详细设计及编码实现...................................16
4.1 类定义.............................................16
4.2 软件结构.............................. ............19
4.3 程序描述................... ... ....................22
5 测试.....................................................27
5.1 类测试.............................................27
5.2 系统测试...........................................27
5.3 测试结论...........................................35
结束语.....................................................36
致谢.......................................................36
参考文献...................................................36
附录.......................................................37
评语.......................................................