宿舍管理系统论文

本 科 生 毕 业 设 计

设计题目: 基于JSP+SQL 的图书馆管理系统的

的设计与开发

学生姓名： 学生学号: 指导教师： 二级院系： 专业班级： 完成时间：

目 录

Abstract ................................................................................................................................................................ IV 第1章 概述 ................................................................................................................................................................... 1

1.1 课题背景 ......................................................................................................................................................... 1 1.2 课题意义 ......................................................................................................................................................... 1 1.3 文献综述 ......................................................................................................................................................... 2

1.3.1 技术综述 ............................................................................................................................................. 2 1.4 总体设计原则 ................................................................................................................................................. 2 第2章 系统分析 ........................................................................................................................................................... 4

2.1 系统的需求分析 ............................................................................................................................................. 4 2.2 业务流程分析 ................................................................................................................................................. 5

2.2.1 系统管理员业务流程分析 ................................................................................................................ 5 2.3 数据流程分析 ................................................................................................................................................. 7

2.3.1 图书类别管理模块 ............................................................................................................................ 7 2.3.2 图书管理模块 .................................................................................................................................... 7 2.3.3 读者管理模块 .................................................................................................................................... 8 2.3.4 图书借阅模块 .................................................................................................................................... 8 2.3.5 修改密码模块 .................................................................................................................................... 9 2.4 数据字典 ......................................................................................................................................................... 9

2.4.1 数据项的描述 .................................................................................................................................... 9 2.4.2 数据流的描述 .................................................................................................................................. 11

第3章 系统设计 ......................................................................................................................................................... 12

3.1 系统体系结构设计 ....................................................................................................................................... 12 3.2 系统子模块功能介绍................................................................................................................................... 12 3.3 数据库设计 ................................................................................................................................................... 13

3.3.1 数据库概念设计——E-R模型 ...................................................................................................... 13 3.3.2 数据库逻辑设计——关系模型 ...................................................................................................... 14 3.3.3 数据库选型 ...................................................................................................................................... 14 3.3.4 数据库表结构设计 .......................................................................................................................... 14

- I -

3.3.5 数据库表间关系设计 ...................................................................................................................... 16 3.4 系统开发工具与开发模式的选择 .............................................................................................................. 17

3.4.1 系统开发工具 .................................................................................................................................. 17 3.4.2 系统设计模式 .................................................................................................................................. 19

第4章 系统实现 ......................................................................................................................................................... 21

4.1登陆模块 ........................................................................................................................................................ 21 4.2 图书类别管理模块 ....................................................................................................................................... 24 4.3 图书管理模块 ............................................................................................................................................... 27 4.4 读者管理模块 ............................................................................................................................................... 29 4.5 图书借阅管理模块 ....................................................................................................................................... 31 第5章 系统测试 ......................................................................................................................................................... 34

5.1 测试目的 ....................................................................................................................................................... 34 5.2 测试方法 ....................................................................................................................................................... 35 5.3 测试结果 ....................................................................................................................................................... 35 第6章 总结 ................................................................................................................................................................. 36 参 考 文 献 ................................................................................................................................................................. 36

致 谢 .............................................................................................................................................................. 38

- II -

摘 要

本文对图书馆管理系统的设计与开发过程进行了分析与叙述。依照系统开发的实际操作步骤，文章从系统概述、系统分析、系统设计和系统实现这四大章节对系统开发过程进行分别阐述。系统概述中主要进行了课题背景、课题意义和现状分析；系统分析中主要包括了系统设计前的需求分析、业务流程分析、数据流程分析和数据字典分析；而系统设计则是对系统体系结构、各功能模块、数据库结构设计等具体的系统实现过程进行剖析展示，在系统设计章节中有详细的文字解释并配有表图说明。文章还列举了关键的功能模块实现代码。

本文力求可以为图书馆管理系统的开发设计找到一种切实可行的解决方案，在分析了目前国内外图书馆管理系统的现状的基础上，并经过反复摸索和学习研究后，借助编程语言JSP和SQL 数据库最终实现了图书馆管理的开发，并在一系列测试后，达成了人性化、所需功能完善、操作清晰的设计目标。 关键词：JSP；SQL Server 2005；图书

- III -

Abstract

In this paper, book management system design and development process is analyzed and described. In accordance with the actual steps of system development, the article from the system overview, system analysis, system design and system realization of these four sections of the system development process are described. System were the main issues outlined in the background, meaning and status of the subject analysis; system analysis, system design includes a pre-needs analysis, business process analysis, data flow analysis and data dictionary analysis; and system design is the system architecture, various functional modules, database structure design to achieve specific process to analyze the system display, the system design section to explain in more detail and with a table diagram shows. The article also lists the key function module code

This paper seeks to book management system for development and design to find a practical solution in the analysis of -Bo at home and abroad on the basis of the status of the system, and after repeated exploration and study after study, using JSP and soft SQL programming language Server database and ultimately the book management system development, and in a series of tests, reached a user-friendly, functional requirements, operations designed to clear

Key Words：JSP；SQL； Book

- IV -

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