摘 要
本系统是按照管理信息系统的开发步骤，以上海农林职业技术学院图书馆的应用需求为背景，设计开发的学校图书馆管理系统。本文介绍了在 Visual Studio .NET环境下使用asp.net和SQL Server数据库，开发本系统的详细过程。本系统主要面向三类用户：管理员、读者和所有用户，按照他们各自的权限，可以对本系统进行不同的操作。并实现了从图书的录入到查询修改，从书目查询到图书的借阅、还书和续借，从读者的录入到查询修改，形成了一个整体自动化管理模式。
关键词：数据库，管理信息系统，窗体，asp.net
Abstract
This system is according to the development step of the management information system, regard application demand of the technological institute''s library of the job of agriculture and forestry in Shanghai as the background, design the administrative system of school library developed. The introduction to this text is in Visual Studio use asp.net and SQL Server database under the environment, develop the detailed course of this system. This system faces three kinds of users mainly: All administrator, reader and users, according to their own authorities, can carry on different operation to this system. The ones that have realized from the books input it to inquiring about revising , the ones that inquired from booklist to the books borrowed, returning the book and renewing, inputting it to inquiring about revising from readers, has formed a whole automatic management mode.
Keywords: database, MIS, Window body, asp.net
目录
第一章 系统概述 1
1.1 背景简介： 1
1.1.1 上海农林职业技术学院 1
1.1.2 上海农林职业技术学院图书馆 1
1.2 开发目的 1
1.3 开发工具简介： 2
1.3.1 asp.net简介 2
1.3.2 Visual Studio .NET 简介 3
1.3.3 MSSQL Server 简介 3
1.4 开发特点 4
第二章 系统分析 6
2.1 可行性分析 6
2.1.1 经济可行性 6
2.1.2 技术上的可行性 6
2.1.3 管理上的可行性 6
2.2 详细调研 6
2.2.1 系统环境调研 6
2.2.2 组织机构调研 7
2.2.3 系统业务流程图 8
2.2.4 系统数据流程图 8
2.3 系统化分析 9
2.3.1 系统目标的分析 9
2.3.2 原系统存在的问题 9
2.3.3 系统功能分析 10
第三章 系统设计 11
3.1 系统结构设计 11
3.1.1 系统体系结构设计 11
3.1.2 系统总体流程设计 11
3.2 数据库设计 14
3.2.1 数据库设计原则 14
3.2.2 数据库的概念结构设计 14
3.2.3 数据库的逻辑结构设计 16
第四章 页面设计及实现 19
4.1 页面设计原则 19
4.2 主页设计 20
4.3 读者页面 21
4.3.1 读者登录页面 21
4.3.2 读者信息页面 22
4.3.3 借阅情况页面 22
4.3.4 借阅证挂失页面 23
4.3.5 读者密码修改页面 24
4.4 管理员页面 25
4.4.1 管理员登录页面 25
4.4.2 图书馆管理页面 25
4.4.3 图书添加页面 26
4.4.4 用户信息维护页面 28
4.4.5 用户信息修改页面 28
4.4.6 罚款信息统计页面 29
4.4.7 图书借阅页面 29
4.5 书目查询页面 33
4.5.1 普通查询页面 33
4.5.2 高级查询页面 34
4.5.3 书目详细信息页面 36
第五章 系统调试与评价 38
5.1 系统调试 38
5.1.1 分调 38
5.1.2 联调 39
5.2 系统评价 39
第六章 结论 41
参考文献 42
Abstract
This system is based on management information system development process, with Shanghai Agriculture and Forestry Vocational & Technical College Library in the context of application requirements, design and development of school library management system. This article describes the Visual Studio. NET environment, using asp.net and SQL Server databases, development of detailed process of the system. This system is mainly for the three types of users: administrators, readers and all users, in accordance with their respective competence, you can operate the system differently. And implemented from the book''s entry to the query modification, from the bibliographic query to borrow books, but also books and Renewal, from the reader''s entry to the query modification, forming an overall automated management model.
Key words: database, management information systems, forms, asp.net
Abstract
This system is according to the development step of the management information system, regard application demand of the technological institute''s library of the job of agriculture and forestry in Shanghai as the background, design the administrative system of school library developed. The introduction to this text is in Visual Studio use asp.net and SQL Server database under the environment, develop the detailed course of this system. This system faces three kinds of users mainly: All administrator, reader and users, according to their own authorities, can carry on different operation to this system. The ones that have realized from the books input it to inquiring about revising, the ones that inquired from booklist to the books borrowed, returning the book and renewing, inputting it to inquiring about revising from readers, has formed a whole automatic management mode.
Keywords: database, MIS, Window body, asp.net
Directory
Chapter 1 System Overview
1.1 Background: 1
1.1.1 Shanghai Agriculture and Forestry Vocational and Technical College 1
1.1.2 Shanghai Agriculture and Forestry Vocational and Technical College Library 1
1.2 Development Objective 1
1.3 Development Tools Description: 2
1.3.1 asp.net Introduction 2
1.3.2 Visual Studio. NET Introduction 3
1.3.3 MSSQL Server Introduction 3
1.4 Development Characteristics 4
Chapter II Analysis 6
2.1 Feasibility Analysis 6
2.1.1 economic viability 6
2.1.2 the technical feasibility of 6
2.1.3 the management of the feasibility of 6
2.2 Details of Research 6
2.2.1 System Environment Research 6
2.2.2 Organization Research 7
2.2.3 System operational flow chart of 8
2.2.4 System Data Flow Chart 8
2.3 The systematic analysis of nine
2.3.1 Analysis of nine system objectives
2.3.2 Problems in 9 of the original system
2.3.3 System Function Analysis 10
Chapter III System Design 11
3.1 System Architecture Design 11
3.1.1 System Architecture Design 11
3.1.2 System Overall Process Design 11
3.2 Database Design 14
3.2.1 Database Design Principles 14
3.2.2 The concept of structural design of the database 14
3.2.3 Logical database structure design 16
Chapter IV page design and implementation of 19
4.1 Design Principles Page 19
4.2 Home Design 20
4.3 Readers Page 21
4.3.1 Readers login page 21
4.3.2 reader information page 22
4.3.3 Borrowing of page 22
4.3.4 report the loss of library card Page 23
4.3.5 Readers password change page 24
4.4 Administrator Page 25
4.4.1 the administrator login page 25
4.4.2 Library Management Page 25
4.4.3 Book Add Page 26
4.4.4 User Information Maintenance page 28
4.4.5 User Information edit page 28
4.4.6 Penalty Information Statistics Page 29
4.4.7 Borrowing books page 29
4.5 Bibliographic query page 33
4.5.1 General query page 33
4.5.2 Advanced Search page 34
4.5.3 Bibliographic Detail Page 36
Chapter V system test and evaluation 38
5.1 system debugging 38
5.1.1 Sub-adjusted 38
5.1.2 FBI 39
5.2 System Evaluation 39
Chapter VI Conclusion 41
References 42
