学生信息管理系统(论文)
六安职业技术学院毕业
设计(论文)
学生信息管理系统
姓
学
班
名:
号:
级:
指 导 教 师:
何 洋 洋
20103115
软件 1002
申 子 明
所 在 系 部:
信息工程系
二○一三年六月
I
学生信息管理系统(论文)
毕业论文(设计)开题报告
学生姓名
何洋洋
班级
软件 1002
指导教师
申子明
学号
20103115
毕业论文(设计)题目
学生信息管理系统(java)
在学生信息管理系统的设计与实现的过程中,应按照软
件工程学生命周期的各个阶段为依据,具体结合应用软件工
程的知识与技术,最终反映用户的实际需求,实现系统设计的
目的,感受软件工程学的指导意义。
……………………………………………………………………………………
……………………………………………………………………………….
通过本论文课题的研究,预计达到:
对系统能做到以下几点:
1> 对学籍的管理:对学生的学籍信息进行管理
2> 对班级的管理:对各年级的班级进行管理
3> 对课程的设置:能对各年级的课程进行添加,修改等操作或添加新的课
程,删除以前的课程
4> 对成绩的管理:对学生的各学期的考试成绩进行录入,修改,查询等操
作
具体安排进度:
2013 年 3 月 1 日—3 月 30 日,指导教师与学生见面,指导学生选题,初步
查找资料,收集相关信息;
2013 年 4 月 1 日—4 月 30 日,在查找资料的基础上,准备拟稿。;
2013 年 5 月 1 日—5 月 31 日,完成稿件,并最后修改定稿。最后准备答辩。
II
学生信息管理系统(论文)
毕业论文(设计)成绩评定
指
导
教
师
意
见
答
辩
专
家
组
意
见
系
专
业
教
学
委
员
会
意
见
III
学生信息管理系统(论文)
摘要
随着计算机网络技术发展,Web 数据库技术已经成为应用最为广泛的网站架构基础技
术在应用系统中,Web 提供了与用户进行通信联络的有效手段,利用 Web 技术,实现 Web
服务器与数据库系统的连接,完成对数据的处理与查询,用户可以通过操作简单易学的浏
览器来查询处理所需要的各种数据。
学生信息的管理是学校日常工作中的重要组成部分。高校招生规模的逐步扩大和认识
制度的改革,在校学生人数将不断增加,而学生管理人员则相对减少。加上我国高等学校
基层学生管理工作的头绪多,内容杂,管理细,要求高,传统管理办法已基本不适应新形
势的要求。在校生的基本信息的管理,选课及成绩的信息的管理,学生学籍的管理,稍有
不慎就会出现错误。因此,在计算机飞速发展的今天,应用数据库技术实现学生信息的管
理是可行而必要的工作,实现高校学生信息网上管理,既能够提高工作效率,又可以提高
工作水平。
关键字:JAVA 学生信息管理系统 SQL Server
Abstract
Along with the computer network technology development, Web database technology has
become the most widely used web architecture based technology in the application system, Web
provides the user with the means to communicate effectively, using the technology of Web, Web
server and database system connection, the completion of the data processing and query, the user
can through simple operation browser a query processing needs of the various data.
Student information management schools is an important part in daily work.University
enrollment scale and gradually expand the understanding of the reform of the system, the number
of students will continue to increase, while the student staff to be relatively reduced.With our
IV
学生信息管理系统(论文)
country's basic level of colleges and universities students management work idea, content is
miscellaneous, management of small, high requirements, the traditional management approach
has been basically does not adapt to the requirement of new situation.Students the basic
information management, selection and performance of information management, student
management, have a bit inadvertent error occurs.Therefore, in today's rapid development of
computer, the application of database technology to achieve the management of student
information is feasible and necessary work, college students information management, which can
improve the work efficiency, but also can improve the working level.
Keywords: student information management system SQL Server JAVA
V
学生信息管理系统(论文)
目 录
第 1 章 绪论 ····································· 1
1.1 引言 ······································· 1
1.2 问题的定义 ···································· 1
1.3 系统介绍 ····································· 1
1.3.1 系统目标 ·················································································································································· 2
1.3.2 业务流程图·············································································································································2
第 2 章 可行性研究 ··································· 5
2.1 技术可行性 ·················································································································································5
2.2 经济可行性 ·················································································································································5
2.3 操作可行性 ·················································································································································5
2.4 法律可行性 ·················································································································································5
第 3 章 需求分析 ···································· 7
3.1 系统需要解决的主要问题 ························································································································ 7
3.2 系统具备的基本功能 ································································································································ 7
3.3 数据流图 ·····················································································································································7
3.4.1 数据存储·············································································································································· 9
3.4.2 数据流·················································································································································· 9
3.4.3 数据处理············································································································································ 10
第 4 章 总体设计 ··································· 11
4.1 概述 ···························································································································································11
4.2 系统学生子功能划分 ······························································································································ 11
4.3 学生子系统功能描述 ······························································································································ 12
4.4 数据库概念结构设计 ······························································································································ 12
4.5 数据库设计 ···············································································································································14
4.6 安全保密设计 ·········································································································································· 14
4.6.1 登陆用户的安全性 ·························································································································· 14
4.6.2 数据安全性 ······································································································································ 14
第 5 章 详细设计 ··································· 15
5.1 概述 ···························································································································································15
5.2 程序流程图 ···············································································································································15
5.3 学生子系统的实施 ·································································································································· 16
结 论 ········································ 24
致 谢 ········································ 25
参 考 文 献 ····································· 25
VI
学生信息管理系统(论文)
第 1 章 绪论
1.1 引言
随着科学技术的不断提高,计算机科学日渐成熟,其强大的功能已为人们深刻认识,
它已进入人类社会的各个领域并发挥着越来越重要的作用。随着计算机网络技术发展,Web
数据库技术已经成为应用最为广泛的网站架构基础技术在应用系统中,Web 提供了与用户
进行通信联络的有效手段,利用 Web 技术,实现 Web 服务器与数据库系统的连接,完成对
数据的处理与查询,用户可以通过操作简单易学的浏览器来查询处理所需要的各种数据。
1.2 问题的定义
学生信息的管理是学校日常工作中的重要组成部分。高校招生规模的逐步扩大和认识
制度的改革,在校学生人数将不断增加,而学生管理人员则相对减少。加上我国高等学校
基层学生管理工作的头绪多,内容杂,管理细,要求高,传统管理办法已基本不适应新形
势的要求。在校生的基本信息的管理,选课及成绩的信息的管理,学生学籍的管理,稍有
不慎就会出现错误。同时学生成绩的手工登录与查询,是一项非常繁重而枯燥的劳动,每
年课程的变化都需要重新规划,耗费许多人力和物力,而且会因人的情绪烦燥而出现失误。
因此在计算机飞速发展的今天,应用数据库技术实现学生信息的管理是可行而必要的工
作,实现高校学生信息网上管理,既能够提高工作效率,又可以提高工作水平。
1.3 系统介绍
学生信息管理系统是典型的信息管理系统,本系统采用 B/S 的设计结构,其开发主要
包括后台数据库的建立和维护以及前端应用程序的开发两个方面。对于前者要求建立起资
料一致性和完整性强、资料安全性好的库。而对于后者则要求应用程序功能完备,易使用
等特点。学生信息管理系统是一个学校信息化管理的重要组成部分,不但能实现学生网上
成绩查询,同时也为学校管理者提供充足的信息和快捷的查询手段。但一直以来人们使用
传统人工的方式管理学生信息,这种管理方式存在着许多缺点,如:效率低、保密性差,
另外时间长了,将产生大量的文件和资料,这对于查找、更新和维护都带来了不少的困难。
1
1.3.1 系统目标
学生信息管理系统(论文)
现在我国的学校中学生信息的管理水平大多还停留在纸介质的基础上,这样的机制已
经不能适应时代的发展,因为它浪费了许多人力和物力,在信息时代这种传统的管理方法
必然被计算机为基础的信息管理所取代。
采用计算机来实现学生信息管理系统归纳起来,好处大约有以下几点:
1. 可以存储历届的学生信息,安全、高效;
2. 只需一到二名信息录入员即可操作系统,节省大量人力;
3. 可以迅速查到所需信息。
4. 为将来学校上网做好准备。
学校学生可以在任何一个角落查询自己的成绩信息,不受时间、地点限制。
根据要求,本系统模块具体实现如下的功能:
1. 实现学生网上成绩查询的功能。学生可以在网上查询自已每门课的成绩信息。
2. 实现对学生个人信息查询的功能。学生可以在网上查询自已的个人信息。
3. 实现对学生课表查询的功能。学生可以在网上查询自已的课表信息。
4. 实现对学生用户密码修改的功能。学生可以在网上修改自己的用户密码。
1.3.2 业务流程图
业务流程描述:用业务流程图描述现系统各项业务处理过程,并结合业务流程图详细
准确地说明业务处理过程中数据的收集、输入、传递、存储、加工的方法、算法、输出的
数量及形式等。
现行系统的业务流程图是分析和描述现行系统业务的重要工具之一。其主要作用是:
描述现行系统的业务情况以便于与管理人员交流,它是系统设计的前提和保证。业务流程
图使用的符号:
符
号
名
称
实体
输入/输出
的报表
处 理
业务流向 文档
存储
2