本 科 生 毕 业 设 计 （申请学士学位）
论 文 题 目 学生在线考勤系统的设计与实现 作 者 姓 名 ******* 所学专业名称 计算机科学与技术 指 导 教 师 *************
2013年 05月 20日
学 生： 学 号：2011220133
论文答辩日期：2013 年 06 月指 导 教 师 ： （签字）日
（签字）
16
目 录
摘要 .................................................................................................................................................. 1 Abstract ............................................................................................................................................. 1 1 绪论............................................................................................................................................. 2 1.1 系统设计的背景 .................................................................................................................... 2 1.2 系统设计的主要意义 ............................................................................................................ 2 1.3 论文的结构 ............................................................................................................................ 2 2 相关技术和理论基础 ................................................................................................................. 3 2.1 JSP简介 .................................................................................................................................. 3 2.2 Mysql简介.............................................................................................................................. 3 2.3 MVC简介 ............................................................................................................................... 3 2.4 Tomcat简介 ............................................................................................................................ 4 2.5 系统结构模式 ........................................................................................................................ 4 3 系统需求分析 ............................................................................................................................. 5 3.1 系统功能概述 ........................................................................................................................ 5 3.2可行性分析 ............................................................................................................................. 6 3.2.1开发的必要性 .................................................................................................................. 6 3.2.2开发的可行性 .................................................................................................................. 6 4 系统设计 ..................................................................................................................................... 7 4.1 总体框架设计 ........................................................................................................................ 7 4.1.1系统布局设计 .................................................................................................................. 7 4.1.2总体结构图 ...................................................................................................................... 8 4.1.3程序流程图 ...................................................................................................................... 8 4.2 数据库设计 ............................................................................................................................ 9 4.2.1数据库需求分析 .............................................................................................................. 9 4.2.2数据库概念结构设计 .................................................................................................... 10 4.2.3数据库逻辑设计 ............................................................................................................ 11 4.2.4数据流图 ........................................................................................................................ 13 5 系统实现 ................................................................................................................................... 14 5.1 系统功能流程图 .................................................................................................................. 14 5.2 登录模块实现 ...................................................................................................................... 14 5.3 后台管理模块实现 .............................................................................................................. 15 5.3.1管理员登录功能实现 .................................................................................................... 15
5.3.2用户管理功能实现 ........................................................................................................ 16 5.3.3课程安排功能实现 ........................................................................................................ 17 5.3.4学年安排功能实现 ........................................................................................................ 18 5.3.5出勤种类功能实现 ........................................................................................................ 19 5.4 考勤管理模块实现 .............................................................................................................. 20 5.4.1查看学生信息功能实现 ................................................................................................ 20 5.4.2管理学生出勤功能实现 ................................................................................................ 21 5.4.3按条件查询学生出勤情况功能实现 ............................................................................ 22 5.5 请假管理模块实现 .............................................................................................................. 23 5.5.1学生在线请假功能实现 ................................................................................................ 23 5.5.2教师审批学生请假功能实现 ........................................................................................ 24 5.5.3按条件查询请假情况功能实现 .................................................................................... 24 6 系统测试 ................................................................................................................................... 25 6.1 测试的重要性及目的 .......................................................................................................... 25 6.2 测试过程 .............................................................................................................................. 26 6.2.1 用户登陆测试 ............................................................................................................... 26 6.2.2 页面使用安全测试 ....................................................................................................... 26 6.2.3系统主要功能测试 ........................................................................................................ 26 结束语 ............................................................................................................................................ 28 参考文献......................................................................................................................................... 29 附录 ................................................................................................................................................ 30 致 谢 ............................................................................................................................................ 42
滁州学院本科毕业设计
学生在线考勤系统的设计与实现
摘要：传统的学生考勤模式在目前高校学生管理中暴露出了许多弊端：如学生请假不方便；
学生请假对任课教师不透明；学生对自己的整体出勤情况的统计信息缺乏了解；院系领导、学校领导不能及时掌握学生上课的出勤情况等。本课题针对上述问题，利用JSP和Mysql设计并实现了学生在线考勤系统。本系统包含三大功能模块：请假管理模块、考勤管理模块、后台管理模块。在系统的实现过程中还综合运用了页面模块化、信息发布的动态生成、静态页面显示等技术。通过使用本系统，任课教师可以在很短的时间内完成学生的考勤、学生的请假等，并将考勤信息存入数据库，方便以后对学生的评定，又可以节省考勤所耗费的时间，使之能够更好的完成教学任务。
关键词：考勤管理；在线请假；JSP；Mysql
Design and Implementation of Online Management System
of Student Attendance
Abstract: The traditional pattern of student attendance management in college has a number of
drawbacks: It is not convenient for student to ask for leave; The leave requests of students are non-transparent for teachers; Lack of the statistical information about their overall attendance in one semester; Faculty leaders, and school leaders can not get the information of student attendance in time, and so on. To address these problems, this project designs and implements the online management system of student attendance. This system consists of three functional modules: the module of asking for leave, checking module, and management module. In addition, In the system implementation process is also integrated use of the page modularity, information dissemination dynamically generated, static pages display technology. By using this system, classroom teachers in a very short period of time to complete the student's attendance, leave and other students, and attendance information into a database, to facilitate future assessment of students, they can save time and attendance time-consuming, so better able to complete the task of teaching.
Keywords: attendance management; online leave; JSP; Mysql
1
