本系统主要针对目前高校学生在线请假以及学生上课出勤管理而设计的信息系统。本系统总体上由三大功能模块:请假系统模块、考勤系统模块、后台管理模块组成。系统涉及到高校三大类用户:学生、任课老师、系统管理员。
本高校学生考勤管理系统用JSP+SQL Server 2000开发,开发过程中运用了页面模块化、信息发布的动态生成、静态页面显示等技术开发。本论文重点介绍本系统的请假系统、考勤系统两大功能模块设计,完成学生、任课老师、系统管理员三类用户功能的设计与实现。
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001754s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.184535s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001004s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001197s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001008s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003141s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000822s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004110s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025892s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001256s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 42302 [ RunTime:0.025231s ]