摘要
信息管理是一项古老的活动，但管理方式却没有停止过变化，从手工记录到计算机存储，从平面文件到关系型数据库；从单机单用户数据库访问模式到客户/服务器模式，从客户/服务器模式到浏览器/服务器...信息管理的技术越来越先进、科学和客观。同时，可管理的信息容量也越来越大，更适应信息膨胀时代的要求。
学生个人信息系统（MIS)是一个具有交互功能的人才信息管理系统，其开发主要包括后台数据库的建立和维护以及前台程序的开发两个方面。对于前者要求建立起数据一致性和完整性强、数据安全性好的库。而对于后者则要求应用程序功能完备,易使用等特点。
因此本人结合网站数据库开发的要求，对MS SQL Server2000数据库管理系统、SQL语言原理、JSP应用程序设计等进行了较深入的学习和应用，主要完成对网上信息管理系统的功能需求分析、功能模块划分、数据库设计，并由此设计了数据库结构和应用程序。
根据需求，本系统设计实现分为：第一、概要性地介绍了本系统开发的目的、系统开发的背景等，第二、对该系统设进行设计分析，对系统功能分析以及模块划分定义，第三、系统数据库的设计，第四、根据第二部分对系统功能分析以及功能模块的划分，对个功能模块进行分析实现，并列出了一些程序代码以说明该系统应用程序设计中所采用的技术。
关键词：学生个人信息系统 JSP 管理系统
Abstract
Information management is an ancient activity, but management has not stopped changing from manual records to the computer store, from flat files to relational databases; from stand-alone single-user database access mode to client / server model, from a client / server mode to the browser / server ... and more advanced information management technologies, scientific and objective. At the same time, can manage the information capacity is also growing, but also to adapt to expansion of information demands of the times. Student Personal Information System (MIS) is a interactive features of the human resources information management system, its development include the establishment and maintenance of back-end database as well as the front two aspects of the development process. Fothe former require the establishment of data consistency and integrity of the strong data security and goodlibraries. For the latter procedure requires the application of full-featured, easy to use and so on. Therefore, I link a website database development at the request of MS SQL Server2000 database management system, SQL language principles, JSP application design for a more in-depth study and application, mainly to complete the web-based information management system functional requirements analysis, functional module division , database design, and thus designed the database structure and applications.
According to requirements, design implementation of this system is divided into: first, briefly, describes the purpose of this system development, system development background, and secondly, the system design based analysis, functional analysis, and module division system, the definition of Third, the system database design, fourth, according to the second part of the system function analysis, as well as the delineation of functional modules for analysis of functional modules to achieve, and lists some of the program code to illustrate the application of the system used in the design of technology.
Keywords: Student Personal Information System JSP Management System
前 言
随着计算机产业的迅速发展，电子计算机已广泛的应用于信息管理、文字处理、辅助设计、辅助教学及人们的日常生活中。特别是在计算机的操作系统具有了图形化的界面后，使用计算机已经不再是某些专业人员的专利，各行各业的人们不需要经过专业化的训练就能自如的在计算机上进行各种复杂的操作。
时下，为了能创造更大的经济效益和社会效益，更有利于参与国际竞争，越来越多的企业、公司和学校迫切需要引入现代化的管理手段，而计算机的大容量操作，精确的计算，使它成为企业管理不可缺少的手段之一，但随着计算机应用的不断深入，用户对软件的需求也不断增加，越来越多的用户希望拥有适合自己需要的特殊软件来满足自己的特殊要求。
本毕业设计题目的选定应该说是顺应这一趋势的。对于当今大学校园内的学生个人信息来说，其数据量大，各种信息管理内容复杂，查询和管理学生信息和校园内的宿舍信息等工作由人工完成将是很累的，也许还很不切实际，不仅浪费了许多人力物力资源，而且还很容易出现差错，有一个符合要求的软件对其进行智能化的学生个人信息管理是最好不过的，节省了人力物力资源，并且对各种信息的把握和操作也更加方便了，对所有信息有了一个全局的掌握。
系统功能简介：
在系统中，充分利用了SQL Server 2000数据库和JAVA 6.0的强大功能，通过实践，也使自己对这些方面有了较深入的了解。在设计过程中力求完善系统功能，使界面友好，具有一定的容错能力，在使用过程中不会出现难以纠正的错误和毛病。
该系统主要提供的功能分别为添加学生数据，修改学生数据，住宿分配，住宿调整，学生情况查询，宿舍使用情况，活动信息录入，活动查询，学生奖惩录入，学生奖惩查询，添加用户，修改密码，退出系统等，这些功能基本上覆盖了学生个人信息的主要部分。
目 录
第一章 系统概述 ···················································································································· 1
1.1 课题来源及意义 ······················································································································· 1
1.2 开发工具及相关技术简介 ········································································································ 1
1.2.1 开发工具 ······················································································································· 1 1.2.2 相关技术简介 ··············································································································· 2
第二章 可行性研究及需求分析 ···························································································· 6
2.1 可行性研究 ······························································································································· 6 2.2 系统需求分析 ··························································································································· 6
2.2.1 用户登录需求分析 ········································································································ 7 2.2.2 系统的运行环境 ············································································································ 7 2.3 系统流程图 ······························································································································· 8 2.4 系统功能模块图 ······················································································································· 9
2.4.1 系统功能分析 ··············································································································· 9 2.4.2 系统模块设计 ··············································································································· 9
第三章 学生个人信息系统数据库设计 ·············································································· 10
3.1 设计SQL Server数据库 ·········································································································10 3.2 建立表结构 ······························································································································12
第四章 学生个人信息系统的设计 ······················································································ 13
4.1 系统总体功能模块 ··················································································································14 4.2 学生信息管理 ··························································································································14 4.4 课程信息管理 ··························································································································14
第五章 学生个人信息系统的实现 ······················································································ 15
5.1个人信息管理 ···························································································································15
5.1.1 用户登录页面 ··············································································································15 5.1.2 用户注册页面 ··············································································································16 5.1.3 修改用户密码页面 ·······································································································18 5.2 课程信息信息管理模块的创建 ·······························································································19
5.2.1 分配宿舍信息页面 ·······································································································19 5.2.2 修改课程信息页面 ·······································································································20 5.2.3 查询课程信息页面 ·······································································································21 5.3 好友基本信息管理模块的创建 ·······························································································22
5.3.1 添加好友信息页面 ·······································································································22 5.3.2 修改好友信息页面 ·······································································································23 5.3.3 查询好友信息页面 ·······································································································24 5.4 奖惩管理模块的创建 ··············································································································25
5.4.1 新增奖惩信息页面 ·······································································································25 5.4.2 查询奖惩信息页面 ·······································································································26 5.5 活动管理模块的创建 ··············································································································27
5.5.1活动录入页面 ···············································································································27 5.5.2 活动信息查询页面 ·······································································································28 5.5.3 活动信息的修改页面 ···································································································29
5.6 重要文档管理模块的创建 ·······································································································31
5.6.1 重要文档信息录入页面 ·······························································································31 5.6.2 重要文档列表页面 ·······································································································32
第六章 测试 ·························································································································· 32
6.1 软件测试的目的和原则···········································································································32 6.2 系统测试 ·································································································································34
6.2.1 测试方法 ······················································································································34 6.2.2 测试总结 ······················································································································34
结 论 ······································································································································ 35
谢 辞 ······································································································································ 36 参考文献 ·································································································································· 37