高校教师档案管理系统的设计与实现

四川师范大学本科毕业设计学生考勤管理系统的设计与实现学生姓名学号所在系计算机科学与技术系专业名称计算机科学与技术班级指导教师四川师范大学二○一二年五月四川师范大学本科毕业设计I学生考勤管理系统的设计与实现学生：指导教师：摘要：本高校学生考勤管理系统用JSP+SQLServer2000开发，开发过程中运用了页面模块化、信息发布的动态生成、静态页面显示等技术开发。本论文重点介绍本系统的请假系统、考勤系统两大功能模块设计，完成学生、任课老师、班主任、院系领导、学校领导五类用户功能的设计与实现。关键词：考勤管理在线请假JSP四川师范大学本科毕业设计IIStudents'testsystemdesignandimplementationAbstract：Thesystemisaninformationsystemdesignedforaskingforleaveonlineforstudentsandmanagingattendanceofundergraduate.Itisgenerallydividedintothreemainmodules:themoduleforaskingforon-lineleave,themoduleformanagingattendanceofundergraduateandthemoduleforbackstagemanagement.Therearedifferentcustomersintheuniversityoperatingthesystem,suchasstudent,teacher,ateacherinchargeofaclass,departmentleader,schoolleader,administrator.ThesystemisdevelopedwiththehelpofJcreator,JSP(java、javascript、html)andSQLServer2000.Thekeytechniquesusedintheprocessofdevelopmentare:thepagemodularization,dynamicgeneratingandstaticpageshowingofinformation,etc.Andthethesisfocusesontheintroductionofthesystem’sattendancemanagementandthemanagementofaskingforleaveonline.Anditdevelopsthefunctionofstudent,teacher,ateacherinchargeofaclass,departmentleader,schoolleaderonthewhole.KeyWords：attendancemanagementonlineaskforleaveJSP四川师范大学本科毕业设计III目录1概述...................................................................61.1引言..............................................................61.2开发背景..........................................................61.3问题的描述........................................................62可行性的分析..........................................................72.1引言..............................................................72.2目的和意义........................................................72.3可行性的分析......................................................73需求分析...............................................................83.1引言..............................................................83.2用户需求描述......................................................83.2.1学生用户的需求描述............................................83.2.2任课老师用户的需求描述........................................83.2.3班主任用户需求描述............................................83.2.4院（系）领导用户需求描述......................................93.2.5学校领导用户需求描述..........................................93.2.6系统管理员用户需求描述........................................93.3功能需求描述......................................................93.4系统开发工具.....................................................103.5相关的开发工具简介...............................................103.5.1B/S（浏览器/服务器）简介....................................103.5.2JAVA/JSP简介................................................103.6系统功能划分.....................................................103.7数据字典.........................................................113.8数据流图.........................................................113.9运行需求.........................................................123.9.1最低配置....................................................123.9.2建议配置....................................................124总体设计.............................................................13四川师范大学本科毕业设计IV4.1引言.............................................................134.2系统的布局设计...................................................134.4本人主要的工作任务...............................................145详细设计.............................................................145.1引言.............................................................145.2系统功能的流程图.................................................145.3系统目录的结构设计...............................................155.4数据库的设计与实现...............................................155.4.1实体模型....................................................155.4.2E-R模型图..................................................165.4.3数据库的逻辑设计............................................175.4.4数据库表的创建..............................................175.4.5数据库的建立................................................185.5前端操作页面的设计...............................................185.5.1系统登陆的设计..............................................185.5.2学生用户的功能设计..........................................185.5.3任课老师用户的功能设计......................................195.5.4班主任用户的功能设计........................................195.5.5院系领导用户的功能设计......................................195.5.6学校领导用户功能设计........................................196编码.................................................................206.1用户操作页面的编码...............................................206.1.1系统登陆的编码..............................................206.1.2学生用户功能编码............................................206.1.3任课老师用户功能编码........................................216.1.4班主任用户功能编码..........................................216.1.5院系领导用户功能编码........................................226.2数据库连接池编码.................................................226.2.1数据库连接池程序编码.........................................227软件的测试...........................................................237.1引言.............................................................237.2测试的方