目录
摘要：学生考勤管理系统的开发是为了响应我们学校多媒体教室教师无纸化办公的号召，结合当前
各大高校网络自动化办公的发展，更加方便教师对学生考勤的管理系统。该管理系统可以真正实现
跨平台，即可以在 windows 服务器上部署，又可以在 Linux 服务器上部署，这主要归结于它的设计
架构。该学生考勤管理系统分为下面几大功能：班级管理、学生管理、老师管理、请假管理等。系
统包含三类用户：学生、任课老师、辅导员。学生向老师请假，由老师或辅导员通过浏览器登录系
统进行审批。老师可以在课前登录管理系统系统对课程进行查看，对学生进行点名，并且可以查看
学生的请假记录。学生也可以通过登录本系统查询自己的详细信息等。...............................................1
Abstracts: Student attendance management system, more convenient and teachers on student attendance
management system in response to the call of our school the multimedia classroom teachers paperless
office, with major colleges and universities the development of office automation network. The
management system can truly cross-platform, that can be deployed on the windows server, and can be
deployed on a Linux server, mainly due to its design architecture. The student attendance management
system is divided into the following major functions: classroom management, student management, teacher
management, leave management. The system consists of three types of users: students, classroom teacher,
counselor. Students leave to the teacher for approval by the teacher or counselor log on to the system
through the browser. Teacher before class login management system course view, the students named, and
you can view the leave records of students. Students can also check their information by logging into the
system.................................................................................................................................................................2
1 绪论.................................................................................................................................................................3
1.1 研究目的及意义..................................................................................................................................3
1.2 开发背景..............................................................................................................................................3
2 系统可行性.....................................................................................................................................................4
2.1 引言......................................................................................................................................................4
2.2 可行性分析..........................................................................................................................................4
2.2.1 经济可行性..............................................................................................................................4
2.2.2 操作可行性..............................................................................................................................4
2.2.3 技术可行性..............................................................................................................................4
2.3 系统关键技术......................................................................................................................................5
3 需求分析.........................................................................................................................................................8
3.1 用户需求描述......................................................................................................................................8
3.1.1 学生用户...................................................................................................................................8
3.1.2 教师用户...................................................................................................................................8
3.1.3 辅导员用户...............................................................................................................................8
3.2 系统功能划分......................................................................................................................................8
3.2.1 引言...........................................................................................................................................8
3.2.2 班级课程管理模块...................................................................................................................9
3.2.3 在线请假模块...........................................................................................................................9
3.2.4 考勤管理模块...........................................................................................................................9
3.3 系统功能模块图..................................................................................................................................9
3.4 数据流程图..........................................................................................................................................9
4 系统架构及数据库设计..............................................................................................................................12
4.1 系统架构设计....................................................................................................................................12
4.2 数据库设计........................................................................................................................................12
4.3 数据库逻辑实现................................................................................................................................12
4.3.1 系统所有表.............................................................................................................................13
4.3.2 数据库连接池.........................................................................................................................17
4.3.3 数据库的运行与维护.............................................................................................................18
4.3.4 中文乱码处理.........................................................................................................................18
