摘 要
互联网的普及给人们带来的便利不需多说。因此如果把校园图书馆座位预约与互联网结合起来,利用java技术建设校园图书馆座位预约系统,实现校园图书馆座位预约的网络化。则对于进一步提高国民经济发展,丰富人们的精神生活定能起到不少的促进作用。
校园图书馆座位预约系统能够通过互联网得到广泛的、全面的宣传,让尽可能多的校园图书馆、校园图书馆座位预约者了解和熟知校园图书馆座位预约系统的产品以及产品特色,校园图书馆座位预约系统服务等,不仅为用户提供了服务,而且也推广了自己,让更多的用户了解自己。对于校园图书馆而言,若拥有自己的校园图书馆座位预约系统,通过校园图书馆座位预约系统让校园图书馆的宣传、营销提上一个新台阶,同时提升了校园图书馆形象。
根据本系统的研究现状和发展趋势,系统从需求分析、结构设计、数据库设计,在到系统实现,分别为前端实现和后端实现。论文内容从系统描述、系统分析、系统设计、系统实现、系统测试来阐述系统的开发过程。本系统力求结合实际找出一种切实可行的开发方案,经过反复研究和学习,借助java编程语言、jsp技术、SQLSERVER2008数据库和tomcat服务器来完成系统的所有功能,最后进行系统测试,来检测系统的权限和漏洞,从而将系统完善,达到符合标准。
关键字:校园图书馆座位预约系统,java编程语言,SQLSERVER2008数据库
ABSTRACT
The popularization of the Internet brings convenience to people without needing to say more. Therefore, if the campus library reservation is combined with the Internet, we can make use of Java technology to construct the campus library reservation system, and realize the network of campus library reservation. For the further improvement of national economic development, enriching people's spiritual life will play a lot of promoting role.
Campus library seat reservation system can widely through the Internet and comprehensive propaganda, let as much as possible of the campus, campus library seat reservation understand and familiar with the campus library seat reservation system products and product features, seat reservation system services, such as campus library not only provides service to our customers, but also to promote yourself, let users know more about myself. If for the campus library, has its own campus library seat reservation system, through the campus library seat reservation system to make the campus library of publicity and marketing on a new step, at the same time improve the campus library image.
According to the current research status and development trend of the system, the system is implemented from demand analysis, structural design and database design to the realization of the system and the back-end implementation respectively. The paper elaborates the development process of the system from system description, system analysis, system design, system implementation and system test. The system tries to combine the actual find out a feasible development plan, after repeated research and study, using the Java programming language, JSP technology and SQLSERVER2008 database and the tomcat server to accomplish all functions of the system, and finally to the system test, to detect system permissions and loopholes, thus the system perfect, to conform to the standard.
Key words:Campus library reservation system, Java programming language, SQLSERVER2008 database
目 录
第1章 绪论.............................................................................................................................. 1
1.1开发背景..................................................................................................................... 1
1.2开发意义..................................................................................................................... 1
1.3研究内容..................................................................................................................... 1
1.4论文结构..................................................................................................................... 2
1.5本章小结..................................................................................................................... 2
第2章 系统开发技术的介绍.................................................................................................. 3
2.1MyEclipse与tomcat简介......................................................................................... 3
2.2HTML/CSS简介............................................................................................................. 3
2.3JSP简介....................................................................................................................... 3
2.4SQLSERVER2008数据库概念和特点........................................................................... 4
2.5本章小结..................................................................................................................... 4
第3章 系统分析...................................................................................................................... 5
3.1功能需求分析............................................................................................................. 5
3.2业务流程分析............................................................................................................. 7
3.3数据流程分析............................................................................................................. 7
3.4本章小结..................................................................................................................... 9
第4章 系统设计.................................................................................................................... 10
4.1系统设计思想........................................................................................................... 10
4.2系统总体设计........................................................................................................... 10
4.3系统功能模块设计.................................................................................................... 11
4.4数据库设计............................................................................................................... 12
4.4.1概念模型设计....................................................................................................... 12
4.4.2数据库表设计....................................................................................................... 13
4.4.3数据库连接计....................................................................................................... 16
4.5本章小结................................................................................................................... 16
第5章 系统的实现................................................................................................................ 17
5.1实现环境说明........................................................................................................... 17
5.2前台页面的实现....................................................................................................... 17
5.3登录模块的实现................................................... 18
5.4图书馆座位管理模块的实现......................................... 20
5.5学生信息管理模块的实现........................................... 22
5.6预约信息管理模块的实现........................................... 24
5.7离开信息管理模块的实现........................................... 26
5.9 分页算法的实现................................................... 28
5.10本章小结................................................................................................................. 30
第6章 系统测试.................................................................................................................... 31
6.1测试目的................................................................................................................... 31
6.2界面测试................................................................................................................... 31
6.3功能测试................................................................................................................... 31
6.4测试结果................................................................................................................... 34
6.5本章小结................................................................................................................... 34
第7章 总结............................................................................................................................ 35
致 谢.................................................................... 36
参考文献................................................................. 37