图书管理系统 实训报告

实习（实训）报告

摘要

SQL Server 2000是微软公司推出的大型数据库管理系统，建立在成熟而强大的关系模型基础之上，可以很好地支持客户机/服务器模型。他一操作简单、功能强大、安全性高的特点很好的满足了各种类型的企事业单位构建网络数据库的需求，同时，也成为各类学校学习大型数据库首选地数据库管理系统。 本次实训课程安排40 学时，其中包括实训任务布置、学生确定选题、上机查询资料、系统功能需求分析、数据库设计及实现、简易客户端的开发和实现，客户端和数据库的连接，系统的实现和测试，实训报告的书写总结和提交，要求所有小组在规定学时内完成设计任务。

随着科学技术的不断提高,计算机科学日渐成熟,其强大的功能已为人们深刻认识,它已进入人类社会的各个领域并发挥着越来越重要的作用。

作为计算机应用的一部分,使用计算机对学生档案信息进行管理,具有着手工管理所无法比拟的优点.例如:检索迅速、查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。这些优点能够极大地提高学生档案管理的效率,也是企业的科学化、正规化管理,与世界接轨的重要条件。图书管理系统的建立更进一步的方便了师生对图书的借阅。

尽管在制作的过程中尽了最大的努力来避免错误的发生，但限于水平和时间，不足之处难免有，请见谅。

- I -

实习（实训）报告

插页

系统设计

我们一组作的书图书管理系统，是用于管理图书信息的。用VB编写，结合数据库的应用。目的是为了方便管理图书信息，用户信息，管理员信息，图书借阅，图书归还，权限设置，图书查询，图书出库、入库等功能。其中大致分为图书信息管理、流通管理、读者信息管理、综合查询、系统维护等五大功能。

项目分工

本人所负责的功能模块是管理员信息管理。可对管理员进行添加，删除，也可将普通用户升级成为管理员，或者将管理员降为普通用户。

- II -

实习（实训）报告

目录

摘要 ············································································································································ I 插页 ··········································································································································· II 目录 ·········································································································································· III 一. 需求分析 ······························································································································1

1. 编写目的 ························································································································1 2. 项目背景 ························································································································1 3. 定义 ································································································································1 4. 开发意图 ························································································································2 5. 目标 ································································································································2

5.1 图书信息管理 ·······································································································2 5.2 流通管理 ···············································································································2 5.3 用户信息管理 ·······································································································3 5.4 高级用户（管理员）管理 ····················································································3 6. 运行环境 ························································································································3

6.1 硬件环境 ···············································································································3 6.2 软件环境 ···············································································································3

二. 功能模块的设计与说明 ·······································································································4

1. 整体效果说明 ·················································································································4 2. 各部分功能说明 ·············································································································5 三. 图书管理系统的数据库设计 ································································································6

1. 数据库中各表设计 ·········································································································6 2. 图书管理系统E-R图 ·····································································································8 四. 系统功能实现与说明 ···········································································································9

1. 管理员登录·····················································································································9 2. 主功能窗口·····················································································································9 3. 图书信息管理 ··············································································································· 10 4. 流通管理 ······················································································································ 14 5. 普通用户信息管理 ······································································································· 16 6. 管理员信息管理（重点） ···························································································· 20 五. 总结 ···································································································································· 27 六. 致谢 ···································································································································· 28 七. 参考文献 ···························································································································· 29

- III -

实习（实训）报告

一. 需求分析

1. 编写目的

对于有一定规模的图书馆来说，存书数量大，存书的标识信息更大，而且图书馆也需要对读者及其管理员的信息作记录，以及读者借阅，归还图书的情况，这些汇总起来信息量非常大，如果采用手工管理，效率低，易出错，统计工作量大。鉴于这种情况，一个操作方便，简单实用的图书信息管理系统的开发就成为必要。

2. 项目背景

从第一台个人计算机的诞生至今，计算机已经深入到日常工作和生活的方方面面，成为我们学习和工作的得力助手，比如文字处理、信息管理、辅助设计、图形图像处理、教育培训以及游戏娱乐等。随着越来也多的应用软件出现，人们对它的要求也越来越高；虽然现在世界上的各种软件层出不穷，但他们依然不能满足用户的各种特殊需要，所以人们仍是不得不开发适合图书需求的软件。图书信息管理系统是一个高效化的系统。使用计算机对图书馆中各种信息的管理，具有手工管理无法比拟的优点：信息存储及时，检索迅速、查找方便、可靠性高、存储量大、保密性好、寿命长、成本低等。这些优点能够极大地提高图书馆管理的效率，也是图书馆正规化管理的重要途径，故设计此系统。

3. 定义

项目名称：图书管理系统

本系统能具体化，合理化的管理图书馆中的图书信息、图书流通信息，用结构化的思维方式去了解图书馆的运做。

第 1 页

实习（实训）报告

4. 开发意图

大大提高图书馆的运作效率，使用本系统，可以迅速提升图书馆的管理水平，为增强图书馆张力，提供有效地技术保障。

5. 目标

5.1 图书信息管理

实现对图书基本信息的统一管理，包括新书信息的登记、图书信息的修改，以及图书注销等功能。同时，在每一功能中都能进行基本信息的查询。

·新书登记

当图书馆加入新书时，对新入库图书的基本信息的登记，包括图书的ID、图书的ISBN号，入库时间等信息。

·图书信息修改

实现对图书的各项基本信息的修改维护功能。书号、ISBN号不能改动，其余信息可以改。

·图书信息删除

在图书流动的过程中，难免出现损坏，遗失的情况，此时就要对所对应的图书信息进行删除。 5.2 流通管理

实现图书在流通时的借阅和归还功能 ·图书借阅

实现图书借阅功能。普通用户对存书进行借阅，并记录借阅信息，改变所接图书的状态。

·图书归还

实现图书归还功能。普通用户归还图书时，消除用户的借书信息，并改变所接图书的状态。

第 2 页

实习（实训）报告

这样便缩小了查询范围，更容易找出需要修改信息的图书。 ·图书信息删除

用于删除特定情况下的指定图书信息。

图4_3_6 图书删除查找

同样根据图书的ISBN号进行查找图书 输入“0410214”后点击“提交”按钮 效果如下

图4_3_7 确认删除图书

搜索到结果后，详细信息会出现在右面，点击“确认删除”按钮后，删除所选择图书信息。

如果不知道图书的ISBN号的话，仍旧可以点“我不知道图书ISBN”按钮，具体效果和图4_7类似，不再加以详细说明。

第 13 页

实习（实训）报告

4. 流通管理

流通管理用于对用户借阅和归还图书信息做一个记录，其中图书的状态也 在“已借阅”和“未借阅”中进行转换。 ·图书借阅

用于记录用户对图书的借阅情况

图4_4_1 借阅查询

此窗口需要输入图书的编号，而不是图书ISBN 输入“100045”

图4_4_2 确定借阅

窗口左面仍旧可以搜索新的图书，窗口右面显示所需借阅的图书信息，如确定所借图书便在下方文本框中输入用户的卡号，点击“确定借阅”按钮。这时候

第 14 页

实习（实训）报告

所借图书的状态将会由“未借阅”变为“已借阅”。

借阅信息便会记录到数据库中，如果不知道图书编号，可点击“查看所有图书信息”按钮，从所有图书中进行查找。 ·图书归还

用于用户对所借图书归还信息的记录。

图4_4_3 归还查找

此窗口的整体效果和图书借阅相同，只是跳转的窗口不同。 同样输入“100001”，点击“提交”按钮。

图4_4_4 归还确认

同样左面仍可对图书进行查询，右边显示所查找已借阅图书的信息，点击“确

第 15 页

实习（实训）报告

认归还”按钮，图书的状态便从“已借阅”变为未借阅。

如果不知道图书编号，便可点击“查看搜有已借出图书”按钮。如下图4_4_5

图4_4_5 所有图书

次窗口显示数据库图书信息表中所有状态为“已借阅”的图书信息，选中可直接归还，且提供了多种的查找方式以便更快捷的锁定想要查找的图书。

5. 普通用户信息管理

用于对本体统的普通用户即读者的信息的录入，修改和删除 ·读者信息登录

将新增用户信息录入进数据库，如图4_5_1

图4_5_1 读者信息添加

在各个文本框输入新增用户的个人信息，点击“确定”按钮，添加进数据库。

第 16 页

实习（实训）报告

·读者信息修改

对指定的用户的信息进行更新，修改

图4_5_2 修改用户信息搜索

在文本框中输入所需修改信息的用户ID号码，点击确定来查看并修改其信息。

在其中输入“001” 效果如下图4_5_3

图4_5_3 用户信息修改

用户的所有信息进行显示，但是用户ID是固定的不能修改，其他信息可根据实际情况进行修改，改动后点击确定，更新数据库。

第 17 页

本文来源：https://www.bwwdw.com/article/xo7f.html