基于java的学生考勤信息管理系统设计摘要学生考勤信息管理系统用于实现学校对在校学生的考勤信息的管理,是典型的管理信息系统。学生考勤信息的手工登记查询,是一项非常繁重而枯燥的劳动。在计算机技师飞速发展的今天,应用数据库技术实现学生考勤信息统计的管理是行之有效的。本文系统地介绍了一个基于java的学生考勤信息管理系统,论述了一个基于java的B/S考勤信息管理系统的设计原理、设计思想及具体的实现过程,对部分架构及设计思想和设计过程作了详细阐述。系统具有师生个人信息管理、请假、增删师生信息等功能,信息管理模块、考勤管理模块和考勤系统模块。本系统开发主要包括后台数据库的建立以及前端应用程序的开发两部分。其一要求建立起的数据库具有完整性和一致性,并具有一定的数据安全性;其二要求程序界面友好、功能完备,通俗易懂。本次发采用HTML、JSP、JS、STRUCTS1、SQLServer2005数据库等技术。本文着重讨论了用JSP技术和SQLServer2005开发考勤管理系统时的数据库访问技术和动态网页制作技术,并给出了部分实现代码。关键词:考勤信息管理系统;java;B/S;SQLserverIBasedonjava&B/SStudentAttendanceInformationManagementSystemDesignAbstractStudentAttendanceInformationManagementSystemisatypicalmanagementinformationsystemusedforimplementingtheschoolstomanagetheirstudentsattendanceinformationinschool.Studentattendanceinformationmanualregistrationqueryisaveryheavyandtediouswork.Intoday'srapiddevelopmentofcomputertechnology,theapplicationofdatabasetechnologycouldbeeffectiveusedonit.ThisarticlesystematicallyintroducesanddiscussesastudentattendanceinformationmanagementsystemandB/Sattendanceinformationmanagementsystembasedonjava,whichincludethedesigntheory,designphilosophyandspecificimplementationprocess.Thesystemcontainsmanyfunctionslikepersonalinformationmanagementofteachersandstudents,leavecases,additionsanddeletions.Italsodividedintoinformationmanagementmodule,attendancemanagementmodule,attendancesystemmoduleandsoon.Thedevelopmentofthissystem,includingtheestablishmentofdatabaseandfront-endapplicationdevelopment.Intheonehand,itdemandsthedatabaseestablishedwithintegrityandconsistencyandacertaindegreeofdatasecurity.Intheotherhand,itshouldhavethefriendlyprograminterface,fullyfunctioningandeasytounderstand.ThisdevelopmentusesHTML,JSP,JS,STRUCTS1,SQLServer2000databasetechnology.ThisarticlefocusesontheproductiontechnologyusingJSPtechnologydevelopmentandSQLServer2000AttendanceManagementSystemdatabaseaccesstechnologyanddynamicwebpages,andgivenpartofthecode.Keyword:attendanceinformationmanagementsystem;java;B/S;SQLserverII目录1前言..............................................................................11.1研究背景........................................................................11.2选题目的及意义..................................................................11.3研究内容........................................................................12系统开发环境与相关技术...........................................................32.1开发技术及开发工具简介..........................................................32.2运行环境........................................................................42.3系统设计思想及处理流程..........................................................43系统需求分析.......................................................................53.1系统可行性研究分析..............................................................53.2可行性分析报告..................................................................53.3系统开发具体研究分析............................................................64系统总体设计.......................................................................74.1系统总体功能层次图..............................................................74.1.1请假审核....................................................................84.1.2考勤情况....................................................................84.1.3考勤修改....................................................................94.1.4退出系统....................................................................94.2总结............................................................................95数据库设计........................................................................105.1数据库需求分析.................................................................105.2数据库表.......................................................................106系统实现..........................................................................146.1密码修改.......................................................................146.2请假...........................................................................156.3请假审批.......................................................................16(1)程序描述......................................................................166.4考勤录入.......................................................................176.5考勤修改.......................................................................197系统维护与测试....................................................................217.1系统的维护.....................................................................217.2系统测试.......................................................................22结论.............................................................................23参考文献...........................................................................25谢辞.............................................................................26III附录.............................................................................2711前言1.1研究背景随着社会的发展,计算机科学日渐成熟,计算机越来越深入到我们的日常生活中,成为我们不可或缺的辅助工具。其强大的功能已为人们深刻认识,它已进入人类社会的各个领域,并发挥这越来越重要的作用,各行各业的人们无须经过特别的训练就能够使用计算机完成许许多多复杂的工作。随着我国人口的增长,高校的生源也日益增加。学校考勤信息的管理作为高校管理的一项日常工作,也随着学生人数的管理而变得繁